# Unique row id automatically

**URL:** <https://community.glideapps.com/t/unique-row-id-automatically/30946>\
**Category:** Ask for Help\
**Created:** [August 25, 2021, 5:51pm UTC](https://community.glideapps.com/t/unique-row-id-automatically/30946 "2021-08-25T17:51:53Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [August 25, 2021, 5:51pm UTC](https://community.glideapps.com/t/unique-row-id-automatically/30946/1 "2021-08-25T17:51:53Z")

</div>

Hi I need to get an order id which should be unique not like an unique identifier generating one.is it possible?

---

<div class="post-metadata">

**Author:** ![Amal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/amal/32/15421_2.png) [@Amal](https://community.glideapps.com/u/Amal)\
**Post date:** [August 25, 2021, 5:57pm UTC](https://community.glideapps.com/t/unique-row-id-automatically/30946/2 "2021-08-25T17:57:23Z")

</div>

You can try using Row ID, or create a starting value ex: 100001 and then use increment or a math function on it.

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [August 25, 2021, 7:14pm UTC](https://community.glideapps.com/t/unique-row-id-automatically/30946/3 "2021-08-25T19:14:26Z")

</div>

As @Amal said, you can try Row ID, or in a form, the column called `Unique Key`

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 25, 2021, 11:42pm UTC](https://community.glideapps.com/t/unique-row-id-automatically/30946/4 "2021-08-25T23:42:42Z")

</div>

May I ask why don’t you just populate the unique identifier value to the new order, assuming you’re using a form? Or you want your IDs to follow a specific format?

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [August 26, 2021, 5:34am UTC](https://community.glideapps.com/t/unique-row-id-automatically/30946/5 "2021-08-26T05:34:55Z")

</div>

I’m already populating the unique identifier but the app is a clothing store app so I need to be in some order.thats y I need this.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [August 26, 2021, 5:38am UTC](https://community.glideapps.com/t/unique-row-id-automatically/30946/6 "2021-08-26T05:38:17Z")

</div>

every time you add a new item, increment the ITEM ID by 1… simple

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 26, 2021, 9:05am UTC](https://community.glideapps.com/t/unique-row-id-automatically/30946/7 "2021-08-26T09:05:25Z")

</div>

So something like “ID-0001”, “ID-0002” etc.?

---

<div class="post-metadata">

**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\
**Post date:** [October 3, 2021, 1:20pm UTC](https://community.glideapps.com/t/unique-row-id-automatically/30946/8 "2021-10-03T13:20:56Z")

</div>

How do I increment automatically?

---

<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:** [October 3, 2021, 1:34pm UTC](https://community.glideapps.com/t/unique-row-id-automatically/30946/9 "2021-10-03T13:34:24Z")

</div>

There are a number of ways that this can be done, and which is best will depend on your specific use case. Refer to the following topic for some possible approaches:

> [@Auto Numbering](https://community.glideapps.com/t/auto-numbering/20355):
>
> How to setting auto numbering that appear with a new order submit by a form button? Example, i have 3 form submitted. i need the first submitted form showing: 0001 - “form result; …” 0002 - “form result; …” 0003 - “form result; …” those 0001,0002,0003 auto generate by data backend.
