I am designing a Google Form for managing a congress registration process. I need to have a unique ID number for each registration and I found an answear here: Can I add an autoincrement field to a Google Spreadsheet based on a Google Form?

It was certainly very useful, but there is one litle problem I cannot solve. As the form has non required fields, the answears are different in length, so the ID is placed in different columns. I think the line in the code that controls the column where the ID is placed is this one:

21. var column = eventRange.getLastColumn() + 1;

Is there a way to place the ID in a specific column, say column C?


Just replace eventRange.getLastColum() + 1 with a number. Column A is 1, B is 2 etc.

So if you want the ID to be placed in column C, change the code to

var column = 3;
  • That was very simple! THANK YOU VERY MUCH! – Weyland Federico Feb 6 '15 at 13:31
  • Glad it worked out. If you found my answer helpful, you should accept it (by clicking the green checkmark) and/or upvote it. – Vidar S. Ramdal Feb 6 '15 at 13:38
  • 1
    Done. Sorry I dont know much of the rules in this site – Weyland Federico Feb 6 '15 at 16:59
  • That's perfectly fine, we all learn as we go. Welcome to Web Applications! – Vidar S. Ramdal Feb 6 '15 at 18:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.