Generate consecutive numbers for Google Forms Responses in Google Sheets

[@AalimOnlineOfficial]

You can use array formula to sequence function fir running serial number

[@practicalsheets]

Yes! You are totally right. And you could combine with Sequence to, for example, do more complicated sequences like REF-001, REF-002, etc.
Here is a video where I explore that th-cam.com/video/eWGr7ZZFN5w/w-d-xo.html
However it has the same disadvantage that the sequence has: if you reorder or add rows in the middle, the ref for each row will change
Thanks for the comment!
Regards!

[@EliPatinoAve]

thank you for this! Is there a way to insert that consecutive ref # into the confirmation email that gets sent out upon submission?

[@practicalsheets]

You would have to create the email with Google Apps Script
Kind Regards

[@krpdi3m]

Excelent video! where I work we are moving too GoogleWorkspace from Office so it has been a little difficult learning what we can do and can't. First time using Apps Script, Thanks!
Question: Is there a way to make that consecutive number to have letters? like A24X001, A24X002, etc?
gracias/Thanks, again!

[@practicalsheets]

Thanks for the words!
Try this
if(rowToWrite>2) consecutive="Ref #"+ (sheet.getRange(rowToWrite-1,colToWrite).getValue()+1)
sheet.getRange(rowToWrite,colToWrite).setValue("Ref # "+consecutive)
Kind Regards

[@brigidgifford2837]

@@practicalsheets I am trying to do this also (A-0001, A-0002, etc.) but I literally have no formula experience and don't know where to start with your info. above. Can you help in layman's terms? I would start the sequence in the second row like in your video.

[@practicalsheets]

​@@brigidgifford2837 The easiest way is to select your column in Sheets, and go to "Format" > "Number" > "Custom Number Format" and paste this pattern "A-"00000. The catch is that new responses don´t retain the format. You may want to try formatting as a table or using a macro for this
Kind Regards

[@rohank8478]

Bro can you do a video how to change Google sheets valuse (which was given using Google forms)using another Google form response

[@practicalsheets]

Yes, it is not easy, but I think we can do it
Regards!

[@rohank8478]

@@practicalsheets thanks
waiting for video

[@BradWilson-gf3ny]

Hi the code is great but if you sort the sheet and a lower number is in the last row when adding a new form response it takes the new consecutive number from the last row which adds a new sequential number but not the actual last number if you know what i mean. could you help with this as we sort the sheet into an order that suits us

[@practicalsheets]

You could use instead of the last row, the maximum of the complete list of numbers
I will take note for a future video and explain it
Kind Regards

[@YekYeu-k3r]

Hi thank you for this wonderful video, may i ask how can i make the sequence number like 3 digits?
example:
i want it to be
001
002
003....
instead of
1
2
3...
is it possible?
Hoping for your response thank you

[@practicalsheets]

The easiest way is to the advanced format we do at the end of the video
Kind Regards

[@JoeyMemmott]

ReferenceError: sheet is not defined
at addCode(Code:6:3)

[@practicalsheets]

Hello!
Remember that the code should not be executed via the editor, but only when the form is sent
Regards!