Google Forms - Create Dropdown Lists and Multiple-Choice Questions from Google Sheets

[@labnol]

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!

[@KarenChungIvy]

I'm not a coder and know very little about script writing, but this video is very informative and helpful - thank you!

[@mariaponcardas9526]

This is what I have been looking for hours and hours. Finally I came across your video. Thanks! Just subbed

[@dcima59]

Thanks so much for sharing! Simple, clear, effective! Ciao from Bologna (Italy) !

[@wedoc8982]

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

[@aprilbarry3857]

Thank you. I've been doing this manually for WAY too long.😮‍💨

[@ederdelin7288]

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!

[@FazlulHaque77]

How to validate email addresses in Google forms based on a list of ten thousand email list sored in google sheet? Please help

[@gladiators-den]

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

[@nihadnassar]

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.

[@jamirulislam4801]

This is highly technical man!! Not for common people like us

[@JokerJax]

how to do the same thing on zoho forms

[@atthakur15]

Im getting this Error TypeError: Cannot use 'in' operator to search for 'ABC' in undefined. Can you help me in this?

[@subloke]

Thank you so much for this! Saved me days of headache.

[@tiffanygoodin70]

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.

[@JohnPaulDelaRosa-xm5ry]

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.

[@ConsignmentInquiries]

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!

[@sidshah16]

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

[@kulvinder8211]

Same Question From Me.

[@my_concertid]

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?

[@rajeevbagri]

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.

[@vicentekilayko4557]

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.

[@chsp5522]

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?

[@caiozacardi3116]

I'm having this error: TypeError: header.forEach is not a function (linha 8, arquivo "Código")

[@jz9859]

Are you able to sort this out please? I am getting the same

[@ArboGastcom]

Hi, how did you corrected this error. I'm getting the same error. Kindly advise

[@andyw23]

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

[@BraveHeart-ht8zf]

How to add a search box when clicking the drop down list button that contains more than a hundred data's in google forms

[@addwiseconsultancy1608]

I am unable to get output, despite of completed RUN.

[@agungramadhana2025]

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

[@mohammadsakibmahmoud6847]

Thank you so much for sharing this! Saved me a lot of manual labour!

[@KHUBAASINGOFFICIAL]

Please make video on how to do dependence drop down list in google form like State > District > City

[@madhavdeshpande5126]

Could you figure out a way for this?

[@computerviruses7562]

Use section based drop-down list

[@timesavertricks]

I need to create a transport request form for school bus service. Can i get assistance

[@somevideos99999]

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?

[@TomasGennari-w1u]

This was magical. Thank you so much.

[@hectoraguilar6111]

Is there a way to create a trigger, so that the script run every other day?

[@sushma834]

is the script editor not available on Mac?

[@sangeets_kitchen]

How can I do bulk upload of drop-down list in Google forms that has sections and common fields

[@radhakishangoswami176]

Sir i have puted the script as you given and then run it, so running perfectly but drop down not made...?

[@radhakishangoswami176]

What I have to do sir...

[@radhakishangoswami176]

Sir pls help me....

[@KevinMoreno-ws9wj]

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.

[@reshmageorge1010]

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

[@bobby17117]

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

[@datamanagementexecutive1359]

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.

[@wassupbeauty7331]

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.

[@cherylphillips1927]

I keep getting this error, though my code is exactly what you have. ReferenceError: choices is not defined (line 21, file"Code")

[@maojpatra]

I am also getting the same error.

[@ElthorneParkHighSch]

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

[@vincensiusprasetyoadi9677]

Can you make 1 sheet to 2 google form?

[@muhammadabrar9948]

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.

[@felisalebby5607]

Do you have a way to code for cascading drop-down lists?

[@hemanacademyandsecurity]

True programmer/coder!!! But there is also an alternate add on option are available to import a list.

[@malachydonaghy]

Wats it called? Thanks.

[@alexanetekhai]

Great video!!! The script works perfectly when tested. Please how can the script be modified to handle two or more Google forms with similar dropdown list and or multiple-choice questions? I mean using a click of the button to update the forms simultaneously. Thanks in advance of your kind response.

[@amitsuchday5185]

can u help me in creating a form ? i have a couple of queries

[@mdhare1515]

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

[@Econotrix]

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 ?

[@franciscocalymayorpena4278]

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)?

[@deborahmayers771]

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?

[@amiyplacement7150]

is there any possibilities to arrange States by Country then Cities by States

