Auto Increment ID on External DB

[baruchiro]

I connected my external MySQL database with a few existing tables.

I created a form from one of the tables, but

1. I can't save it because I must set a value for the id column.
2. (I saw this error on the HTTP response on the DevTools, no error was exposed to the user because I hid the id input textbox)

Is this how it works with external DB? It can't ignore the id column to let the DB itself generate it.

Is there any workaround for this, such as making the input ReadOnly and generating a default number somehow?

[ConorWebb96]

Hey @baruchiro,

Set a primary key using a sequence. Budibase will treat this field as non-editable, your database will handle automatically increasing its value with each new record.

I hope this makes sense.