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

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