How to create dynamic dropdown linked in google Forms from sheets

Question

I am trying to develop a link between google sheets and google forms to enter the relevant information. However I can create dependent dropdowns in google sheets, but I can't see how you can create a dynamically linked drop-down in google forms. Example is: Dropdown 1 = LIst of groups, for example, G1, G2 Once selected the drop-down 2 is prepopulated with the the people in G1 or G2 if selected. So G1 list has Ben, David and Phil G2 list has Sarah, Claire and Karen

So if I selected G2 in Dropdown 1 I should get Sarah, Claire and Karen in the Dropdown 2 list to choose from.

However I need to have the dropdown 2 entries inserted in the same field in google sheets as if I had chosen G1 and then selected Ben, David or Phil.

Hope that is clear

To complement St3ph's answer, you can have conditional sections in your Form, which can allow you to have some more control on the content depending on previous answers. — AMolina
– AMolina, Commented Sep 5, 2019 at 7:09

St3ph · Accepted Answer · 2019-09-04 15:52:07Z

1

You can't modify on the fly a Google Forms, it is not possible by API, so changing dropdown 2 after user fill dropdown 1 is not possible.

Only things possible is to change drop down after a user submission for next submission like the add-on from ranger https://gsuite.google.com/marketplace/app/form_ranger/387838027286 can do.

Stéphane

answered Sep 4, 2019 at 15:52

St3ph

2,30819 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create dynamic dropdown linked in google Forms from sheets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related