How to setting auto numbering that appear with a new order submit by a form button? Example, i have 3 form submitted. i need the first submitted form showing: 0001 - “form result; …” 0002 - “form result; …” 0003 - “form result; …” those 0001,0002,0003 auto generate by data backend.

But I have continuous question . Eg . the quotation number is GE-2103-1001-Rev.0. On edit, the revision 0 at the back will change to Rev.1 , Rev.2 and so on. How to make if ID is same and edit the revision number will be adding.

You should be able to do that with a template column that takes the base quotation number, and appends the increment to the end of it.

[image] ThinhDinh: Here’s a sample arrayformula. ={"Auto numbering";ARRAYFORMULA(IF(A2:A="","",TEXT(ROW(A2:A)-1,"0000")))} @ThinhDinh you’re better with these types of formulas than I am :wink: How would you adjust the above such that it starts auto-incrementing from 1, and applies to a spe…

Actually, yes and no. My use case for this is that I have a sheet with several logical groupings of rows. And for each group, I want an auto-incrementing column from 1-n So I’ve inserted the above formula pattern in the first row of each group, and it works, but… If I insert a column into any of…

Something like this I guess? [image] Arrayformula for incremental serial number dependent on another column Ask for Help Hi Manan, You can try =ARRAYFORMULA(IF(A2:A<>"",COUNTIFS(A2:A,A2:A,ROW(A2:A),"<="&ROW(A2:A)),"")) Explanation: A2:A<>"" : To only number the rows t…

Darren: I have been able to implement every solution you have ever posted, but am stumped here. Feels like circular logic of some kind. If I manually enter the first row with an Order ID of 1001, the max rollup will be 1001. The New Order ID will be 1002 for the second row. But when the third ro…

Sounds like an issue with your rollup that gets the max ID. Can you show me screenshots of: The GDE showing the relevant column names The configuration of the rollup column

[Screen Shot 2021-10-03 at 6.48.55 AM] [Screen Shot 2021-10-03 at 6.48.38 AM]

That looks okay. So when you add a new row, you should be taking the value of the signalID2 column, and using that as the signalID for your new row. Is that what you are doing?

Auto Numbering

Ask for Help

ThinhDinh March 9, 2021, 2:21pm 40

Something like this I guess?

Topic		Replies	Views
How do I create an auto-incrementing row number with Glide Tables? Community Resources tutorial	54	10492	April 18, 2025
How to increment a number counter field? Ask for Help	42	5938	January 1, 2022
Row Numbers Ask for Help	23	2987	January 31, 2022
Increment Personal ID Number for new User Ask for Help	4	1996	October 5, 2021
ID's for lines Ask for Help	21	1179	June 3, 2021

Auto Numbering

Related topics