Dynamically Populate Google Form's Dropdown using Google Sheets

Join our Whatsapp Channel: whatsapp.com/c...
In this video I will show you how you can dynamically update your Google Form's Dropdown, Checkboxes, Multiple choice questions using Google Sheets. You can also update you form whenever new data gets added.
#googlesheets #appsscript #googleform #form #mutiplechoicequestion #quiz #quizquestions #quizzes
☕️😊 Buy me a coffee! ☕️💖
buymeacoffee.c...
paypal.me/prit...
-------------------------------------------------------------------
🔗 Spreadsheet Link:docs.google.co...
🔗 Google Form Link: docs.google.co...
🔗 Spreadsheet Link for getting Countries and States:
docs.google.co...

[@josesoraca4625]

the sheet is not public

[@fredbowers5766]

This to me, is elegant programming. I will learn much from your lesson. It looks like a great way to create forms that work right. I will let you know how it goes. I'm just learning these forms. Thanks

[@tech-lever]

Glad it was helpful!

[@FrederickRooney]

this is great!! Will it work in the field on an android device?

[@RobertoMarzocchi]

thanks. The video and link are very useful!!

[@tech-lever]

Glad it was helpful!😊

[@shortklipmovie]

How to create an input form with response validation from data in a spreadsheet?

[@Banny0405]

How long does access to the sheet take to grant?

[@tech-lever]

I have changed the share settings.

[@downthelinett]

is it possible to update the dropdown list of 2nd dropdown based on selection from dropdown list 1?

[@tech-lever]

If your list is small then you can use Dependent Section approach. You will find that video in my channel page. Otherwise you will have to use Custom form. Again you can explore my channel page for the relevant video.

[@shikhasandeep-cd7tl]

please share the solution with me, if you found.

[@EquipmentOfficer]

Someone has edited your original form/spreadsheet and broken it, can you please re-upload the original form/spreadsheet

[@tech-lever]

Ok. I will check that.

[@infinity-skies1207]

@@tech-lever any follow up on this? there is still no way for copy-pasting, or even opening it. Could you allow it to be viewed? Thank you!

[@tech-lever]

@@infinity-skies1207 Please check the description box again. Its allowing to make a copy of the form as well as the Spreadsheet. Btw the code resides in the Spreadsheet.

[@JasonAndersen-g8k]

@@tech-lever The form is still broken. I would like to see the form so I could see how you connect the Checkbox, List, and Multiple_Choice.

[@tech-lever]

@@JasonAndersen-g8k There is no script attached to the form. It connects by the question title.

[@timesavertricks]

Kindly provide the script (link ) to populate google form

[@malik373]

Hello, I love this video however, when attempting to modify an entry automatically right after the submit button is pressed, the field that I'm trying to modify the entry doesn't show anything. How can I modify the code so that I can get the field to automatically update for me

[@tech-lever]

I have got another video titled Auto Update Google form. That will work for you.

[@malik373]

@@tech-lever Thanks so much for the quick response. I am using this vid solution because I have external emails in a file that the dropdown is pulling from. I've tried to use the functions from the other vid you recommended but no matter the trigger event...change or insert, nothing seems to be happening when I try to change the value of the field in question.

[@sumanthmudraveni1565]

I want google form dropdown like fruits, vegetables, non veg Based on selected option the 2nd drop-down has to show the details

[@tech-lever]

If you want Dependent drop-down then refer my other video tilted Dependent section form.

[@jmcgroddy]

Can this be automated to update the google form whenever the google sheet is updated

[@tech-lever]

Yes. Go to my channel page. You will see the required video.

[@alimoursi5454]

sheet access denied

[@tech-lever]

You should make a duplicate copy of the Spreadsheet. Hope it helps

[@folsterfarms]

These AI voices are getting better…

[@tech-lever]

Thanks. And it's quite useful for person like me having difficulties in correct sentence framing and articulation.

[@folsterfarms]

@@tech-lever I can relate… I often have to translate things into Vietnamese

[@digvijay9584957090]

i need some help here to advance this script in 3 ways 1. item must be searchable in menu 2. dropdown/list must be dependent to previous option ( in google sheet data columnwise dependency on the basis of A column B filtered, then on the basis of B column C filtered and so on.) 3. In drop down Add option must be if option not found.