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?


This question was brought up a few times on the site having posts with very different, concrete, working approaches.

Within the above answers there is mention of the free add-ons Form Values and formRanger which both automate the procedure without the need for you to write any code.

| improve this answer | |

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.