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
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.
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!
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, 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.
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.
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 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?
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?
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.
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
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
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!
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)?
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
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
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
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
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
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.
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.
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?
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
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.
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.
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.
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
Sir, My querie might not be related to your above video. Besides of it I am asking. I have created clickable email signature with almost all social media icon in Google docs app. It working well on app but while copy and pasting this email signature in compose mail box on gmail(as guided on other videos), only text are moving. Pics, social media icon with it's links are not moving there. I have made it for someone else. I have convert it into word .docs file after export so that can mail to 3rd parson. But how can he able to use it while I am not able too. Plz explain how can I use my work done on Google docs app?
I am using your script and I am getting an error - ReferenceError: header is not defined. Does anyone know how to fix this? Also, I wanted to have the selection for one question based on the answer from another question (for example, if you pick say Phoenix for your city, the next question for state would only allow Arizona) Has anyone figured out how to do that?
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?
Mujhe blogger web banana hai kya main technology par bana sakta hoon jaise smartphone , TV aur interesting technology jaise(Web gadget 360) hai to main bana sakta hoon iss topic par please bataao please
Hi Amit, As followed your coding process i am getting an error "Exception: Questions cannot have duplicate choice values." I have duplicate values in list, which i cannot delete it. could you please help me up
Is there a way to have the sheet automatically run the script whenever new information is added? I would like people to be able to enter new information into the sheet from a form, and then have that information appear automatically as selectable options in a dropdown the next time someone uses the form.
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 so much for sharing! Simple, clear, effective! Ciao from Bologna (Italy) !
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.
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!
Thank you. I've been doing this manually for WAY too long.😮💨
This is highly technical man!! Not for common people like us
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, 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 so much for this! Saved me days of headache.
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.
Im getting this Error TypeError: Cannot use 'in' operator to search for 'ABC' in undefined. Can you help me in this?
This was magical. Thank you so much.
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.
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?
how to do the same thing on zoho 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?
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
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?
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.
Thank you so much for sharing this! Saved me a lot of manual labour!
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.
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
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?
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
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.
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!
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)?
I need to create a transport request form for school bus service.
Can i get assistance
wonderful.. can we have depended dropdown list in google forms?
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
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?
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.
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
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
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
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
True programmer/coder!!! But there is also an alternate add on option are available to import a list.
Wats it called? Thanks.
This is very userful, Thanks Amit
is the script editor not available on Mac?
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, great video - I do however get this error:
"TypeError: header.forEach is not a function"
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.
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?
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.
Good stuff, uses javaScript which is helpful. Just wanted to mention scripts are now under Extensions -> Apps Script
Thank you Amit sir, this video is really helped to to automate
Thanks Amit, the video was very useful but the script writing is novice to me.
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?
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
How can I do bulk upload of drop-down list in Google forms that has sections and common fields
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.
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!
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.
Do you have a way to code for cascading drop-down lists?
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 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.
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
Thank you very much for your code and explanation!!
Sir,
My querie might not be related to your above video. Besides of it I am asking.
I have created clickable email signature with almost all social media icon in Google docs app. It working well on app but while copy and pasting this email signature in compose mail box on gmail(as guided on other videos), only text are moving. Pics, social media icon with it's links are not moving there. I have made it for someone else. I have convert it into word .docs file after export so that can mail to 3rd parson. But how can he able to use it while I am not able too. Plz explain how can I use my work done on Google docs app?
Can you make 1 sheet to 2 google form?
is there any possibilities to arrange States by Country then Cities by States
Thank you so much sir, the video is very helpful...
This is very helpful! Thank you
I am unable to get output, despite of completed RUN.
Worked perfectly! Thank you.
I am using your script and I am getting an error - ReferenceError: header is not defined. Does anyone know how to fix this? Also, I wanted to have the selection for one question based on the answer from another question (for example, if you pick say Phoenix for your city, the next question for state would only allow Arizona) Has anyone figured out how to do that?
can u help me in creating a form ? i have a couple of queries
Sir i have puted the script as you given and then run it, so running perfectly but drop down not made...?
What I have to do sir...
Sir pls help me....
Thank you so much. It was really helpful for my job!
Terimakasih banyak sangat bermanfaat
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 ?
very useful!! thanks Amit
Can you do this for me? What would be the cost and how will contact ?
Thank you Amit , Very Informative video
Very informative....Thank you sir
Thank you so much. it's a great tip and work for me.
From this script How to make google form can edit
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?
This is just what I needed! Thank you so much!
Can we extract the coordinates of a user uploading a photo in a google form and send them to Google sheets.
This was great...thank you!
Mujhe blogger web banana hai kya main technology par bana sakta hoon jaise smartphone , TV aur interesting technology jaise(Web gadget 360) hai to main bana sakta hoon iss topic par please bataao please
Hi Amit, As followed your coding process i am getting an error "Exception: Questions cannot have duplicate choice values." I have duplicate values in list, which i cannot delete it. could you please help me up
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
Hi, can you create a video that show how to auto populate specific Google Form fields, based on dropdown choice
Syntax error. (line 1, file "Code")Dismiss.. WEhen i run, iam not seeing populated ggogle form also in List
Very useful, but the script on your website is noticeably different from the one used in this video. It's not working unfortunately.
Can we insert image on sheet and appear on forms?
But this code doesn't work when any duplicate choice values in dropdown list. How can i fix it. please help me
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
Thank you very much! It's so great!!
Exception: Questions cannot have duplicate choice values. (line 23, file "Code")
line 23: item.asListItem().setChoiceValues(choice[itemTitle]);
HELPPP!!!
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
Pls advise sir how to create link in google form in which
google location track
Can you tell how to do learning style analysis using Google form sir ??
Thanks for sharing
Is there a way to have the sheet automatically run the script whenever new information is added? I would like people to be able to enter new information into the sheet from a form, and then have that information appear automatically as selectable options in a dropdown the next time someone uses the form.
Yes. Add by trigger.