Google Forms - Create Dropdown Lists and Multiple-Choice Questions from Google Sheets
Bulk add question options in dropdown lists, checkbox and multiple-choice questions in Google Forms with values from Google Spreadsheets.
Add an import button in Google Sheets that will dynamically update all the form fields in your Google Forms with the sheets data. Or create a time trigger to auto-populate your Google Form questions with the options and choices available in Google Sheets.
Tutorial: www.labnol.org/code/google-fo...
#GoogleForms #GoogleSheets #GoogleAppsScript
Пікірлер: 196
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!
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'm not a coder and know very little about script writing, but this video is very informative and helpful - thank you!
This is what I have been looking for hours and hours. Finally I came across your video. Thanks! Just subbed
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.
Thanks so much for sharing! Simple, clear, effective! Ciao from Bologna (Italy) !
This is just what I needed! Thank you so much!
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. It was really helpful for my job!
Brilliant! Thank you!!!
Thank you. I've been doing this manually for WAY too long.😮💨
Thank you very much for your code and explanation!!
Excelente, gran aporte...!!
Worked perfectly! Thank you.
Thank you Amit , Very Informative video
Thank you very much! It's so great!!
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
Thank you so much for this! Saved me days of headache.
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.
amazing tutorial. Thanks to share it. It's easy to follow the steps for me who dont understand about coding. NiNat (Indonesia)
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.
Very useful! Thanks a lot!
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 so much. it's a great tip and work for me.
This is highly technical man!! Not for common people like us
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?
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! Mr. Agarwal
You are the best !!!
This was magical. Thank you so much.
This was great...thank you!
*You are bri!!iant sir, **_as always!_*
Amazing work. Thanks!
this helped me a lot Thanks
Very informative....Thank you sir
Amit Agarwal, você é incrível! Há alguma possibilidade de não precisar criar um botão para atualização? Exemplo: toda vez que editar a planilha o Formulário já carrega a informação! Grande abraço
well done!
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?
Thank you! I learned so much from this video, it's a real gem.
Thank you so much sir, the video is very helpful...
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
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)?
very useful!! thanks Amit
thanks man! It worked really well! :D
@jz9859
3 жыл бұрын
Would you please share your code? It didn't work for me
@ljlacierda8358
3 жыл бұрын
@@jz9859 I just followed along. You might have a typographical error of some sort. I've had a few while writing my code.
@jz9859
3 жыл бұрын
@@ljlacierda8358 thanks for your response, you are correct, it worked
Thank you Amit sir, this video is really helped to to automate
This is very helpful! Thank you
Can we extract the coordinates of a user uploading a photo in a google form and send them to Google sheets.
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?
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.
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?
True programmer/coder!!! But there is also an alternate add on option are available to import a list.
@malachydonaghy
3 жыл бұрын
Wats it called? Thanks.
This is fantastic, Thank you. Is there a way to have multiple sheets/tabs feed different dropdowns on the same 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?
Sir we can do it by form ranger add on.
This is very userful, Thanks Amit
Thank you and especially for providing a link to the code.
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, great video - I do however get this error: "TypeError: header.forEach is not a function"
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.
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 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
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 you tell how to do learning style analysis using Google form sir ??
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.
Please make video on how to do dependence drop down list in google form like State > District > City
@madhavdeshpande5126
2 жыл бұрын
Could you figure out a way for this?
@computerviruses7562
Жыл бұрын
Use section based drop-down list
Great howto video Amit +1 sub
wonderful.. can we have depended dropdown list in google forms?
Pls advise sir how to create link in google form in which google location track
Can we insert image on sheet and appear on forms?
Do you have a way to code for cascading drop-down lists?
woooow you Great, thanks
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.
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
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?
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?
How to purchase the full version
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 any possibilities to arrange States by Country then Cities by States
thanks so much
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.
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 ?
is the script editor not available on Mac?
How can I do bulk upload of drop-down list in Google forms that has sections and common fields
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
Good stuff, uses javaScript which is helpful. Just wanted to mention scripts are now under Extensions -> Apps Script
Hi Amit 🙂 I can't thank you enough for this valuable information! May YHWH illuminate the wholeness of his being toward you 🙏
@labnol
11 ай бұрын
Thank you much!
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 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?
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 a way to create a trigger, so that the script run every other day?
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
3 жыл бұрын
Same Question From Me.
Hi, can you create a video that show how to auto populate specific Google Form fields, based on dropdown choice
Im getting this Error TypeError: Cannot use 'in' operator to search for 'ABC' in undefined. Can you help me in this?
so helpful
thankyou mr
Thanks Amit
how to do the same thing on zoho forms
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
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
3 жыл бұрын
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