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 Thank you! I essentially want to do exactly what your video shows; however, I'd like it to pull the header information into a form too. What would be the change in script? Thank you in advance
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.
@@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.
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 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 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.
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!
the sheet is not public
This is really well explained, thank you.
Is there anyway to automatically update the form dropdowns when the form is opened?
Yes. You can watch my other video title Auto Update Google Form. I think this will fullfill your requirement.
this is great!!
Will it work in the field on an android device?
Thanks! This is very helpful. Is there a way to have the headers dynamically populate on the form if you want to add additional questions?
I think yes
@@tech-lever Thank you! I essentially want to do exactly what your video shows; however, I'd like it to pull the header information into a form too. What would be the change in script? Thank you in advance
How did you get "data" and "settings" in the sheet? Is this manually added?
thanks. The video and link are very useful!!
Glad it was helpful!😊
thank you!
Good day I am working on a much larger rows. When I try the script it only limited to 1000 options. thanks
the scrips only limited to 1000 options how can i update the scrip so that it accept around 6000 options... thanks
How did you add the button for "Update Google Form" - I did not understand how to do that - please explain.
By inserting drawing and then attaching script to it,
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.
please share the solution with me, if you found.
Thank you @TechLever
Someone has edited your original form/spreadsheet and broken it, can you please re-upload the original form/spreadsheet
Ok. I will check that.
@@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!
@@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.
@@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.
@@JasonAndersen-g8k There is no script attached to the form. It connects by the question title.
How long does access to the sheet take to grant?
I have changed the share settings.
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.
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.
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.
sheet access denied
You should make a duplicate copy of the Spreadsheet. Hope it helps
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.