Dynamically Populate Google Form's Dropdown using Google Sheets
HTML-код
- Опубликовано: 12 ноя 2023
- 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.com/pritamsharma
paypal.me/pritamsharma45
-------------------------------------------------------------------
🔗 Spreadsheet Link:docs.google.com/spreadsheets/...
🔗 Google Form Link: docs.google.com/forms/d/1eJ_p...
🔗 Spreadsheet Link for getting Countries and States:
docs.google.com/spreadsheets/...
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
Glad it was helpful!
How to create an input form with response validation from data in a spreadsheet?
is it possible to update the dropdown list of 2nd dropdown based on selection from dropdown list 1?
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.
the sheet is not public
Can this be automated to update the google form whenever the google sheet is updated
Yes. Go to my channel page. You will see the required video.
Kindly provide the script (link ) to populate google form
Someone has edited your original form/spreadsheet and broken it, can you please re-upload the original form/spreadsheet
Ok. I will check that.
I want google form dropdown like fruits, vegetables, non veg
Based on selected option the 2nd drop-down has to show the details
If you want Dependent drop-down then refer my other video tilted Dependent section form.
These AI voices are getting better…
Thanks. And it's quite useful for person like me having difficulties in correct sentence framing and articulation.
@@tech-lever I can relate… I often have to translate things into Vietnamese
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.