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.
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.
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.
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.
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.
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
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 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 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 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 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
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
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.
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!
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
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.
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, 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)?
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?
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 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
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?
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?
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.
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
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.
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.
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
@@labnol I get the message "Invalid argument: values (line 38, file "Code")", It appears to be referencing this line - case FormApp.ItemType.MULTIPLE_CHOICE: item.asMultipleChoiceItem().setChoiceValues(values); Oddly enough, the data populated but the success message never occured
![CAMPปลิ้น | EP.82[1/2] แก๊ง 3 สาวเพื่อนซี้บุก CAMPปลิ้นครั้งนี้ห้ามเสียอาการ](http://i.ytimg.com/vi/_6WUjXHe1TM/mqdefault.jpg)
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
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
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.
I'm not a coder and know very little about script writing, but this video is very informative and helpful - thank you!
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.
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.
ypeError: Cannot read property 'getDataRange' of null
populateGoogleForms @ Código.gs:9
Me too getting same error. Please give solution for this
@@aniljadhav6445 there is an option for dropdown menu in google forms we don't need this
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
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.
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?
Hi, great video - I do however get this error:
"TypeError: header.forEach is not a function"
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.
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.
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.
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
Im getting this Error TypeError: Cannot use 'in' operator to search for 'ABC' in undefined. Can you help me in this?
How to add a search box when clicking the drop down list button that contains more than a hundred data's in google forms
Incredible Sir...how to add searchable function especially list of data is too much
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.
how to do the same thing on zoho forms
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 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?
This is what I have been looking for hours and hours. Finally I came across your video. Thanks! Just subbed
I need to create a transport request form for school bus service.
Can i get assistance
This was magical. Thank you so much.
3000 Dropdown party name is not add only 800 to 900 rows updated
From this script How to make google form can edit
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
Can you do this for me? What would be the cost and how will contact ?
I am unable to get output, despite of completed RUN.
Can you make 1 sheet to 2 google form?
can u help me in creating a form ? i have a couple of queries
looks like there's a limit to the number of choices
How to add a search field to a checkbox list
Easy for someone thats know how to write a script
i tried using your script but it shows error
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!
How to validate email addresses in Google forms based on a list of ten thousand email list sored in google sheet? Please help
Thanks for sharing
woooow you Great, thanks
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
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
Thanks Amit, the video was very useful but the script writing is novice to me.
Didnt work for me :(
I can not run the Script.
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.
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!
Thanks so much for sharing! Simple, clear, effective! Ciao from Bologna (Italy) !
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
Thank you. I've been doing this manually for WAY too long.😮💨
Good stuff, uses javaScript which is helpful. Just wanted to mention scripts are now under Extensions -> Apps Script
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.
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, 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)?
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 so much. it's a great tip and work for me.
3000 lines get error
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?
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 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
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?
Syntax error. (line 1, file "Code")Dismiss.. WEhen i run, iam not seeing populated ggogle form also in List
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
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?
sir , can you show us dependent drop list in google FORM, thanks
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....
I don't have a script editor in my tools menu
Go to the Extensions menu and choose Apps Script.
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.
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
Very useful, but the script on your website is noticeably different from the one used in this video. It's not working unfortunately.
Thank you and especially for providing a link to the code.
Nice.
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.
thankyou mr
wonderful.. can we have depended dropdown list in google forms?
Hi, can you create a video that show how to auto populate specific Google Form fields, based on dropdown choice
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 ?
Trick: if you set a trigger in your google script, you can make your list update automatically. like As soon as a change is made in your google sheet.
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.
How can I do bulk upload of drop-down list in Google forms that has sections and common fields
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.
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!! thanks Amit
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
The script given in link is not working showing error on line number 38.
Can you let me know the text of the error message?
@@labnol, I have re-written and solved. Thanks for your response. Your this video helped me a log. Tons of Thanks.
@@ashutoshsharmamagicfinmart4323 Can you please elaborate? I am seeing a similar error on line 39....
@@labnol I get the message "Invalid argument: values (line 38, file "Code")", It appears to be referencing this line - case FormApp.ItemType.MULTIPLE_CHOICE:
item.asMultipleChoiceItem().setChoiceValues(values); Oddly enough, the data populated but the success message never occured
this is like watching AI typing random stuff
Thank you so much sir, the video is very helpful...
Good job sir 👍 sir please create video vlookup formula in google form
Worked perfectly! Thank you.
so helpful
This is highly technical man!! Not for common people like us
1 min silence to the ones who hit the dislike button....
this is as simple as it can get
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?
Extend limit for documents studio from 20 to 50 ....
Please Sir...
Or lauch student plan
Thank you very much for your code and explanation!!
Thank you Amit sir, this video is really helped to to automate
is there any possibilities to arrange States by Country then Cities by States
Very informative....Thank you sir