Hi, I need help to figure out how to auto generate a unique user id when a user signs up to my app. I have a user id property for each user, so I’d like each new user to have the previous user id +1. [image] What I’ve done so far is to attach a ‘create’ custom action on the submit button on the…

What I’ve used that worked for me was to access the maximum ID of a table and add 1 to that. So if there’s no ID, 1 is the result. now there’s only one ID, its 1 and its the maximum, so the next will be 2. If I delete the record with the ID of 1, then 2 is still the maximum and the next will be 3. […

Oh, and I did look at this forum topic…but it’s just not worked… [image] Auto Number Generation Get Help Is there away to populate a field with a unique number i.e order number/Contract Number?

You can’t edit the primary key ID for a record. It’s not like a SQL db where you can reference the id of the record and do math with it. The best way to accomplish what you’re trying to do is to set the User ID to a function being a random number between a range. So click on magic text icon then ho…

Hmmm, didn’t work. Here’s how I set the custom action: [Screenshot 2020-11-11 at 17.48.25] I created a test user, checked in the collection…there wasn’t anything there :frowning: [Screenshot 2020-11-11 at 17.47.49] Did I do something wrong? Or miss something out…?

Well you also have 2 separate functions on the same action (Sign user up and Create User). So which one are you doing? If your form “Signs the user up” then you have to set the function immediately after it to “Update” the logged in user because you’ve already created the user in the first function.…

Ok, that makes sense. I’ve changed it the custom action to ‘Update’ and added the same random [image] It didn’t populate the User ID property unfortunately… [image]

Instead of doing it this way, I would set it automatically on the form and remove the update statement altogether. [image]

Great, thanks guys, it worked! Simple when you know how… lol :slight_smile: For those coming after who also have this problem, here’s a couple of screenshots of how it’s set up and what you should be looking for. Create an ‘Automatic Field’ and clicking the magic symbole navigate to Users -> User…

You can use the random # formula just give it a number like this Rand(1000,9999) if you don’t want/need them to be sequential.

Auto generate a UserID when a user signs up to my app

Get Help

msmurfitt November 11, 2020, 4:57pm 2

Oh, and I did look at this forum topic…but it’s just not worked…

Topic		Replies	Views
Generate a Unique ID Database	11	3626	July 12, 2022
Can I automatically fill a field in a new record with the next available number in a series? Database	3	778	February 10, 2022
Help with unique id Get Help	7	5086	October 13, 2020
Unique ID Generation Get Help	31	3328	January 15, 2022
Auto Number Generation Get Help	6	2627	December 4, 2020

Auto generate a UserID when a user signs up to my app

Related topics