Hi everyone,
I’ve been facing a simple, yet anoying problem for a long time.
In our ERP, we create documents and give each one a sequential number (Do a search for > Last Item > ID + 1). The problem is that our bubble app does this alright 99,9% of the time, but once in a while it creates documents with the same number.
I don’t know what to do regarding this. Does anyone face the same problem?
Bubble does not handle backend data asynchronously so if you do a search for an item and try to make the next one that item +1 and happen to do that on a backend work flow or multiple users do it at the same time, you will end up with duplicate numbers.
I typically just go with a custom ID made from calculated strings of letters and numbers to avoid this.
Is this a PO# or Order ID?
I’ve been there with the same problem. Only safe way is doing: “Do a Search for Documents:make static count” it only works for up to 50.000 things in database. But it is very annoying doing this every time we need to do a basic thing like counting
Yes exactly. This is due to Race Conditions. You’ll get inconsistent results. Most of the time correct and sometimes inaccurate.
Implement a static count combined with a duplicate number verification.
This topic was automatically closed after 14 days. New replies are no longer allowed.
