ROW IDs ! Urgent issue with Glide

[Darren_Murphy]

@fluittsolutions

I wish that Glide row IDs would simply start at 1 and number sequentially as Microsoft Access and other industry-specific databases I have used throughout my career do. I feel that it would be easier to track growth and build relationships using row ID’s across various tables.

That’s not really the purpose of RowID’s.
But if you want an auto-incrementing row number, there are a couple of ways to set that up.

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…