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?

1 Answer 1


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! Commented Feb 6, 2015 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. Commented Feb 6, 2015 at 13:38
  • 1
    Done. Sorry I dont know much of the rules in this site Commented Feb 6, 2015 at 16:59
  • That's perfectly fine, we all learn as we go. Welcome to Web Applications! Commented Feb 6, 2015 at 18:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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