REQUEST:
For every Glide Table, create a counter, that acts like the rowID, but it increments by 1 each time a new row is added, if a row is deleted it doesn’t change. In the builder have a special component called Table Incrementor similar to UUID, Date, etc…
If possible, a sweet bonus would be to allow a table configuration to set
- starting counter number
- a prefix
- a suffix
PROBLEM:
Having a user friend\ly counter/unique ID is a core feature for most applications (purchase orders, invoices, work orders, etc…)
The ROWID is not human readable/friendly.
The problem with creating a logic that gets the maxID in a column and then a second one that adds 1 on to the maxID to give you NextID is flawed against multiple users opening up a form, you get duplicates.
Using a webhook/API call to get number from external source becomes expensive. You use 1 edit for the call and then 1 edit to update the ROW/cell. 2 edits for each unique ID adds up when you are doing 30k-40k rows.