How can I generate an exact sequential number with consistency when many users request at the same time?

Questions
1

For the love of Bubble.

Does anyone know how to generate an exact sequential number among concurrent requests?

I would like to create an exact sequential number whenever user requested it. It is supposed to be similar with the sequence object which common RDMBS has.

This function requires:

  • Must be identified number for each request. Let’s say two user request at the exact same time, they should get the number 1 and 2, not 1 and 1.
  • Better to be sequential number