Basic Question

[Dan_San]

HI,

this seems like a very basic question, but I can not find anything on searching.

How do create a unique/incrementor for records being created. I need something simpler/customisable then the UUID for the use of receipt/form numbers where I can probably select a prefix and then use an incrementor

Thanks

[Darren_Murphy]

This might help:

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…

[Dan_San]

Excellent… Thanks Darren.