Row Identifier / ID No. is skipping values auto incrementing

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.

  1. 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.
  2. 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.
  3. Subsequent jobs entered on same day increment by 1 as normal.
  4. See attached screenshots showing the result of the new jobs entered with the gaps on ID Numbers.
  5. 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.

Attach screenshots, videos, or logs that demonstrate the issue.


Hey @SpireBM, welcome to the Baserow community! :wave:

Thank you for sharing the steps to reproduce the issue. I’ve shared it with the development team. We had a similar issue reported here in the past: Adding new rows screws up Autonumber and Row ID#, though we weren’t able to replicate it. Hopefully, we will identify the cause this time. :raised_hands:

1 Like

Hi Spire,

I’ve been having the same issue. The only way I found to circumvent the problem is to create hundreds of rows at the same time, then fill in each row as I need them. This keeps the number consecutive but it makes automated creation dates meaningless, so it might not work for you.

If you want to fix the ID numbers retrospectively and don’t care that your old entries change job number, you can use an autonumber field instead of the row ID to define your job number and reset the autonumber field whenever the problem occurs (e.g. in between each batch of new rows).