Google Forms - Populate Options on Questions From Google Sheets
ฝัง
- เผยแพร่เมื่อ 29 ส.ค. 2024
- In this video, I demonstrate how to take options on a Google Sheet and populate those options onto Google Forms Questions using Apps Script. Video, Code, and Documentation can be found at codewithcurt.c...
Thanks! I've watched several of your videos and can't thank you enough! Especially grateful for the copies of the script you provide. For a non-tech person, this has saved me not only time but $$. Much appreciated.
This code is fabulous! I am working from a spreadsheet that creates the Form. With your code and a few modifications, I now can make updates from a Sheet to a Google Form. The text questions are static but the lists can change thanks to your code. Thank you for the tutorial and inspiration.
This is my first foray into using app script. Although I have fair amount experience with formulas, I have no background in programming. I run a remote family movie night and wanted to speed up the process of weekly voting. This was a great walk-through! Thank you
Thanks Kurt! This was fantastic! I've been working on updating my budget, and this let me set up a form I can fill out when I'm making purchases when I'm out and about so everything stays tracked and feeds back into my budget... I was not looking forward to updating the form every time I added something to the budget itself! My mind is turning over all of the use-cases for this!
This is such a clever way to manage this by matching question title to header rows! Thank you for your contribution to humanity good sir.
For anyone that gets the duplicate choice error, there are probably rows in your spreadsheet that appear blank but have spaces in them (mine was due to using an array formula to populate the list).
Hi. Good morning, there is no words to praising you. Very good. Thankyou.
I've not seen it done that way before, very neat 👍
Oh my gosh! It worked! Thank you very much.
One of the most useful contents in TH-cam 👏👏👏👏.
Btw I wanna know what commands are used for checkboxes in forms
Very helpful, thank you for creating this guide.
Thank you very much for your script, I just customized something for my form, it was very useful
Thank you so much for the guidance! it still works today!!! 😍
Good! But how can I make a searchable drop down list?
Can you populate the form further down based on user selections in multiple questions above?
Can you have a set of questions to populate based on the response from a drop down list?
I would second the comment below- could you please share the code for populating a spreadsheet to a check box or other form question set-up?
Hello sir thx for sharing the code.. plz suggest how to use drop down, multiple choice and check box using in same form.. then what will be the procedure
It worked. Thank you very much.
Do you know how i can populate a question based on previous answer? Let's say i want to know the city in which you live in, so first I ask the State and then the list of cities that will show will be the cities of that specific state.
Worked perfectly! Thankssss :)
@Code With Curt I've got forms but I want to only populate the name section how can I do that?
This is excellent! Thank you for the excellent tutorial. Question: how do I get this to work for multiple choice questions?
This fantastic, great !!! When I first tried it, it worked right away, but as I add items in my spreadsheet the form no longer updates when I refresh the page. I then returned to the video and realized I first missed the part in which you are saying it requires a different code if the question is not multiple choice. Even if I put the question type back to multiplechoice it does not update the list.
I understood it's because of the question type by looking at the execution logs, i changed back to multiplechoice and it's working again. Could you tell me the code for having this work for a drop down list? Thanks in advance.
Alexandre
Hi Court, great video. Could it be possible to fetch the options into a short-answer field as the person types?
I.E I got a field country and I start typing "C" and I get suggestions such as "Cambodia" or "Canada". Thanks for your time and help!
Is there a way that we can add another filled in the form that will also layer an "if" or "if else" options? For example, if I will choose 1 the next filled will automatically put Mine, if I choose 2 it will automatically put Yours.
How does one populate a check box(with sheets0 based on an answer of a previous question asked in a form?
In a google form I have many questions. How do I format each question to my liking?
Is there any way to add a column to select question format in google sheets? And how will I fix the code?
Please guide it, thank you so much.
Could this script be modified to create a new section for each column where the Header was the section title and each row was a question instead?
Amazing work, thanks!
Do you think this approach run in iOS smartphone/tablet?
yes, after proper setup, google forms will work on iOS, android, PC, etc.
Nice! Thank you. Is there a way i can apply this on dropdown questions?
Thank you !
Thank you for your lesson. I've got right choiceArray however it does not apply to my form after refresh it. What could be wrong?
Awesome!👋
Superb i have done..
If the contents of the dropdown list are large, can the search function appear on Google Forms?
Hi, please. I have one forms with 2 section and how to get the selected item in the firs section? My second section depends the first. Thsnk in advance.
I want to create something similar with the option that if you pick option A then question 1, 2 & 3 will pop out, if I choose option B question 4, 5 & 6 will pop, can you advise please
Hi, thanks for your videos. I am working on Google Survey Forms and want to popup values on the form based on inputs from Google Spreadsheet. Such as if I enter dealer code, his name and city name appears automatically on the form from the Google Spreadsheet which has all the details. Kindly confirm if I can do it in Google Survey Form? I would appreciate your reply. Thanks in advance.
Can I add Short answer text to google form from google sheet. What I try to make daily access code to form which has auto change daily, but has to verbally pass to the respondents. I found a way to add the access code, but need to change daily. I want that to auto update when I gave the daily list of access google in google sheet
Great!
can you insert image in google form if drive link is given serially in google sheet?
In google Form how can I validate email addresses against a list of 10 thousand email address list stored in a Google Sheet? Is there any app script or video you can refer to? Thanks in advance
Sections (Invalid conversion for item type: PAGE_BREAK) breaks this code, any way to account for having questions in different sections?
thanks but how do I make it work with repeated responses?
bro, its working first time only. Whenever after that, i update my sheet records, and then refresh the form, the code is not able to populate the latest records from the sheet. Please help bro.
Where is it that we copy the code from on 2:07 I have played it 20 times and still can figure that part out. Nothing helpful in the comments either. What I gathered is that others are wondering the exact same thing. Please help!
its in the video description.
Sir, by following this my form shows "NO DATA IN COLLUMN" plz help asap........
very good, but bit complex for someone with no coding knowledge. any easier way
I only need to populate questions from sheets, is it possible? If yes please help me with codes. Please!
This only populates the dropdowns for when you are in edit mode of the form. Can this be used to populate the drop downs with only opening the user end of the form?
As far as I know, you can't trigger by the opening user end event.
But you can change the trigger using time event, so you can update the form every one minute.
Sir how can I set pic questions please share codes . For my class students
I am getting an error in the execution log with no stated reason of why
same here, please help. Error in lines 3, 10, 11 & 19
there has to be a simple way to do this, this is nonsense