# Auto-incrementing field in Glide through a form

**URL:** https://community.glideapps.com/t/auto-incrementing-field-in-glide-through-a-form/71218
**Category:** Ask for Help
**Created:** [February 27, 2024, 6:28pm UTC](https://community.glideapps.com/t/auto-incrementing-field-in-glide-through-a-form/71218 "2024-02-27T18:28:09Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Effkat](https://avatars.discourse-cdn.com/v4/letter/e/e68b1a/32.png) [@Effkat](https://community.glideapps.com/u/Effkat)
#### Post date: [February 27, 2024, 6:28pm UTC](https://community.glideapps.com/t/auto-incrementing-field-in-glide-through-a-form/71218/1 "2024-02-27T18:28:09Z")

</div>

I have an order table and I want a field called `order_id` to increment by one each time a form is filled out. I need this for later reviews, as the `row Id` is not sufficient. I have tried using a counter table, but I am not sure if there is a simpler way without relying on APIs or third parties. Thanks in advance.

---

<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: [February 27, 2024, 11:48pm UTC](https://community.glideapps.com/t/auto-incrementing-field-in-glide-through-a-form/71218/2 "2024-02-27T23:48:12Z")

</div>

> [@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…

Please check this thread.
