Generating shorter unique ID for every user

[Darren_Murphy]

Sorry, I was on my mobile just now, so a bit fiddly to provide a direct link.
This is the approach I’m referring to:

Auto Numbering

Here is how I would do it: [Screen Shot 2020-12-28 at 5.43.18 PM] “Padding” is just a simple ITE… [Screen Shot 2020-12-28 at 5.43.32 PM] So putting all that together, 4 columns required: Rollup to determine the current max order ID Math column to increment that by 1 ITE column to determine how many zeros required for padding Template column to join 2 & 3

This is done purely in Glide - no spreadsheet formulas required. And the same general approach can be used to generate any variation of an alphanumeric code that you like (with the numeric part auto-incrementing). For example, you could have something like:

• USER001
• USER002
• USER003
• etc…

The “USER” part would be fixed, with the numbers auto-incrementing.