# Auto Numbering

**URL:** <https://community.glideapps.com/t/auto-numbering/20355>\
**Category:** Ask for Help\
**Created:** [December 27, 2020, 9:34pm UTC](https://community.glideapps.com/t/auto-numbering/20355 "2020-12-27T21:34:24Z")\
**Posts on this page:** 1\
**Showing post:** 12

<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:** [December 28, 2020, 9:48am UTC](https://community.glideapps.com/t/auto-numbering/20355/12 "2020-12-28T09:48:01Z")

</div>

> [@Jeff\_Hager](#):
>
> I think to get the left padded zeros, you could take the number, divide by 1000, create a template to lock in the value and replace the decimal with nothing.

Here is how I would do it:

 ![Screen Shot 2020-12-28 at 5.43.18 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/6/76932a19737e73605db7f5366bfa29f8d9d2b4f4.png)

“Padding” is just a simple ITE…

 ![Screen Shot 2020-12-28 at 5.43.32 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/0/d0c09fe89662fbf29618b4a327de53603006f8e9.png)

So putting all that together, 4 columns required:

1. Rollup to determine the current max order ID
2. Math column to increment that by 1
3. ITE column to determine how many zeros required for padding
4. Template column to join 2 & 3

---

_[View the full topic](https://community.glideapps.com/t/auto-numbering/20355)._