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 Curt, I'm an old VBA script programmer, but new to Google forms and sheets. Do you have an example of how to populate a dropdown that would display say three columns of sheet data? I need to create a voting ballot where the user could select their apartment number from a list that shows their apartment number, owner name, and number of votes they have.
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!
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.
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
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.
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.
Can you make a video to make polling questions like that. Getting questions and voting options from a Google sheet or Google form like that.. and also saves votiy data.
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
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
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
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.
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.
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!
Hi. Good morning, there is no words to praising you. Very good. Thankyou.
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).
I've not seen it done that way before, very neat 👍
hi Curt, I'm an old VBA script programmer, but new to Google forms and sheets. Do you have an example of how to populate a dropdown that would display say three columns of sheet data? I need to create a voting ballot where the user could select their apartment number from a list that shows their apartment number, owner name, and number of votes they have.
Can you have a set of questions to populate based on the response from a drop down list?
Oh my gosh! It worked! Thank you very much.
Can you populate the form further down based on user selections in multiple questions above?
One of the most useful contents in UA-cam 👏👏👏👏.
Btw I wanna know what commands are used for checkboxes in forms
Very helpful, thank you for creating this guide.
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?
Good! But how can I make a searchable drop down list?
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.
Thank you very much for your script, I just customized something for my form, it was very useful
Nice! Thank you. Is there a way i can apply this on dropdown questions?
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?
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.
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
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!
Thank you so much for the guidance! it still works today!!! 😍
This is excellent! Thank you for the excellent tutorial. Question: how do I get this to work for multiple choice questions?
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?
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.
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.
@Code With Curt I've got forms but I want to only populate the name section how can I do that?
Can you make a video to make polling questions like that. Getting questions and voting options from a Google sheet or Google form like that.. and also saves votiy data.
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.
How does one populate a check box(with sheets0 based on an answer of a previous question asked in a form?
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
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
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.
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.
Sections (Invalid conversion for item type: PAGE_BREAK) breaks this code, any way to account for having questions in different sections?
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
can you insert image in google form if drive link is given serially in google sheet?
Worked perfectly! Thankssss :)
I only need to populate questions from sheets, is it possible? If yes please help me with codes. Please!
thanks but how do I make it work with repeated responses?
It worked. Thank you very much.
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.
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, by following this my form shows "NO DATA IN COLLUMN" plz help asap........
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
Please the code for MULTIPLE CHOICE GRID 😥😥
Superb i have done..
Awesome!👋
Thank you !
very good, but bit complex for someone with no coding knowledge. any easier way
Great!
"Now that we got that out of array"
there has to be a simple way to do this, this is nonsense