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

[contato.visioncar]

I have an application page responsible for generating new quotes. How can I ensure that each budget made has an identification number starting from number 1?

This would be: budget n°1 … budget n°2 … and so on

[artemzheg]

You can apply a :count operator (to count the number of existing quotes in the DB) and +1 to it.

[contato.visioncar]

uaaaal, thank you very much my friend, I was already able to apply what you told me

[nico.dicagno]

How to achieve Unique, Sequential Numbers Reliably?

I am having a lot of difficulties creating unique, sequential numbers (for orders in my database) reliably in workflows. It’s in the format PP-100001 (100000+X where X is a simple sequential number stored in each row of the database). I have created workflows that do a search for the highest sequential number using :max and then adding one but it is unreliable, seems like the workflow sometimes skips, doesn’t fire or does the same twice. I simply cannot afford for this to occur. Is there a r…

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.