I'm running an event for a large number of children and need a way to let them register quickly as they come in, to the event.
We're expecting about 400 kids who have pre-enrolled and we will have a list of their names on a Google Sheets.
Some volunteers will be at the entrance with iPads to register the kids. I am hoping to have a Google Forms that can look-up a name on the Google Sheets to ensure that the kid has in fact registered (I can do this), and then enter some additional values in the same row in the Google Sheets (Team Colour, Meal Choice)
So the Google Sheets will have 4 columns: Full Name, Attendance, Team Colour, Meal Choice
To start with, the Full Name column will be prefilled in the google sheets, and the other 3 columns will be left empty. As kids register, I'm hoping to fill the other 3 columns depending on which name we look-up in the Google Forms on a dropdown.
Is this possible?
(I'm aware that I can do this via collaborating on a Google Sheets but wanted to prevent erroneous deletions by having a few people simultaneously editing the sheet directly)
Best Answer
and Sheet1 is pre-populated like:
then paste this into C1 cell on Form Responses 1 sheet:
demo spreadsheet