Is it possible to have incremental ids automatically?

App Building
1

I have an id field. I put entries into a DB via retool. Can I use retool to increment the id with each new entry? So I don't overwrite an entry by giving it the same id? Because I put them in manually via the form:

image

, and now, it looks like this;

image

I checked out this topic, and it seems a code to add +1 isn't quite working.

2

Yes, make the ID column in the db as type serial - this will auto-increment the id every time a new record is added.

2 Likes
3

I bet I have to remake my DB for the umpteenth time to retroactively add that, ha! Thank you!