Generate Unique Id only numbers

How can I generate a Unique Id where all are numbers and not letters?

hI @Yesenia_Leon,

Have you taken a look at RANDBETWEEN() function?

However , please note that the repeat probability of a numeric unique number generated by RANDBETWEEN() will be significantly higher than an equal length alphanumeric UNIQUEID()


Thank you very much for your help.

1 Like

Another often overlooked problem to be aware of…these apps run in a distributed multi-user system. When generating your own unique number, you have to take extra precaution to prevent two different users from obtaining the same unique number. This is not an easy task. The more users in the app, the more likely a clash will occur.

1 Like

Thank you, let’s keep that in mind.

I use
MAX(BIObjects[Id]) + 1