How to generate sequential numbers for each new record in the database?

Mega-thread regarding this issue^

Using a count operator works in most cases. However its not 100% reliable if multiple entries can be made at once. It can become a problem if you scale.

I generally don’t advise using sequential numbers, firstly because of the reliability issue, and secondly because there is no need to provide end-customers insight about how many quotes you are making. A randomly generated serial code is generally a better/easier option.

1 Like