We have used the Count +1 logic used in Bubble for increment .

However on our live application in about 3000 transactions , we find 224 duplicate ids …

What senarios can cause this issue ?
How can we address the issue . ?

All we need is auto incremented ids … even if some tansactions get deleted in between … the new tansactions should have last id number + 1 …

We also tried few suggestions from … Auto increment in bubble - #3 by SeanB
but it still gives some duplications … need to know why
Please help URGENT

The existing ID + 1 isn’t changing between transactions, you’re incrementing the same ID multiple times.

There was a discussion on the forums previously. How to achieve Unique, Sequential Numbers Reliably? Where @keith goes into great detail about how to get a working solution.

For my solution, I created a 10 digital random alphanumeric string as the reference ID. Chances of the system generating the same 10 digital random alphanumeric code is quite low and due to transaction volume, I don’t see a collision happening anytime soon.

1 Like