Hello In my app I want to generate SN to each user, it should be 5 digit , How I can do that?

You can use the generate random string function. There are a couple of threads that cover this topic (along with alternatives) pretty well. [image] Random number generator Idea It would be great if there was a way to generate a random number instead of having the users re…

You can use the date & time in UNIX format (inside bubble)

Thank you Dan I read that thread. But what I want exactly is I build app for forwarding parcels, so as soon as the user signed up he must have a unique suit’s number and that number should not share with other user and it must storge in database of users. the problem of random number generator is …

that will be to long or doesn’t unique if I shorted it

Take a look at this post [image] Unique Reference Number / ID Need help My app requires a unique reference number, or ID, for each submission by the user. At the moment, I am using “Do a search… :count” and “Do a search for ID… :last item+1” to list the submissions in num…

Thank you Mike I read that post and it inspired me to fine an easier solution. I added a new feiled to users database and named it “unite” then I creadted a new database entry manually and gave it starter number . now when user signs up the workflow looks at last nubmer in the user list +1 [02-1…

Thats great Imanda, Please be aware that when two users sign up at the same time there is a small risk they receive the same number.

The last post on the topic that Mike referenced gives a good solution … [image] New Plugin: UniqueID Showcase [UI%20logo%20square] UniqueID plugin When having a unique id value is a must. Two flavors available: UniqueID’s Used to check for uniqueness when inserting…

How to generate SN number

Need help Database

dan1 October 31, 2018, 4:08pm 2

You can use the generate random string function. There are a couple of threads that cover this topic (along with alternatives) pretty well.

Topic		Replies	Views
How to id users automatically Database	3	317	June 17, 2022
Unique Reference Number / ID Need help	15	13788	September 25, 2018
Create User ID (numbers only) With No Duplicates During Sign Up Need help	7	3574	May 4, 2017
Plus 1 to Database? Need help	12	2078	August 12, 2022
Generate random combination of letters and numbers fith fixed length Need help	32	13799	July 27, 2021

How to generate SN number

Related topics