Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?
SaaS
What are the exact steps to reproduce this issue?
Why is my ID No. auto increment skipping values?
Note 1 - My Country and Timezone is Australia (Brisbane), Date format used is DD/MM/YYYY
Note 2 - The problem seems to occur roughly 80% of the time, but is not consistant.
- I have a simple job management database. I use the Row ID No. as the “job number”. I use a baserow form to enter new jobs. The Row ID doesn’t appear on the form.
- When I enter a first new job of any given day, the Row ID No. often auto increments skipping many values. Eg. the last ID number yesterday (28 Jan 2025) was 1016. New job taken entered today (29 Jan 2025) saved as 1049.
- Subsequent jobs entered on same day increment by 1 as normal.
- See attached screenshots showing the result of the new jobs entered with the gaps on ID Numbers.
- I have no idea what is causing the missed ID numbers from auto increment and hoping someone can shed light / advise of a fix? Thanks kindly.