My app generates a new order number by retrieving the last sequence number and adding 1. It works fine, except when two users click at exactly the same second, which creates duplicate numbers. How can I prevent this error? [image] How can I implement like a database-level lock in Bubble?

Prevent duplicated numbers

mghatiya October 22, 2024, 4:01pm 2

There is no super good answer.

I have discussed it in this post

You would get some workarounds etc there.

2 Likes

Topic		Replies	Views
Concurrent Users & Unique Counter Increments on Database Store Database	0	456	September 13, 2020
Unique Reference Number / ID Need help	16	13661	December 3, 2018
How to achieve Unique, Sequential Numbers Reliably? Database	92	18312	February 18, 2024
Concurrent Users & Writing to an Increment "Unique Number" Field Database	5	1299	July 21, 2021
Plus 1 to Database? Need help	13	2009	October 20, 2022