Google Script - www.labnol.org/code/google-forms-choices-from-sheets-200630 How to bulk add options for dropdown lists and multiple-choice questions in Google Forms with data from Google spreadsheets!
hi thanks great tip. is there a way to make a conditional dropdown 2 dropdown questions the second dropdown will fullfil depending the answer in first question thanks in advance
Thanks, Mr. Amit. This video tutorial was very useful & I was able to create a Google Form using the script. But I have a question, how to create multiple Google Form Dropdown List with the same Gogle Sheet. It will be of great help If you can share the video tutorial on the same.
Thank you for this helpful guide! Exactly what i was trying to find to get around typing all the form entries manually. The automation bit with the button is especially neat, i wasnt aware that you could do that sort of thing and will def be using it in the future!
Hi Amit, is it possible to use this option to select a list of items for Question 2 base on what was elected in Question1, i.e. Question 1 is a dropdown to select a town name, Question 2 must be all the doctors in that specific town that was selected in Question 1, almost like a filter.
Thanks for the video it was useful! I was not interested in syncing this options regullarly so a solution for me was to go to my google sheet copy all of my options, and then in the form click on the question where I selected the dropdown, click on the first option and paste, it will paste all of the options.
This is a GREAT video, and it solved a big issue for me! But, it also created a problem. All of my "Go to section based on answer" information gets erased every time the form updates with the sheet data. How can the code be changed to assign the "Go to section" information each time the form updates?
I want to make a google sheet where the options would be limited based on the dropdown they select. For eg: If they select a country like India then the next dropdown should be of all the states. And also I need the form to automatically enter a country code when they select the country when i download the data later in sheets. Could you help me with that.
Thanks for the video. Actually, the code that you show in this video is not the same code that is in your web, wich one works? I tried the one that is in your web and it's an error in line 10. Thanks.
I am also facing same issues. How do you permit the execution of this function on the form. My get the error that I do not have permission to execute function on the said form
I have lots of duplicates in my google sheet that are appearing as options in the form. How do I sort and eliminate duplicates so they don't populate multiple times in the form?
Thank you for sharing this video. Please make a video on how we can validate data on google form from google sheet and if it is correct then it automatically fill the next field in the form.
Thanks for the wonderful and very useful media. I am building a form, in which I need to pull the data from spreadsheet (after part1 of the form is filled) and present that data in a part 2 of that form. To give an example, when a person submits part 1 of the form, based on the email id of the submitter, data relating to that email id from a spreadsheet needs to be pulled up and pre-filled in part 2 of the form. And then the Part 2 can be filled as usual. I would be grateful if you could make a nice video on the above subject as well. Thanks, once again
Thank you so much for sharing this! I have an issue, I made it work, but I have a list with more than 1000 options, after de row 1000, the script shows that it reach its limit, Do you know an alternative option or an enhance-limit script writing for this case?
Hi Amit, I am in process of creating a form and i would like to auto populate a answer when something is selected from drop down menu. For e.g if i select history department from drop down menu, it should auto populate the second section with head of department name and his email address. How can i achieve this? Thanks Arpit
i get this error even though i already set the permissions, can someone help Exception: No item with the given ID could be found. Possibly because you have not edited this item or you do not have permission to access it.
Hello, Thank you for a very powerful script that allows us to simply generate drop-down menus from Google Sheet columns. However how to preserve or take into account the possibility of accessing a section according to the answer (for the drop-down menus). It would seem that this turnout gets lost when updating the drop-down menus. Thank you for your reply.
Hi, am having Centers as A,b,c and when i select A in next tab i need to see persons only working in Center A. Can i have any code for this.. As i have more centers in that partners, executives and outlets
Hello. Please help! We cannot active the license for the Enterprise edition of File Upload Forms! We purchased the standard edition then realized we needed to Enterprise edition. Unfortunately when we try to active the Enterprise license a popup notifies us the license has already been activated. Any help will be greatly appreciated!
i was making a realtime update the list(Ticketing system), but when the list from sheet is blank the dropdown on google form is showing the last option dropdown. how to disable the google form dropdown if the list of the sheet is blank ?? thanks before
Hi Amit, Thanks for your kind help. I have one question that i have run the script, it ran successfully but since i have only one column. That data didn't captured in google form. Can you please help me.
hello, need your help to create a dependent dropdown in *google form* 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
Hmm some changes to the coding apps stuff, makes this not work. Also the script on the website is radically different from the video.... Kind of doesnt help.
Amit what did you do at 5:28 of video, you highlighted between the brackets and only the{} stayed behind, how did you hide the "question1": ["choice 1", "choice 2"..], "question2": ["choice a", "choice b"..], part
I am having Centers as A,b,c and when i select A in next tab i need to see persons only working in Center A. Can i have any code for this.. As i have more centers in that partners, executives and outlets
Hi, if i want to show different things depending on the first dropdown menu, who can i do that? and did you know where i can take a course of this topics (google developer)?
Hello Amit Sir, Can you please make a detailed video on how to create and deploy a Google Sheet add-ons on Google Workspace Marketplace? This will be helpful for many people.
Hi, can i use dependent drop down in google forms without going to other section? is that possible. for example if i select india in one question the next section should only show indian cities. Again i dont want to enter new section, but want to have it on the same section.
GreatVideo, i managed to run the code and populate some questions however, out of the 10 columns to be populated only 3 are reflecting to the form (I have copied the exact questions in the titles row). Could help me solve this problem please?
Is there an option for writing against the Others while in a Drop down. Was able to get that automatically for multiple choice and check boxes. But others was not coming for drop down option
Hi! Can you please help me out, I want automated data entry, suppose if I fill employee code, I want rest of the fields to be filled automatically ( like name, designation, branch etc. I would be grateful if you can share the method.
I would like to do this but for Multiple-choice grids, so that a column in my google sheet populates the row names of a multiple-choice grid question. The columns of the grid will be set manually. Eg. I may have a questions entitled 'Animal Preference', with columns 'Dog' and 'Cat'. I then need a row for every student in my class. If I have a column with the names of all my students in it, how do I extend the script above so that it populates the rows of my multiple-choice grid? Thanks
Can you do a video with google sheets and forms showing how to validate that a user has previously registered with a password and an email address before they can continue to a designated section of a google site?
Mr. Agarwal, thank you for posting this video. When creating this script in my google sheet, the values pushing over to my google form are a single numeric values but my spreadsheet contains names/text. For the first question on my form the dropdowns show all 0's, second question shows all 1's and so on. What am I doing wrong?
Google Script - www.labnol.org/code/google-forms-choices-from-sheets-200630
How to bulk add options for dropdown lists and multiple-choice questions in Google Forms with data from Google spreadsheets!
I'm not a coder and know very little about script writing, but this video is very informative and helpful - thank you!
hi thanks great tip.
is there a way to make a conditional dropdown
2 dropdown questions the second dropdown will fullfil depending the answer in first question
thanks in advance
This is what I have been looking for hours and hours. Finally I came across your video. Thanks! Just subbed
Thanks, Mr. Amit.
This video tutorial was very useful & I was able to create a Google Form using the script.
But I have a question, how to create multiple Google Form Dropdown List with the same Gogle Sheet.
It will be of great help If you can share the video tutorial on the same.
Please make video on how to do dependence drop down list in google form like State > District > City
Could you figure out a way for this?
Use section based drop-down list
Thank you for this helpful guide! Exactly what i was trying to find to get around typing all the form entries manually. The automation bit with the button is especially neat, i wasnt aware that you could do that sort of thing and will def be using it in the future!
Thanks so much for sharing! Simple, clear, effective! Ciao from Bologna (Italy) !
amazing tutorial. Thanks to share it. It's easy to follow the steps for me who dont understand about coding. NiNat (Indonesia)
Hi Amit, is it possible to use this option to select a list of items for Question 2 base on what was elected in Question1, i.e. Question 1 is a dropdown to select a town name, Question 2 must be all the doctors in that specific town that was selected in Question 1, almost like a filter.
Thanks for the video it was useful! I was not interested in syncing this options regullarly so a solution for me was to go to my google sheet copy all of my options, and then in the form click on the question where I selected the dropdown, click on the first option and paste, it will paste all of the options.
Thank you. I've been doing this manually for WAY too long.😮💨
Great video. Thank you sir. But what if you want multiple dropdowns, checkboxes or multiple choice items in your form? Can you only have one of each?
This is highly technical man!! Not for common people like us
Hi Amit - how can we have a search option in google form in drop down option, if the list of selection is more it is difficult to use dropdown menu
Same Question From Me.
This is a GREAT video, and it solved a big issue for me! But, it also created a problem. All of my "Go to section based on answer" information gets erased every time the form updates with the sheet data. How can the code be changed to assign the "Go to section" information each time the form updates?
I want to make a google sheet where the options would be limited based on the dropdown they select. For eg: If they select a country like India then the next dropdown should be of all the states. And also I need the form to automatically enter a country code when they select the country when i download the data later in sheets. Could you help me with that.
True programmer/coder!!! But there is also an alternate add on option are available to import a list.
Wats it called? Thanks.
This was magical. Thank you so much.
Thank you so much for this! Saved me days of headache.
Thank you so much for sharing this! Saved me a lot of manual labour!
Thanks for the video. Actually, the code that you show in this video is not the same code that is in your web, wich one works? I tried the one that is in your web and it's an error in line 10. Thanks.
I am also facing same issues. How do you permit the execution of this function on the form. My get the error that I do not have permission to execute function on the said form
Good stuff, uses javaScript which is helpful. Just wanted to mention scripts are now under Extensions -> Apps Script
I have lots of duplicates in my google sheet that are appearing as options in the form. How do I sort and eliminate duplicates so they don't populate multiple times in the form?
Thank you for sharing this video. Please make a video on how we can validate data on google form from google sheet and if it is correct then it automatically fill the next field in the form.
Thanks for the wonderful and very useful media.
I am building a form, in which I need to pull the data from spreadsheet (after part1 of the form is filled) and present that data in a part 2 of that form.
To give an example, when a person submits part 1 of the form, based on the email id of the submitter, data relating to that email id from a spreadsheet needs to be pulled up and pre-filled in part 2 of the form. And then the Part 2 can be filled as usual.
I would be grateful if you could make a nice video on the above subject as well.
Thanks, once again
Amit THANK YOU VERY MUCH! This is really a very big help. I hope all is well with you and the family in this difficult times.
I keep getting this error, though my code is exactly what you have. ReferenceError: choices is not defined (line 21, file"Code")
I am also getting the same error.
I'm having this error: TypeError: header.forEach is not a function (linha 8, arquivo "Código")
Are you able to sort this out please? I am getting the same
Hi, how did you corrected this error. I'm getting the same error. Kindly advise
how to do the same thing on zoho forms
Thanks for sharing
Im getting this Error TypeError: Cannot use 'in' operator to search for 'ABC' in undefined. Can you help me in this?
1 min silence to the ones who hit the dislike button....
this is as simple as it can get
Thanks Amit, the video was very useful but the script writing is novice to me.
wonderful.. can we have depended dropdown list in google forms?
Hi, great video - I do however get this error:
"TypeError: header.forEach is not a function"
How to add a search box when clicking the drop down list button that contains more than a hundred data's in google forms
Thank you so much for sharing this! I have an issue, I made it work, but I have a list with more than 1000 options, after de row 1000, the script shows that it reach its limit, Do you know an alternative option or an enhance-limit script writing for this case?
Is there a way to create a trigger, so that the script run every other day?
Thank you and especially for providing a link to the code.
Hi Amit, I am in process of creating a form and i would like to auto populate a answer when something is selected from drop down menu. For e.g if i select history department from drop down menu, it should auto populate the second section with head of department name and his email address. How can i achieve this?
Thanks
Arpit
I need to create a transport request form for school bus service.
Can i get assistance
Hi Amit 🙂 I can't thank you enough for this valuable information! May YHWH illuminate the wholeness of his being toward you 🙏
Thank you much!
This is just what I needed! Thank you so much!
Hi, How can I set no.of days ie from the previous date to the present date in the google forms? Can you help me?
Thank you very much for your code and explanation!!
i get this error even though i already set the permissions, can someone help
Exception: No item with the given ID could be found. Possibly because you have not edited this item or you do not have permission to access it.
Hello,
Thank you for a very powerful script that allows us to simply generate drop-down menus from Google Sheet columns.
However how to preserve or take into account the possibility of accessing a section according to the answer (for the drop-down menus). It would seem that this turnout gets lost when updating the drop-down menus.
Thank you for your reply.
Hi, am having Centers as A,b,c and when i select A in next tab i need to see persons only working in Center A. Can i have any code for this.. As i have more centers in that partners, executives and outlets
Hello. Please help! We cannot active the license for the Enterprise edition of File Upload Forms! We purchased the standard edition then realized we needed to Enterprise edition. Unfortunately when we try to active the Enterprise license a popup notifies us the license has already been activated. Any help will be greatly appreciated!
Thank you so much. It was really helpful for my job!
This is very helpful! Thank you
I am unable to get output, despite of completed RUN.
This is very userful, Thanks Amit
How to validate email addresses in Google forms based on a list of ten thousand email list sored in google sheet? Please help
i was making a realtime update the list(Ticketing system), but when the list from sheet is blank the dropdown on google form is showing the last option dropdown. how to disable the google form dropdown if the list of the sheet is blank ?? thanks before
Hi Amit, Thanks for your kind help.
I have one question that i have run the script, it ran successfully but since i have only one column. That data didn't captured in google form. Can you please help me.
If I used another form to update the source data, can I put a button on the source data form to update the other form?
Questions cannot have duplicate choice values. (line 38, file "Code") I have received this error how to solve
Change this:
header.forEach((title, i) => {choices[title] = data.map((d) => d[i]).filter((e) => e);});
to:
header.forEach((title, i) => {
choices[title] = [...new Set(data.map((d) => d[i]).filter((e) => e))];
});
in my script it works
hello,
need your help to create a dependent dropdown in *google form* 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
Worked perfectly! Thank you.
Can you do this for me? What would be the cost and how will contact ?
Can you make 1 sheet to 2 google form?
I feel it is too complicated. Google allows us to copy and paste data from an excel sheet to options. Which does the same function
Easy for someone thats know how to write a script
Terimakasih banyak sangat bermanfaat
How can I do bulk upload of drop-down list in Google forms that has sections and common fields
is there any possibilities to arrange States by Country then Cities by States
Hmm some changes to the coding apps stuff, makes this not work. Also the script on the website is radically different from the video.... Kind of doesnt help.
Amit what did you do at 5:28 of video, you highlighted between the brackets and only the{} stayed behind, how did you hide the "question1": ["choice 1", "choice 2"..],
"question2": ["choice a", "choice b"..],
part
Incredible Sir...how to add searchable function especially list of data is too much
Hi, can you create a video that show how to auto populate specific Google Form fields, based on dropdown choice
Thank you Amit sir, this video is really helped to to automate
I am having Centers as A,b,c and when i select A in next tab i need to see persons only working in Center A. Can i have any code for this.. As i have more centers in that partners, executives and outlets
Very useful, but the script on your website is noticeably different from the one used in this video. It's not working unfortunately.
Hi, if i want to show different things depending on the first dropdown menu, who can i do that? and did you know where i can take a course of this topics (google developer)?
This was great...thank you!
Thank you so much. it's a great tip and work for me.
Hello Amit Sir, Can you please make a detailed video on how to create and deploy a Google Sheet add-ons on Google Workspace Marketplace? This will be helpful for many people.
Hi, can i use dependent drop down in google forms without going to other section? is that possible. for example if i select india in one question the next section should only show indian cities. Again i dont want to enter new section, but want to have it on the same section.
GreatVideo, i managed to run the code and populate some questions however, out of the 10 columns to be populated only 3 are reflecting to the form (I have copied the exact questions in the titles row). Could help me solve this problem please?
can u help me in creating a form ? i have a couple of queries
Amazing work. Thanks!
Very useful! Thanks a lot!
Is there an option for writing against the Others while in a Drop down.
Was able to get that automatically for multiple choice and check boxes. But others was not coming for drop down option
From this script How to make google form can edit
Hi! Can you please help me out, I want automated data entry, suppose if I fill employee code, I want rest of the fields to be filled automatically ( like name, designation, branch etc. I would be grateful if you can share the method.
How to autofill in Google quiz the Name , Father Name on the basis of ID 0f person when all this information is available in another sheet ?
Thank you very much! It's so great!!
is the script editor not available on Mac?
I would like to do this but for Multiple-choice grids, so that a column in my google sheet populates the row names of a multiple-choice grid question.
The columns of the grid will be set manually. Eg. I may have a questions entitled 'Animal Preference', with columns 'Dog' and 'Cat'. I then need a row for every student in my class. If I have a column with the names of all my students in it, how do I extend the script above so that it populates the rows of my multiple-choice grid?
Thanks
Thank you Amit , Very Informative video
Do you have a way to code for cascading drop-down lists?
very useful!! thanks Amit
Very informative....Thank you sir
i tried using your script but it shows error
Brilliant! Thank you!!!
Can you do a video with google sheets and forms showing how to validate that a user has previously registered with a password and an email address before they can continue to a designated section of a google site?
sir , can you show us dependent drop list in google FORM, thanks
Mr. Agarwal, thank you for posting this video. When creating this script in my google sheet, the values pushing over to my google form are a single numeric values but my spreadsheet contains names/text. For the first question on my form the dropdowns show all 0's, second question shows all 1's and so on. What am I doing wrong?