GAS-071 Enable Multiple Dependent Dropdowns in Google Forms
💮 about me 🔗 onescript.work/about
💮 upwork with me 🔗www.upwork.com/workwith/ashto...
🧑🏻💻 automate the boring
#MultipleDependentDropdowns #GoogleForm #AppsScript
Demo Form
forms.gle/KfydEgDpc6ZPiL4h7
Copy the script file to your drive
docs.google.com/spreadsheets/...
Source code:
github.com/ashtonfei/google-a...
Github repo: github.com/ashtonfei/google-a...
Gmail: yunjia.fei@gmail.com
Upwork: ashton_fei
Twitter: / ashton_fei
Instagram: / ashton.fei
Buy me a beer: www.paypal.me/ashtonfei/
Пікірлер: 55
Thanks for sharing your knowledge; greetings from México
Thank you Ashton
Inspiring. Thanks...
Wonderful ♥️ Make a big project. Part by part videos.
Thank you.
Nice Video 👍
precisely what i didnt need.
Thank you very much, everything works fine; just one thing, is it possible to have multiple distinct dropdowns such as the one you have in your "Dropdowns"; so multiple "Departments" and "Managers" collumns?
Permission to ask sir... For response validation, can it be taken from the data spreadsheet? For example, if I have ID data registered in column A of the spreadsheet, then only that ID can access the form, and the column A data will always be up to date. Maybe can use the help of certain scripts. Thank you in advance
Could you make restricted insert data (Submit) if it already has the same email in google form, please ?
thanks Sir
Excuse for asking, i can not find the menu 'Google Form' in my spreadsheet. How to create it? Thanks
I am not able to get the Create form Button. Even when I run the script from Script view it says unexpected error occurred. Can anyone please help?
Nice video Google sheets god
Can you expand upon how you created the combined responses sheet? I've got my form all set up, I'm just not sure how to concatenate some of the columns the way you have.
@ashtonfei
2 жыл бұрын
GAS-083 Google Form Concatenator kzread.info/dash/bejne/pGqGt8NxZsStm5c.html
I want to automatically update the drop-down list and other tabs .I won't create a new form every next time. Please suggest how it works
hello, need your help to create a dependent dropdown in *google form* in 1 single section,using data or dependent dropdown menus from a google sheet. please guide me or if possible make a video on it. P.S : Don't want to use logic based section shuffle or *form ranger* or *cascade formatting*. thanks in advance
thanks a lot, it is an amazing file. just one question. How do I collect automatically the emails without asking for it in the form? I have edited the form to collect the email by default, but it is not showing any info the cell. should it be in included in the script?
@ashtonfei
2 жыл бұрын
Form is public, so you can not collect the email automatically unless the user enter their email. And they can fill a fake one which you cannot control. I think only private form (sign in required) can have the possibility.
Thanks for the assist on this form. Can you help me the script create dropdown list and set go to section by ID. Thank you very much
Thanks for the assist on this form. I'm having an issue where my dropdown list has over 1000 values and the apps script times out after 6 minutes while trying to create the form. Is there a way to modify the code so that it creates the form under 6 minutes or does it in sections?
@ashtonfei
3 жыл бұрын
Then you need to change the strategy. You need to slice the form into small sections that’s can be created within 6min. Every time the script will append the new section to the end of the form, not create a new form.
@wariow
3 жыл бұрын
@@ashtonfei I have little experience of coding, would it be possible to assist or put some coded trigger to append the dropdown list to an existing form?
I do not get the Create form Button. Can anyone please help?
Lage
how to use now? there is no trigger
Is there a way to create multiple depends drop-down without going to next page ( without section method)
@ashtonfei
2 жыл бұрын
I don’t see that solution with google form.
I managed to implement the script using the data in the Sample Spreadsheet - but when I came to try my data, the system would not work! Using teh sample data, if there is only one 'HR- Manager' the Apps Script produces 'Error - Questions cannot have duplicate choice values.' Does anyone know of a solution?
@ashtonfei
Жыл бұрын
Hi Allan, You may need to check if you have duplicated values for your dropdown according to the error message. (In the pages, make sure no duplicated values in the options, I didn't handle it in my original script.)
@Thompa124
Жыл бұрын
@@ashtonfei Hi Ashton, Thanks for responding. There are no duplicates in the lists. The problem error message appears, apparently, because there is only one main list item at the top of first list. Thanks for your help!
@Thompa124
Жыл бұрын
@@ashtonfei Hi Ashton, No duplicates in the data - error is caused by having a single, first main item.
Confused
Always stay tune for your update sir
@suryosuryobintang5063
3 жыл бұрын
Sorry for bother you, is possible to make relationship from spreadsheet to form update real time, when we delete some data from spreadsheet relationship , data form is deleted to?
@suryosuryobintang5063
3 жыл бұрын
Thanks a lot from everythings
what i do if i wants three dependent dropdowns plzz help
@svetozarkuzman2924
Жыл бұрын
did you find solution my friend? I too would like to have three or four distinct dependent dropdowns
How to create combined response sheet
@ashtonfei
3 жыл бұрын
Instead of separating them into different tabs by department, you can put them in one single sheet.
Thank you for ur amazing code. I try to modify ur code for my google form. I try to make an Booking Supplier Shipment for my stores, so I try to make multilevel dependent with 4 level (Stores, Inbound Capacity in every Stores, Delivery Date and Delivery Hour).. I was success with 2nd level.. But failed in 3rd and 4th level.. Maybe this is can be your idea to make 2nd Part? Can you give me some advices?
@ashtonfei
2 жыл бұрын
Thanks for your comment. The dependent dropdown is the week point of Google Form, I suggest you create a custom form with a web app, it will b much easier. Check my latest project about this topic. kzread.info/dash/bejne/fGGNp9mCdNrSj5s.html kzread.info/dash/bejne/oHmiutCupbmzgco.html
Do you know how to create this nested object below from Google Sheets? var subjectObject = { "Front-end": { "HTML" : ["Links", "Images", "Tables", "Lists"], "CSS" : ["Borders", "Margins", "Backgrounds", "Float"], "JavaScript": ["Variables", "Operators", "Functions", "Conditions"] }, "Back-end": { "PHP": ["Variables", "Strings", "Arrays"], "SQL": ["SELECT", "UPDATE", "DELETE"] } }
@ashtonfei
3 жыл бұрын
It depends on the raw data structure in the spreadsheet, do you have a sample data?
@ConsulthinkProgrammer
3 жыл бұрын
@@ashtonfei Looks likes my comment with spreadsheet link just deleted by KZread. May I sharing that spreadsheet to your email?
@ashtonfei
3 жыл бұрын
yes please
@ConsulthinkProgrammer
3 жыл бұрын
@@ashtonfei I just give you an access to the spreadsheet and the script editor :)
@crcchotila-3419
3 жыл бұрын
@@ConsulthinkProgrammer Sir, can you give me that spreadsheet to my email?
Do 1.5X
This could've been a great example but he didn't discuss the script behind. Thumbs down for me.
Video hat gar kein System. Vllt erklärt er es richtig aber ich habe sowas von kein Bock dem Typen zuzuhören, weil er dermaßen langweilig ist...
Your video is terrible. You start your video from the middle. Next time start from where your viewers point of view not yours.