How to build Conditional Dropdowns in Google Forms

preview_player
Показать описание
In this tip, we will create a Google Form that uses sections to simulate dependent dropdowns

➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions

➤You can also subscribe to the channel where you´ll find a new Sheets video every week.

Here are some of the places where you can follow and support me:

Any suggestion, question or insights, feel free to comment below
Рекомендации по теме
Комментарии
Автор

For updating your form, you could use a trigger and set it as so: Select event source->From form->Select event type->On open
Also, specially for form events triggers, it best to have your code inside the form itself rather than the spreadsheet, and connect to the spreadsheet to get the range at the beginning of the code.
Sorry for bad English, saludos desde Argentina!

TomeAM
Автор

i wonder why i failed the next conditional dropdown like it can generate first dropdown but it can't generate the next sections. and first dropdown also contains some unecessary part like enter (empty space) and dash, and even the title i put above the table

SalmaArif-uo
Автор

Dropdowns is not the same thing as multiple choice. How do you create the conditional logic with dropdowns not multiple choice?

ErickBoyd-ywyc
Автор

So basically, your form creates new sections along the way. Is that correct? Like: at first your form has just one section, but as soon as you choose one of the first options available in the first question, it creates another section accordingly to the answer previously given? I'm stuck with kindaof huge problem: I need more than 120 sections available in my form and I don't know how to do it

brunopadula
Автор

It is possible to runs multiple subcategories (levels) and connect them with the sections? to have separated choices?

FranciscoLeisewitz
Автор

then this is savings in google sheets in different different rows for different different section when we have too many options this is just complicated

yjkprxo
Автор

hello, thank you for amazing tutorial, that script is really useful, but how to add survey question after users click their city? so the list of survery question is in the one section.

cangkiraja
Автор

Can you please share the script as text?

twgnbxd
Автор

It is showing error "table.shift is not a function"

how to resolve this ?

quaidjoher