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!
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.
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
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
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: ua-cam.com/video/dApK5_YEyzk/v-deo.html
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.
Brilliant. Thank you so much!
Thank you!
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
Dropdowns is not the same thing as multiple choice. How do you create the conditional logic with dropdowns not multiple choice?
Awesome
Thank you!
It is possible to runs multiple subcategories (levels) and connect them with the sections? to have separated choices?
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
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
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
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!
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
could you please share the code
Can you please share the script as text?
Hello!
You may find all templates in the patreon page
Regards!
Are you available for hire?
Sir where can I find this script file
😘 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: ua-cam.com/video/dApK5_YEyzk/v-deo.html
Thank you so much
Agree that the best way of doing it is not in Google Forms, but in a webapp
Regards!