I would like to have a field in Google Forms that allows the user to select a value from a "List" of values. The options in the list being drawn from a list in the sheet itself.
This allows me to add a value to the sheet, which then adds it to the list of items to choose from.
Is there a script available for this? Or do I have to manually add 500 items to my list for the user to choose from?