How to build Conditional Dropdowns in Google Forms
HTML-код
- Опубликовано: 13 окт 2024
- 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
practicalsheet...
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤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:
➤Patreon: practicalsheet...
➤Webpage: practicalsheet...
➤Newsletter: practicalsheet...
➤Telegram: practicalsheet...
➤Facebook: practicalsheet...
➤Twitter: practicalsheet...
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!
Thanks for the comment!
Actually where I´m stuck is not in the trigger part, but in how to replace the options with the navigation, without having to create new questions
Regards!
@@practicalsheets Was it possible to solve this problem?
@@tunahanyldzsy Haven´t continued insistig...but I will and let you all know
Kind Regards
I'm working on a python script to set up the form through the forms API strait from an API that has info about counties, states and cities.
It is possible to runs multiple subcategories (levels) and connect them with the sections? to have separated choices?
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
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.
Not easy, would have to add it at the beginning to tell the newly created questions where to go after
Let me think about it
Kind Regards
Brilliant. Thank you so much!
Thank you!
Dropdowns is not the same thing as multiple choice. How do you create the conditional logic with dropdowns not multiple choice?
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
It's a tricky script, you could paste the code and I could quickly look at it
Kind Regards
how to make drop-down that only one section or no need to click next
Not possible in Forms (as far as I know)
I would look into the possibility of doing a webApp form
Kind Regards
It is showing error "table.shift is not a function"
how to resolve this ?
normally the problem is in the definition of table
you may have forgotten to add .getValues()
Regards!
Awesome
Thank you!
could you please share the code
Sir where can I find this script file
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
You are right. There is no simple way of doing it. The truth is that for this is better to do a webapp or use AppSheet
Kind Regards
Can you please share the script as text?
Hello!
You may find all templates in the patreon page
Regards!
Are you available for hire?
😘 Thank you!
Couldn't find a way to do it. Built a google web app that connects to google sheets that has the right functionality. This video shows how to do it exactly: ruclips.net/video/dApK5_YEyzk/видео.html
Thank you so much
Agree that the best way of doing it is not in Google Forms, but in a webapp
Regards!