Dynamically Populate Google Form's Dropdown using Google Sheets
ฝัง
- เผยแพร่เมื่อ 5 ก.ย. 2024
- 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...
the sheet is not public
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!
Someone has edited your original form/spreadsheet and broken it, can you please re-upload the original form/spreadsheet
Ok. I will check that.
How to create an input form with response validation from data in a spreadsheet?
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
I have got another video titled Auto Update Google form. That will work for you.
@@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.
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.
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.
Kindly provide the script (link ) to populate google form
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.
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.