Auto-incrementing field in Glide through a form

[Effkat]

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.

[ThinhDinh]

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

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.