# Generating shorter unique ID for every user

**URL:** <https://community.glideapps.com/t/generating-shorter-unique-id-for-every-user/27389>\
**Category:** Ask for Help\
**Created:** [May 29, 2021, 10:05am UTC](https://community.glideapps.com/t/generating-shorter-unique-id-for-every-user/27389 "2021-05-29T10:05:33Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 29, 2021, 11:33am UTC](https://community.glideapps.com/t/generating-shorter-unique-id-for-every-user/27389/10 "2021-05-29T11:33:11Z")

</div>

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](https://community.glideapps.com/t/auto-numbering/20355/12):
>
> Here is how I would do it: “Padding” is just a simple ITE… 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.

---

_[View the full topic](https://community.glideapps.com/t/generating-shorter-unique-id-for-every-user/27389)._
