I have a Google Form that I would like to create where there is a drop down question in the first section. Based on the selection for that question, I would like for the options in the drop down questions in the second section to be updated.
The options are being pulled in from a Google sheets table using the Google app script.
For example, I have the following table:
| City | Country |
|---|---|
| City A | US |
| City B | US |
| City C | US |
| City D | Canada |
| City E | Canada |
First section, they select “US” for the Country.
In the next section, I want there to be 10 drop-down questions that have only the following options:
City A, City B, City C
Feel free to tell me if it isn’t possible. I know this question has been asked in the past, but I only see questions from over 5 years ago and wondering if any updates have been made since then.
- I figured out how to dynamically change the drop down options for the Country question when the list gets updated. The struggle is to make that selection influence the options in later drop down questions.
- I am able to get the drop-down options for the cities to populate if I define a specific country in the code, but I want to know if it’s possible to extract that country value from the question when I click “Next” to move to the second question. I have no idea how I would do that.
- I know that there is a way for the scripts to create a section for each Country with the questions filled in and then move to the specific section based on the Country selected, but the number of sections/questions that would be created would be too large for us to reasonably organize the responses collected.