Learn how to update Google Forms dropdown lists from Google Sheets spreadsheet values using JavaScript & Apps Script. #googleforms #dropdown #Spreadsheet
This will have better workflow than having to update both the sheet and the form everytime a dropdown is updated. With your script, you just update Sheet's options list then run the script and you'll have consistent sheet and form data. Great job - Thanks!
Wonderful! You've answered my request!! :)) This has helped me a lot, and I'm very grateful. Hopefully it helps many others as well. And as always, excellent explanation. Thank you! Thank you!! (...but now I undestood your suggestion to use Web app instead...)
Thanks for this video, I had an issue with repeated data values, because I was using last names. but I used concatenate and merged first and last names and it worked like a charm...
Hi, Thanks for this tutorial. It was really helpful. I have a spreadsheet with thousands of unique ids call them emp IDs. Now I want to put a validation that inputs given by any google form user must be validated from that emp ids in spreadsheet. Currently they are putting it manually. Even if I create a dropdown as explained here, it will be difficult for them to search from thousands of IDs and select correct one. Your help is really appreciated.
Very Nice explanation and useful video, thank you ! I am looking transfer Dropdown selected value in Google sheet From Google Form and run Google sheet App script Automatic.
Great guide - I've adapted this with alert dialogues to push changes to forms. Thank you! The next update will be to allow the user to choose what type of data is in the form, and then update accordingly - Dropdown or Radio Button
Thank you for this clear step by step explanation. I am selftaught myself, but your explanation took away a lot of the guess work when trying to code. Thanks for explaining why you code certain things you do. THis will be very useful for all my other type of coding!
Very Informative Tutorial, Thanks for Sharing 👍 I request you to please make a tutorial on response through a trigger on form submit with the relevant results in an email. Hope to see this in your next video. Regards
I want to create dynamic dropdown in google forms. For Example, if you select Fruits in first drop down menu then in second drop down it should ask which sub category (like apple, banana etc.) but if I select Vegetable in First drop down, in second drop down it should ask sub category (like cauliflower, broccoli, etc)... Hope you understood my question.... Thanks for the video
If I'm going to do that, I'm going to build it with Sections. First Question (Fruit or Veggie), if Fruit go to section Fruit Dropdown else go to section Veggie Dropdown.
I'm still very new to App Script and learning JS right now to help improve upon what I can do to make things where I work more efficient and automated. I've learned so much from your video's. Just wanted to send a little something to say thanks.
This video was very helpful. I followed it step by step and replicated the results. I really appreciate the time you took to explain each step you made and reference where you can find similar content. I did run into one issue. One of the columns I am referencing in my sheet has an array formula within in. So in the form blanks are still shown. I assume the script recognizes the blank cells as having a value since there is a function tied to them? Is there a variable I need to add or change in the script editor so the blanks don't appear? Thanks.
Just import your list from google sheets into another column, again in google sheets itself. Like use query to import from A to C or another sheet and then since query only needs to fill values in one of the cells, you'll be fine.
Thank you for the effort. This is a good starting point for me when I'm trying to grab data from a spreadsheet to prepopulate a form. That said, this is a bit too complex for someone who just wants to grab values from a single column in a spreadsheet and put them in a single question in a form. A much simpler and more straight-forward tutorial should be more helpful.
You teach quickly and efficiently, your lessons answer all my questions and allow me to move forward quickly. And in addition it is a real pleasure to watch your videos. Even I like reading articles, learning through your videos is great and fast, to my opinion. Thanks thanks thanks !
Thanks for the video. Is there a way to have your choice for question 1 dictate which options show up in the dropdown for question 2? For example: You choose "apples" for your favourite fruit and the next question "What is your favourite type?" would be specific to apples, not grapes or bananas (even though options would exist for those choices). I imagine having a 3rd column in the spreadsheet that would allow you to associate a question 2 dropdown option with a column 1 response. Ex: Column 2 / Column 3 Royal Gala / Apples Macintosh / Apples Red seedless / Grapes Green seedless / Grapes etc. Any suggestions or reference to another video would be appreciated. I am NOT experienced with coding, but I have done some conditional formatting in sheets when creating Queries so I am not completely naive. I teach several middle school classes and want a quick way to document common student behavioural issues for later follow up. After selecting a "Course" , the "Student Name" would be limited to only students in that course. I am trying to avoid having multiple sheets and forms to manage.
Create sections in google form and go to section based on the answer from the 3 dot settings on bottom right of the 'What is your favourite fruit?' question. Create multiple sections first.
Amazing video... Just because I don't know how to do this, I was using Web app as you have mentioned... But for small list populations like my subject lists, this is a cool options now. Thanks a lot for this.
I really can’t thank you enough! this is just what we need. Btw, Is there a way around forms so I can start typing to search an option in a dropdown? We have like 50 different options sometimes :’)
Search is automatic in dropdown, just go ahead click the dropdown and type for letter or word you need. You just have to get a hang of split second timing for next search or more letter for a word to search. For example, you type X, it'll go to option that starts with X. If you type quickly xy then it will go to option say Xylophone, bypassing xray option. You type X, wait a second then type A, it will search for A, not XA. I hope that helps.
Thanks for tutorial, very helpful,, I've one question, I've simple form with 2 Questions : AreaName and BranchName. How to populate choice of question "BranchName" based on previos choice question on "AreaName"?
Great video. How would you build in dependency such that if a form user selects "bananas" the next question shows a different set of options then if she selected "berries"?
I would LOVE this capability, but from my short amount of research, it doesn't look possible. The form response is not complete until the user submits the entire form. So a response isn't available to .get in order to route to an array of options until after the full response is submitted.
Maybe you could try this: if you have “groups” (fruits, vegetables, etc.) within the form you can set a question to take you to a specific section (fruits section) and then each column within google sheets would be the answers for the question (betties, bananas, etc.). But if what you want is a mix between this video and the one from the dependent dropdown list... I find it hard, but you could try!
yupp.., i think it will awesome if we can handle "Dependent Drop Down" on google form + google sheets, since afaik in html/php its will be handle by ajax or something great job everyone
Wow, your videos are so good, I have managed to use this. Only issue was for some reason I had to change the function name from "main" to something else because the button kept giving a main function not found error. Thank you though, I always look for your stuff when solving problems.
I really love this. But I have a question I hope you could give me time to answer. How to get the Email item no, when you select in the form settings to collect email addresses. I'd like to populate also the Email addresses to control respondents with recognized email addresses.
Good afternoon. I have watched several of your videos and have learned how to automate a lot of work duties. Thank you for step by step instructions on all of these automations. I am having an issue with this one. For some reason, when I run the code, it puts all of my data from column 1 into the 1st option of the dropdown only. I have went back through this video several times, but am not finding where I missed steps to have this populate as Option 1, option 2, etc. Any ideas or suggestions would be appreciated.
Great guide. I would like to add however that Google has recently disabled less secure app access so it has become necessary to edit the json manifest file and maybe even create a project to manage authorizations.
Thank you ,very interesting! Is there a way to upload the questions directly from the sheet? Or a way to work with dropdown, write answer and option button at the same form?
as always, great video bud 👍cheers for your efforts of helping and sharing knowledge. One thing that Google Forms lacks is dependent or dynamic drop down lists, it would be great if Google would add that function to Forms. Once again bud, great video. Thanks.
yeah they've been needing to do it for a while, i think the reason they haven't is because they're reliant on 3rd party developers to create add on's to supplement those features. There are currently several add on's for forms that claim to do this "Form ranger" and "Dynamic Fields" although i haven't tried using either of these myself yet. I agree Google does it best when they simply bake these features into their apps though.
@Guillaume Duluc i thought about that, but the problem with that is: will it work will you choose answers from the form? i mean, does it update on real time? form ranger does something like that 🤔
This video was very helpful. I followed it step by step and replicated the results. I have a question about multiplechoice: Is there an automatic search solution without scrolling the list and selecting the answer in case there are thousands of possible answers? Example by writing a solution? Thanks for the answer...
Thanks sensei, nice vid! beeen googling for a day or two, found three or four methods to do that but got stuck in implementation for my project, cause I don't know a thing about JS. with your step-by-step testing, I think i'm getting close to it. Best regards
Can we have dependent Dropdowns in google forms ? Based on the selection of question 1, display specific choices for question 2. I know we can do this in google sheets. I need to know if we can do the same in google forms. (And no, I don’t want to use the goto section in google forms)
Learn Google Spreadsheets noted thanks 🙂 did not think it was possible for a dynamic lookup and subsequent dynamic field dataset generation all real time in google forms.
Time stamp: 12:41 conclui a função que determina as opções da lista suspensa (próxima função para retornar os id dos itens 19:13 conclui a segunda função que retorna os ids dos itens (a próxima vai gerar as opções e títulos retirando de uma planilha) 29:45 terceira e última função concluída. Porém, ainda haverá um tratamento de erro na sequência
Did you ever figure this out? I'm guessing you could write a script for "When spreadsheet updates, run script" I need to do this as well as my list may grow and grow and grow as I am adding from yet another form
@@Axelander09 In the Script go to "Edit" and then to "Current project triggers". Then you can make it so it runs with a time trigger or with every submit
@Corey Wicks if you want to run every time when sheets containing the data updates, you can also write your "populate form" codes inside the function onEdit within the sheets' script. function onEdit(e) { // put the main codes in this youTube video here; main(); }
@@lockshore1 Hey, thanks for the reply. I never saw these messages till now but that is what I ended up finding. The "triggers". One was "on form submit". So even though I have two forms entering data and I only need it to run after one of them, it works just fine 🤷♂️
@@quartats6758 Hey, I thought about an on edit but I also edit the spreadsheet manually sometimes and I didn't want it to lock up everytime I changed an entry. Thanks for the suggestion though!
@@ExcelGoogleSheets Amazing workaround. Obviously, a pain to do. Do you have something in mind when you say you prefer a web app solution? I've looked at a ton of form writers and can't find "type and find" search capabilities in lookups and dropdowns. 2022 and Excel can't do it, but Google Sheets can.
Hi, thanks for all your videos it helps me a lot. I'm just curious if this is done in google form side, will it update the form without clicking any button from google sheet?
Thank you very much. I prefer not to use addons and third party softwares so I like your videos, they are very helpful. Is there a way to indicate the date of last update of a video. I prefer to compare the current updates.
Thank you so much for the time and effort you put into this! This has been a HUGE help. Just one more question... could you show a way of running this exact script from the Google sheet? So basically “on load” it will run the script.
@@ExcelGoogleSheets Thank you for the reply. You mentioned in the video that you can write the script in Google Firms or in Sheets. So I assumed there would be "triggers" inside Forms. I understand why you prefer Web apps 😊 You have been a huge help in so many ways. Thank you!
Thank you very much! It looks pretty powerful!! It is pretty close to what I would like to do: I have a database of emails with names, phones and postal address. I would like the first question to be to enter the email address and then to display the name, phone and postal address of the people so that they can check this info is up to date. If it is not, then they can send me the new info Do you know how I could do that? Would you have other tuto close to this issue? I have watched a lot of them but haven't found the answer :( Thanks a lot for your help!!!
It is not possible in google forms as there is no trigger on question level, I tried it a lot and got to this conclusion after hours of research. You can try custom user forms for this ,this channel has tutorials of the same
Interesting but why doesn't google sheets allow you to lay out a form on a separate tab where you would also define the type of form object and whether it's mandatory. Then you can use simple sheet entries to make a form for anything in seconds. Am I following this correctly? Does Google have a template like that?
Thanks for sharing this amazing video! Is there any way so that I may call this Google Spreadsheet function from the Google Form onload event ? so everything the data in the google form is automatically updated.
Hey, this is amazing thank you. It's made it easy for me to automate a form. I'm having an issue where i need some of the responses to "Go to section based on answer" however when i run the script it overwrites these changes i've manually made. Could you assist with this at all?
Thank you for the effort. i have a question. how to get a value from what we choose in the form? and i want to filter data in dropdown using that data choose?
hi! i've been coming back to this video everytime i need to do this (and show it to my team as well). THANK YOU! recently, we'd like to introduce the options after a page break. do you have a resource recommendation that will help me tweak your current flow so that it doesn't result in an error?
Thank you for sharing this video. I wonder if it is also possible to do a data validation with a script, in which the input data of google form could be checked by a google spreadsheet, then it gives us a short message back to google form. Like i need to borrow a book, type the book name into the google form and by submitting the script can search the data bank of the spreadsheet and make a response if the book is borrowed or not.
What if you have several dropdowns in the same form that refer to the same list? Should you define each title question or create a function for each dropdown question?
Thanks for the Video - I have a question - In the sheet i was working, there are some duplicate values - so if i use above type of script, it was showing as - "Error - Exception: Questions cannot have duplicate choice values". can you tell me how to resolve this. Note - I don't have knowledge on script writing, i am just using the script mentioned in above video. please help me to edit and what script i should add there.
As much as this gives a solution to my problem, watching this is like looking inside the brain of someone with ADHD. Yes, it's somewhat disorganized, jumping from one thought to another, typing this and then having to delete it after. Man, that was a battle. And I have ADHD so yeah.
![[Re:all TREASURE] EP.6 in 방콕ㅣ🚩 쩡캠의 방콕 투어 빵 마이 와이 👍](http://i.ytimg.com/vi/uyFw-nItA_s/mqdefault.jpg)
This will have better workflow than having to update both the sheet and the form everytime a dropdown is updated.
With your script, you just update Sheet's options list then run the script and you'll have consistent sheet and form data.
Great job - Thanks!
Been my long time question's journey.. finally someone has the answer..very helpful..many thanks..
I watched 3 tutorial videos before this.... this one helped me a lot.... thanks!
Really good teaching style, casually explaining your logic as you type makes it easy to follow.
I love your easy teaching style! Very easy to follow. The step by step troubleshooting is amazingly informative. Thank you!
Wonderful! You've answered my request!! :))
This has helped me a lot, and I'm very grateful.
Hopefully it helps many others as well.
And as always, excellent explanation.
Thank you! Thank you!!
(...but now I undestood your suggestion to use Web app instead...)
Good do you have sample code
Thanks for this video, I had an issue with repeated data values, because I was using last names. but I used concatenate and merged first and last names and it worked like a charm...
This is really my favorite channel. Much appreciated.
They have an add-on called Form Ranger which can do this now.
I am really thankful to you for making this video though.
Hi, Thanks for this tutorial. It was really helpful. I have a spreadsheet with thousands of unique ids call them emp IDs. Now I want to put a validation that inputs given by any google form user must be validated from that emp ids in spreadsheet. Currently they are putting it manually. Even if I create a dropdown as explained here, it will be difficult for them to search from thousands of IDs and select correct one. Your help is really appreciated.
Very Nice explanation and useful video, thank you ! I am looking transfer Dropdown selected value in Google sheet From Google Form and run Google sheet App script Automatic.
Great teaching skills means a great person! Awesome tutorials! Thank you
Great guide - I've adapted this with alert dialogues to push changes to forms. Thank you! The next update will be to allow the user to choose what type of data is in the form, and then update accordingly - Dropdown or Radio Button
Any chance you could share it?
@@so8075 hey - it’s part of a live project, so I’d have to create a new project and set it up to share. Anything I can answer here via text?
Thank you for this clear step by step explanation. I am selftaught myself, but your explanation took away a lot of the guess work when trying to code. Thanks for explaining why you code certain things you do. THis will be very useful for all my other type of coding!
toString doesn't work on my end - it gives me "Native Code". any workaround? Thanks!
Very Informative Tutorial, Thanks for Sharing 👍
I request you to please make a tutorial on response through a trigger on form submit with the relevant results in an email.
Hope to see this in your next video.
Regards
I want to create dynamic dropdown in google forms. For Example, if you select Fruits in first drop down menu then in second drop down it should ask which sub category (like apple, banana etc.) but if I select Vegetable in First drop down, in second drop down it should ask sub category (like cauliflower, broccoli, etc)... Hope you understood my question.... Thanks for the video
If I'm going to do that, I'm going to build it with Sections. First Question (Fruit or Veggie), if Fruit go to section Fruit Dropdown else go to section Veggie Dropdown.
I'm still very new to App Script and learning JS right now to help improve upon what I can do to make things where I work more efficient and automated. I've learned so much from your video's. Just wanted to send a little something to say thanks.
Thank You!
This video was very helpful. I followed it step by step and replicated the results.
I really appreciate the time you took to explain each step you made and reference where you can find similar content.
I did run into one issue. One of the columns I am referencing in my sheet has an array formula within in.
So in the form blanks are still shown. I assume the script recognizes the blank cells as having a value since there is a function tied to them?
Is there a variable I need to add or change in the script editor so the blanks don't appear?
Thanks.
Just import your list from google sheets into another column, again in google sheets itself. Like use query to import from A to C or another sheet and then since query only needs to fill values in one of the cells, you'll be fine.
Your tutorial style is impressive it can help both beginners and seniors.
This tut deserves a " subscribed"!
Thank you for the effort. This is a good starting point for me when I'm trying to grab data from a spreadsheet to prepopulate a form. That said, this is a bit too complex for someone who just wants to grab values from a single column in a spreadsheet and put them in a single question in a form. A much simpler and more straight-forward tutorial should be more helpful.
You teach quickly and efficiently, your lessons answer all my questions and allow me to move forward quickly. And in addition it is a real pleasure to watch your videos. Even I like reading articles, learning through your videos is great and fast, to my opinion. Thanks thanks thanks !
Great to hear!
Thank you!
Everything worked fine. In the final stage I get this error
Exception: Questions "Labels undefined".
Brilliant. The simplest way to explain the sheets-forms relationship.
Thanks for the video. Is there a way to have your choice for question 1 dictate which options show up in the dropdown for question 2? For example: You choose "apples" for your favourite fruit and the next question "What is your favourite type?" would be specific to apples, not grapes or bananas (even though options would exist for those choices).
I imagine having a 3rd column in the spreadsheet that would allow you to associate a question 2 dropdown option with a column 1 response. Ex:
Column 2 / Column 3
Royal Gala / Apples
Macintosh / Apples
Red seedless / Grapes
Green seedless / Grapes
etc.
Any suggestions or reference to another video would be appreciated. I am NOT experienced with coding, but I have done some conditional formatting in sheets when creating Queries so I am not completely naive.
I teach several middle school classes and want a quick way to document common student behavioural issues for later follow up. After selecting a "Course" , the "Student Name" would be limited to only students in that course. I am trying to avoid having multiple sheets and forms to manage.
Create sections in google form and go to section based on the answer from the 3 dot settings on bottom right of the 'What is your favourite fruit?' question. Create multiple sections first.
Amazing video... Just because I don't know how to do this, I was using Web app as you have mentioned... But for small list populations like my subject lists, this is a cool options now. Thanks a lot for this.
Can you make this script available publicly? I'm having a little trouble following along. Great video, I'm just so new to this.
Thank you so much. Im gonna use this for my students
Thank you very much for the series of videos. I have learned a lot from your course materials.
thanks for excellent tutorial
What an informative and intuitive tutorials. Thank you very much Bro, it's very helpful for me to maintain my GForm,. :)
Thank you for your tutorials! I've learnt a lot from you these moths and I want to thank you for sharing all your knowledge in these videos.
Good video man. Thanks 🙋🏻♂️
I like to use fruit selection in my proof of concept designs as well. Usually durians have a big part to play ... 😀
Thanks for the explanation, just curious, you said you would use google form for this project, can you explain what would you use instead, please
I really can’t thank you enough! this is just what we need. Btw, Is there a way around forms so I can start typing to search an option in a dropdown? We have like 50 different options sometimes :’)
That 'search option' is what I am looking for as well
Search is automatic in dropdown, just go ahead click the dropdown and type for letter or word you need.
You just have to get a hang of split second timing for next search or more letter for a word to search.
For example, you type X, it'll go to option that starts with X.
If you type quickly xy then it will go to option say Xylophone, bypassing xray option.
You type X, wait a second then type A, it will search for A, not XA.
I hope that helps.
Why still GAS community soo small? And VBA still VERY HUGE!!!
that was awesome! i really learned a lot just looking at how you got to the end.
Thank you!
Everything worked fine. In the final stage I get this error
Exception: Questions cannot have duplicate choice values.
Thanks so much for doing this. You mentioned that this is not the most efficient way of doing this. What more efficient way were you referring to?
Thanks for tutorial, very helpful,,
I've one question, I've simple form with 2 Questions : AreaName and BranchName.
How to populate choice of question "BranchName" based on previos choice question on "AreaName"?
Great video.
How would you build in dependency such that if a form user selects "bananas" the next question shows a different set of options then if she selected "berries"?
I would LOVE this capability, but from my short amount of research, it doesn't look possible. The form response is not complete until the user submits the entire form. So a response isn't available to .get in order to route to an array of options until after the full response is submitted.
Maybe you could try this: if you have “groups” (fruits, vegetables, etc.) within the form you can set a question to take you to a specific section (fruits section) and then each column within google sheets would be the answers for the question (betties, bananas, etc.). But if what you want is a mix between this video and the one from the dependent dropdown list... I find it hard, but you could try!
yupp..,
i think it will awesome if we can handle "Dependent Drop Down" on google form + google sheets,
since afaik in html/php its will be handle by ajax or something
great job everyone
Very instructed work. Is it possible to get an search bar if there are a lot of elements in dropdown list.
Wow, your videos are so good, I have managed to use this.
Only issue was for some reason I had to change the function name from "main" to something else because the button kept giving a main function not found error. Thank you though, I always look for your stuff when solving problems.
:)
I really love this. But I have a question I hope you could give me time to answer. How to get the Email item no, when you select in the form settings to collect email addresses. I'd like to populate also the Email addresses to control respondents with recognized email addresses.
Good afternoon. I have watched several of your videos and have learned how to automate a lot of work duties. Thank you for step by step instructions on all of these automations. I am having an issue with this one. For some reason, when I run the code, it puts all of my data from column 1 into the 1st option of the dropdown only. I have went back through this video several times, but am not finding where I missed steps to have this populate as Option 1, option 2, etc. Any ideas or suggestions would be appreciated.
Thanks for sharing your knowledge! best internet video on this subject
Great guide. I would like to add however that Google has recently disabled less secure app access so it has become necessary to edit the json manifest file and maybe even create a project to manage authorizations.
I have watched a several of your videos. They are very good! Thank You!
Thanks for your video. I found the clue to my problem during your video.
Thank you ,very interesting! Is there a way to upload the questions directly from the sheet? Or a way to work with dropdown, write answer and option button at the same form?
Cómo siempre profesor, admirable su trabajo, saludos cordiales desde Los Mochis Sinaloa México.
as always, great video bud 👍cheers for your efforts of helping and sharing knowledge.
One thing that Google Forms lacks is dependent or dynamic drop down lists, it would be great if Google would add that function to Forms.
Once again bud, great video. Thanks.
yeah they've been needing to do it for a while, i think the reason they haven't is because they're reliant on 3rd party developers to create add on's to supplement those features. There are currently several add on's for forms that claim to do this "Form ranger" and "Dynamic Fields" although i haven't tried using either of these myself yet. I agree Google does it best when they simply bake these features into their apps though.
@@zr2ee1 actually i have used some of those add-ons and they don't work very well.
@Guillaume Duluc i thought about that, but the problem with that is: will it work will you choose answers from the form? i mean, does it update on real time? form ranger does something like that 🤔
Maybe just use a Web App instead if you want a form with all those bells and whistles?
@@ExcelGoogleSheets cause we're retarded and haven't fully learned how to code yet lol
Bro, You are Awesome... That's what I was looking for.... Thanks for Uploading it..... Love you Bro.. Keep Posting such videos.... I love you
Great video! Excellent class! Thank you!
This video was very helpful. I followed it step by step and replicated the results. I have a question about multiplechoice: Is there an automatic search solution without scrolling the list and selecting the answer in case there are thousands of possible answers? Example by writing a solution? Thanks for the answer...
Thanks sensei, nice vid! beeen googling for a day or two, found three or four methods to do that but got stuck in implementation for my project, cause I don't know a thing about JS. with your step-by-step testing, I think i'm getting close to it. Best regards
Can we have dependent Dropdowns in google forms ? Based on the selection of question 1, display specific choices for question 2.
I know we can do this in google sheets. I need to know if we can do the same in google forms. (And no, I don’t want to use the goto section in google forms)
Im looking forward too..i still having problem with this.
I don't think so. You can use Web Apps instead but it's not easy.
Learn Google Spreadsheets noted thanks 🙂 did not think it was possible for a dynamic lookup and subsequent dynamic field dataset generation all real time in google forms.
Time stamp:
12:41 conclui a função que determina as opções da lista suspensa (próxima função para retornar os id dos itens
19:13 conclui a segunda função que retorna os ids dos itens (a próxima vai gerar as opções e títulos retirando de uma planilha)
29:45 terceira e última função concluída. Porém, ainda haverá um tratamento de erro na sequência
Tqvm sharing👍
Thanks for this tutorial! It helped a lot!
Question: Is there a way to use a kind of form event to automatically pull the data from the spreadsheet?
Did you ever figure this out? I'm guessing you could write a script for "When spreadsheet updates, run script"
I need to do this as well as my list may grow and grow and grow as I am adding from yet another form
@@Axelander09 In the Script go to "Edit" and then to "Current project triggers". Then you can make it so it runs with a time trigger or with every submit
@Corey Wicks if you want to run every time when sheets containing the data updates, you can also write your "populate form" codes inside the function onEdit within the sheets' script.
function onEdit(e) {
// put the main codes in this youTube video here;
main();
}
@@lockshore1
Hey, thanks for the reply. I never saw these messages till now but that is what I ended up finding. The "triggers". One was "on form submit".
So even though I have two forms entering data and I only need it to run after one of them, it works just fine 🤷♂️
@@quartats6758
Hey, I thought about an on edit but I also edit the spreadsheet manually sometimes and I didn't want it to lock up everytime I changed an entry. Thanks for the suggestion though!
its 2022!! ..and, still it helps me a lot ! !🥰Thank you
👍
@@ExcelGoogleSheets Amazing workaround. Obviously, a pain to do. Do you have something in mind when you say you prefer a web app solution? I've looked at a ton of form writers and can't find "type and find" search capabilities in lookups and dropdowns. 2022 and Excel can't do it, but Google Sheets can.
Hi, thanks for all your videos it helps me a lot.
I'm just curious if this is done in google form side, will it update the form without clicking any button from google sheet?
Thank you very much. I prefer not to use addons and third party softwares so I like your videos, they are very helpful. Is there a way to indicate the date of last update of a video. I prefer to compare the current updates.
Wow cool did not think that possible
I am really thankful, this is an amazing explanation and very useful information.
Thank you so much
It was really helpful. You Made My Day !!!!!
How would you Replicate a Layout (which is Auto-Expandable BTW) in Sheets?
34:24 you can manage this with help of a Trigger with event source "From form" and event type "On open" function to run "main" the rest leave as is.
Thank you so much for this helpful tutorial. Mega explanation. Easy to understand. Spot on!
Hello, can someone help, the wsData.getRange is not working for me..
Thank you so much for the time and effort you put into this! This has been a HUGE help. Just one more question... could you show a way of running this exact script from the Google sheet? So basically “on load” it will run the script.
At this moment Forms can't run other apps on load.
@@ExcelGoogleSheets Thank you for the reply. You mentioned in the video that you can write the script in Google Firms or in Sheets. So I assumed there would be "triggers" inside Forms. I understand why you prefer Web apps 😊 You have been a huge help in so many ways. Thank you!
Hi your video is very informative, can you make a video on how to prevent entering of duplicate data in google form
Thank you for sharing this,
Can we create quick search for dropdown list in google form (in case we have too many options in dropdown list)?
Thank you
This is an outstanding tutorial!!! Thank you
Thank you very much! It looks pretty powerful!! It is pretty close to what I would like to do: I have a database of emails with names, phones and postal address. I would like the first question to be to enter the email address and then to display the name, phone and postal address of the people so that they can check this info is up to date.
If it is not, then they can send me the new info
Do you know how I could do that? Would you have other tuto close to this issue? I have watched a lot of them but haven't found the answer :( Thanks a lot for your help!!!
Have you found the solution?
It is not possible in google forms as there is no trigger on question level, I tried it a lot and got to this conclusion after hours of research. You can try custom user forms for this ,this channel has tutorials of the same
This channel should be promoted by Google
Interesting but why doesn't google sheets allow you to lay out a form on a separate tab where you would also define the type of form object and whether it's mandatory. Then you can use simple sheet entries to make a form for anything in seconds. Am I following this correctly? Does Google have a template like that?
What web app would you use for something like this?
Thanks for sharing this amazing video! Is there any way so that I may call this Google Spreadsheet function from the Google Form onload event ? so everything the data in the google form is automatically updated.
Excellent, very useful, very informative, Thank you very much!
Hey, this is amazing thank you. It's made it easy for me to automate a form. I'm having an issue where i need some of the responses to "Go to section based on answer" however when i run the script it overwrites these changes i've manually made. Could you assist with this at all?
i also meet this issue.
This video was incredibly helpful! Thank you!
Thank you for the effort.
i have a question.
how to get a value from what we choose in the form?
and i want to filter data in dropdown using that data choose?
Thank you so much for detailed guidance.
hi! i've been coming back to this video everytime i need to do this (and show it to my team as well). THANK YOU! recently, we'd like to introduce the options after a page break. do you have a resource recommendation that will help me tweak your current flow so that it doesn't result in an error?
I don't think I have a video on this.
Thank you for sharing this video. I wonder if it is also possible to do a data validation with a script, in which the input data of google form could be checked by a google spreadsheet, then it gives us a short message back to google form. Like i need to borrow a book, type the book name into the google form and by submitting the script can search the data bank of the spreadsheet and make a response if the book is borrowed or not.
What if you have several dropdowns in the same form that refer to the same list? Should you define each title question or create a function for each dropdown question?
Thanks for the Video - I have a question -
In the sheet i was working, there are some duplicate values - so if i use above type of script, it was showing as - "Error - Exception: Questions cannot have duplicate choice values". can you tell me how to resolve this.
Note - I don't have knowledge on script writing, i am just using the script mentioned in above video. please help me to edit and what script i should add there.
What web app would you normally use instead?
This is an awsome video, I appreciate your detail.
Hi there,
I want to Google Forms responses as graphic in my Wordpress site. But I can't. have you any video that you telling how to doing that?
What would Your optimum way of going about this? like you talk about at the end of the video?
As much as this gives a solution to my problem, watching this is like looking inside the brain of someone with ADHD. Yes, it's somewhat disorganized, jumping from one thought to another, typing this and then having to delete it after. Man, that was a battle. And I have ADHD so yeah.
How do you increase the limit on how many values get imported. I have a list of about 1500.
Could you please tell us the great way you are referring to in the beginning of the video ( to create the dropdown list)
Just wondering if there's any particular reason why did you put question in hardcoded even though we can store the ID itself?
Thank you for this very useful tutorial.
very good tutorial
VERY EXCELLENT WALK THROUGH!
Thank you!