Google Forms - Populate Options on Questions From Google Sheets

[crisbartlett]

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.

[collinfarrell]

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!

[JenniferScottEdTech]

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.

[kaributworldtz]

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

[EvanEhrenberg]

Very helpful, thank you for creating this guide.

[chrismalingshu]

Thank you so much for the guidance! it still works today!!! 😍

[jayasri-ft]

Hi. Good morning, there is no words to praising you. Very good. Thankyou.

[Nucklechose]

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

[marythomas]

Oh my gosh! It worked! Thank you very much.

[TheDervMan]

I've not seen it done that way before, very neat 👍

[domenicocarotenuto]

Thank you very much for your script, I just customized something for my form, it was very useful

[toptrendingbestviralcurate]

One of the most useful contents in YouTube 👏👏👏👏.
Btw I wanna know what commands are used for checkboxes in forms

[ewwkl]

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?

[huhummmmmmm]

Can you populate the form further down based on user selections in multiple questions above?

[goochiebrooks]

Can you have a set of questions to populate based on the response from a drop down list?

[DarrenKincaid]

This is excellent! Thank you for the excellent tutorial. Question: how do I get this to work for multiple choice questions?

[anthonysaunders]

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?

[yzvlxhx]

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

[hectoraguilar]

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!

[sahraj]

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