[@syedfaisal4924]

wonderful.. can we have depended dropdown list in google forms?

[@NeckJuta]

From this script How to make google form can edit

[@markjohnson8355]

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?

[@grantharrison8819]

I don't have a script editor in my tools menu

[@labnol]

Go to the Extensions menu and choose Apps Script.

[@timesavertricks]

i tried using your script but it shows error

[@tuksapornwaruwanaruk5123]

I can not run the Script.

[@ileneval1607]

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.

[@maojpatra]

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

[@gabrielnoira3848]

ypeError: Cannot read property 'getDataRange' of null populateGoogleForms @ Código.gs:9

[@aniljadhav6445]

Me too getting same error. Please give solution for this

[@gabrielnoira3848]

@@aniljadhav6445 there is an option for dropdown menu in google forms we don't need this

[@kanwaljeetkaur7514]

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.

[@priyabratabanerjee5294]

Can you do this for me? What would be the cost and how will contact ?

[@MissEstefa]

Worked perfectly! Thank you.

[@amitchaudhury9840]

sir , can you show us dependent drop list in google FORM, thanks

[@NitinKothari1]

This is very userful, Thanks Amit

[@maruchan1773]

Exception: Questions cannot have duplicate choice values. (line 23, file "Code") line 23: item.asListItem().setChoiceValues(choice[itemTitle]); HELPPP!!!

[@marcelkosel6142]

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

[@Josevcello]

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?

[@wernervanderwattME]

Hi Amit 🙂 I can't thank you enough for this valuable information! May YHWH illuminate the wholeness of his being toward you 🙏

[@labnol]

Thank you much!

[@dylanmackay2981]

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?

[@mohammadhasan2532]

But this code doesn't work when any duplicate choice values in dropdown list. How can i fix it. please help me

[@marcelkosel6142]

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

[@jorgep2460]

Good stuff, uses javaScript which is helpful. Just wanted to mention scripts are now under Extensions -> Apps Script

[@patelck]

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

[@flanke27]

Syntax error. (line 1, file "Code")Dismiss.. WEhen i run, iam not seeing populated ggogle form also in List

[@tejakumar5021]

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

[@marcelkosel6142]

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

[@lisasantiago8168]

This is just what I needed! Thank you so much!

[@InsideMyWall]

Can we extract the coordinates of a user uploading a photo in a google form and send them to Google sheets.

[@angadsingh587]

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?

[@DiazFelix]

Thank you very much for your code and explanation!!

[@my_concertid]

How to filter out duplicates?

[@tasyaseraphine3627]

This is very helpful! Thank you

[@UsedProfessionalStrobes]

Thank you and especially for providing a link to the code.

[@Nishakumari-bx7zi]

Pls advise sir how to create link in google form in which google location track

[@vivianantony9329]

How to add a search field to a checkbox list

[@DamarAchmad]

Can we insert image on sheet and appear on forms?

[@ElaineChai-n1j]

very useful!! thanks Amit

[@damianspencer]

This was great...thank you!

[@ashutoshsharmamagicfinmart4323]

The script given in link is not working showing error on line number 38.

[@labnol]

Can you let me know the text of the error message?

[@ashutoshsharmamagicfinmart4323]

@@labnol, I have re-written and solved. Thanks for your response. Your this video helped me a log. Tons of Thanks.

[@Thompa124]

@@ashutoshsharmamagicfinmart4323 Can you please elaborate? I am seeing a similar error on line 39....

[@thelutheranchurchoftheaton3059]

@@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

[@shilpa8514]

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?

[@dmedeveloper2911]

Thank you Amit sir, this video is really helped to to automate

[@begimaibolotbekova970]

Thank you so much. It was really helpful for my job!

[@benjibenji9653]

Hi so you do custom work for low for good rice i have a small job for you to do

[@H-do8tr]

How to update script automatically? without press on Button, or is there any way to update multiple scripts by ONE button?

[@H-do8tr]

I got it, Select on "On change" in Triggers on google script.

[@vinodshelar5268]

Very informative....Thank you sir

[@zohairdilawar116]

Thank you Amit , Very Informative video

[@MrRGvideo]

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.

[@radhakishangoswami176]

Thank you so much sir, the video is very helpful...

[@jannickfinne1919]

Hi, great video - I do however get this error: "TypeError: header.forEach is not a function"

[@NeerajKumar-hn1pn]

Sir we can do it by form ranger add on.