Generate sequential id after form submission

Hello,
I have an “id” column in my table. How can I generate sequential “id” after submitting the form?

|id|First name|Last name|
|1|John|Doe|
|2|Mary|Jane|
|3|Raplh|Smith|

I.e. after creating a new record “Tony Jones”, id=4 should be added automatically.

Change the ID field to an “autonumber” type.

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.