Inserting Rows to table without Primary Key

Hi,

how is it possible to insert a row into a table (postgres, insert row action) without specifying columns like the primary key (which is an autoincrement field and should be populated by the db itself)? This also would apply to further columns, which might have a default value in the db.

Normal insert tries to insert e.g. a 0, if I have a field within the form. Without I receive an error. If I try to remove the field from the forms json object with $$.lodash.omit(…), I also receive an error.

Changing to specifying the fields within the insert row action also doesn’t bring me further, because I can’t remove fields there.

Any suggestions? Thanks

image

1 Like

I was able to work around the issue by setting the Form Props, Data value to “New Entry”. It automatically adds fields for each column. Then I just hid the id column.

1 Like