Data type "time" when empty cannot be inserted into supabase as null value

💬 Queries and Resources
,
2

Hello!

You might be able to make use of an inline ternary operation to send a valid NULL value instead of the null string "". These take the form of {{ condition ? result if true : result if false }}. In your case, for each of the secondary values you can update with the following:

{{monday_secondary_open.value}} ->
{{monday_secondary_open.value == "" ? NULL : monday_secondary_open.value}}

and

{{monday_secondary_close.value}} ->
{{monday_secondary_close.value == "" ? NULL : monday_secondary_close.value}}