Generate consecutive numbers for Google Forms Responses un Google Sheets
In this tip, we will learn how to create an automatic sequence of numbers in Google Sheets, each time a new Form Response is recorded.
We will learn 2 ways of doing it, first with formulas, then with a simple Google Apps Script code
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheets.com/patreon
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheets.com/patreon
➤Webpage: practicalsheets.com
➤Newsletter: practicalsheets.com/newsletter
➤Telegram: practicalsheets.com/telegram
➤Facebook: practicalsheets.com/facebook
➤Twitter: practicalsheets.com/twitter
Any suggestion, question or insights, feel free to comment below
Пікірлер: 13
You can use array formula to sequence function fir running serial number
@practicalsheets
9 ай бұрын
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 kzread.info/dash/bejne/l4t71JmTiqm0Zdo.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!
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
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
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
Bro can you do a video how to change Google sheets valuse (which was given using Google forms)using another Google form response
@practicalsheets
9 ай бұрын
Yes, it is not easy, but I think we can do it Regards!
@rohank8478
9 ай бұрын
@@practicalsheets thanks waiting for video
ReferenceError: sheet is not defined at addCode(Code:6:3)
@practicalsheets
3 ай бұрын
Hello! Remember that the code should not be executed via the editor, but only when the form is sent Regards!