# I want to create an automatic order number sequence column for an orders table **URL:** \ **Category:** Ask for Help\ **Created:** [July 22, 2024, 8:24am UTC](https://community.glideapps.com/t/i-want-to-create-an-automatic-order-number-sequence-column-for-an-orders-table/75056 "2024-07-22T08:24:14Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![abdelfatah\_hussien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdelfatah_hussien/32/66228_2.png) [@abdelfatah\_hussien](https://community.glideapps.com/u/abdelfatah_hussien)\ **Post date:** [July 22, 2024, 8:24am UTC](https://community.glideapps.com/t/i-want-to-create-an-automatic-order-number-sequence-column-for-an-orders-table/75056/1 "2024-07-22T08:24:14Z")
I want to create an automatic order number sequence column for an orders table with a minimum number of columns Thank you very much ---
**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:** [July 22, 2024, 8:52am UTC](https://community.glideapps.com/t/i-want-to-create-an-automatic-order-number-sequence-column-for-an-orders-table/75056/2 "2024-07-22T08:52:40Z")
> [@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…