Insert rows without primary key in supabase

Database & APIs

I am trying to insert a row in a supabase table. The table has a primary key which has a default, autogenerated value. When i use the Backend Call > Supabase > Insert Row I have to set a id, however if I leave this blank the request fails. Also, if I remove the field from the query FlutterFlow wont compile.

I have not set up RLS or any other restrictions for this project(yet).

What have you tried so far?

Updating the schema (in case I was out of sync)
Setting ID to null
Setting ID to empty string

I created a custom action which does the query but dosen set the primary key field, that worked. Yes, I can use this action but I dont want to make custom insert actions for all my tables

Did you check FlutterFlow's Documentation for this topic?

7 replies