Unique Human Readable Reference

[Darren_Murphy]

See below, but be aware that the method described does not guarantee uniqueness. There is plenty of discussion about this in the thread, but the bottom line is that operations in Glide are not atomic, so if you need to guarantee uniqueness then you need to offload the allocation of IDs to some 3rd party, and ensure that requests are handled serially.

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…