Goal: Insert two sets of opening and closing hours for a business into supabase. The first set is mandatory, the second set is optional. Issue: The first set inserts correctly into supabase with the right business_id from a previous query. But the second set, when empty, does not return the cor…

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_second…

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

💬 Queries and Resources

MiguelOrtiz June 4, 2024, 8:20pm 9

And due to a lack of appropriate emojis I'll keep responding OH THATS FIRE!...

1 Like

React to topics from first time posters with :wave:

Topic		Replies	Views
Default param, rest param and built-in arguments obj 💬 Feature Requests workflows	6	111	February 12, 2026
Problem with NULLs being turned into empty strings in Select in Form, (setting default in Select helped) 💬 App Building	10	494	August 4, 2025
Queries and additional scope 💬 App Building sql , additionalscope	10	448	June 9, 2025
Get Rid of Page Feature 💬 App Building	40	627	September 4, 2025
What used to work flawlessly now breaks (insert into t-sql) 💬 Queries and Resources bug , sql	4	1625	January 4, 2024

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

Related topics