How to Automate Number Generation (No Repetition)

[Jerald101]

Hi Glide Community,

Currently, I have a data table that uses Google Sheets called Quotes. What we would like to implement is that every time we create a quote (via form), a quote number is generated corresponding to the previous number of the previous quote.

Quote Form

For example, I would create a quote named “test quote1”. Its quote number is then generated once the form is submitted. It produced the quote number QU1234. I then made another quote named “test quote2”. Its quote number is then generated as QU1235 and so on. As long as there isn’t any repeating quote numbers, that would be good.

Expected Result Every New Quote

Any help is appreciated. Thank you.

[ThinhDinh]

You can check this.

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…