# 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:** 6\
**Page:** 2

<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:** [March 24, 2022, 1:18am UTC](https://community.glideapps.com/t/generating-shorter-unique-id-for-every-user/27389/21 "2022-03-24T01:18:30Z")

</div>

Take a look at my first option below:

> [@How do I create an auto-incrementing row number with Glide Tables?](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572):
>
> This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…

I think that can work for your use case.

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [March 24, 2022, 1:31am UTC](https://community.glideapps.com/t/generating-shorter-unique-id-for-every-user/27389/22 "2022-03-24T01:31:54Z")

</div>

Oo your case 2, same method with me doing now but using glide . i see

---

<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:** [March 24, 2022, 1:33am UTC](https://community.glideapps.com/t/generating-shorter-unique-id-for-every-user/27389/23 "2022-03-24T01:33:23Z")

</div>

With the second case you have the same problem. If you delete a row, then all the numbers change. Also, with the second case the values will not be in the Google Sheet.

I think the first case is better for you 😉

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [March 24, 2022, 1:34am UTC](https://community.glideapps.com/t/generating-shorter-unique-id-for-every-user/27389/24 "2022-03-24T01:34:00Z")

</div>

Exactly, thank you darren . let me try it first.

---

<div class="post-metadata">

**Author:** ![Abdallah\_Shafiullah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdallah_shafiullah/32/60932_2.png) [@Abdallah\_Shafiullah](https://community.glideapps.com/u/Abdallah_Shafiullah)\
**Post date:** [July 8, 2024, 11:57am UTC](https://community.glideapps.com/t/generating-shorter-unique-id-for-every-user/27389/25 "2024-07-08T11:57:16Z")

</div>

How do I generate a unique string code automatically every time I add a new row using the form feature

I have 4 columns: Customer Name, Order Date, and TrackingID

USing the form I should be prompted to enter only the customer name and order date and upon clicking submit , In the Tracking ID cell in the corresponding row should come automatically

HOw can I achieve this?

---

<div class="post-metadata">

**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\
**Post date:** [July 8, 2024, 12:09pm UTC](https://community.glideapps.com/t/generating-shorter-unique-id-for-every-user/27389/26 "2024-07-08T12:09:43Z")

</div>

Hi @Abdallah_Shafiullah.

Welcome to Glide Community.

If you want a unique Tracking ID then you could use RowID for it. If you want a shorter unique ID then you could use a Text Slice column and set your length accordingly. 🙂

[Previous page](https://community.glideapps.com/t/generating-shorter-unique-id-for-every-user/27389.md?page=1)
