I need to add the following functionality on a google form -
I need to have two dropdowns on the form-
Dropdown1 values are being populated from the google sheet using a script. Dropdown2 values must also be populated from the google sheet BUT must change based on the value selected in Dropdown1 on the form.
Since Dropdown1 has many values in the list, using the "go to section based on answer" is not an option to show Dropdown2.
How can I implement this cascading/dependent dropdown functionality dynamically on the google form (I guess using the google script and google sheet)?
Thanks in advance!