# How do I create an auto-incrementing row number with Glide Tables?

**URL:** <https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572>\
**Category:** Community Resources\
**Tags:** tutorial\
**Created:** [March 13, 2022, 4:33am UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572 "2022-03-13T04:33:25Z")\
**Posts on this page:** 1\
**Showing post:** 1

<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 13, 2022, 4:33am UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/1 "2022-03-13T04:33:25Z")

</div>

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 a new row is added.  
– The following video walks through that step by step:

https://www.loom.com/embed/58bb8a0bc8294fd9b03ca68467e924ed?sid=2e96e0b1-d1ff-42f0-bfd2-dd4926af953d

_If the above video won’t play, paste the following into a browser:_

```auto
https://www.loom.com/share/58bb8a0bc8294fd9b03ca68467e924ed?sid=2e96e0b1-d1ff-42f0-bfd2-dd4926af953d

```

- Use Case 2:  
– For the second use case, we want a _dynamic_ row number that will automatically change as new rows are added/removed.  
– The solution for this use case is very simple, and takes advantage of one of the new Array Plugin columns. Credit to @11183 for first describing the approach.  
– The following video shows how to do it:

https://www.loom.com/embed/13166419c13d4e44b961d01be5f2f801?sid=5f479f3d-92e9-4397-92cc-0df0b34f2cd4

_If the above video won’t play, paste the following into a browser:_

```auto
https://www.loom.com/share/13166419c13d4e44b961d01be5f2f801?sid=5f479f3d-92e9-4397-92cc-0df0b34f2cd4

```

…

---

_[View the full topic](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572)._
