# Creating index UID

**URL:** https://community.glideapps.com/t/creating-index-uid/14112
**Category:** Ask for Help
**Created:** [August 17, 2020, 8:23pm UTC](https://community.glideapps.com/t/creating-index-uid/14112 "2020-08-17T20:23:09Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)
#### Post date: [August 17, 2020, 8:23pm UTC](https://community.glideapps.com/t/creating-index-uid/14112/1 "2020-08-17T20:23:09Z")

</div>

I think this is an easy question but when an entry is created and Glide creates a new record how can you add a sequential UID to each new row either directly in Glide or using Google Sheet formula?  
E.g. Record 1 could be 0001, record 2 could be 0002, etc. - automatically added

Thanks

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 17, 2020, 9:20pm UTC](https://community.glideapps.com/t/creating-index-uid/14112/2 "2020-08-17T21:20:09Z")

</div>

You can do this in the google sheet:

`=ARRAYFORMULA(TEXT(row(A2:A)-1, "0000"))`

---

<div class="post-metadata">

### Author: ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)
#### Post date: [August 18, 2020, 5:37am UTC](https://community.glideapps.com/t/creating-index-uid/14112/3 "2020-08-18T05:37:42Z")

</div>

> [@Jeff\_Hager](#):
>
> =ARRAYFORMULA(TEXT(row(A2:A)-1, “0000”))

Spot on. Thanks Jeff. I didn’t know you could use the row number like that