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!
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...
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
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 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!
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...)
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.
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 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
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.
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 !
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.
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.
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.
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.
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.
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.
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
@@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.
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 🤔
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 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.
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 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
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...
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.
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.
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.
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?
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.
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!
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.
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"?
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?
![Hunxho - Ball Forever [Official Video]](http://i.ytimg.com/vi/nki9ZTF9Uls/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!
Really good teaching style, casually explaining your logic as you type makes it easy to follow.
Been my long time question's journey.. finally someone has the answer..very helpful..many thanks..
This is really my favorite channel. Much appreciated.
I watched 3 tutorial videos before this.... this one helped me a lot.... thanks!
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...
I love your easy teaching style! Very easy to follow. The step by step troubleshooting is amazingly informative. 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?
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 tut deserves a " subscribed"!
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!
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
They have an add-on called Form Ranger which can do this now.
I am really thankful to you for making this video though.
Great teaching skills means a great person! Awesome tutorials! Thank you
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.
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.
Your tutorial style is impressive it can help both beginners and seniors.
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
Brilliant. The simplest way to explain the sheets-forms relationship.
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.
Why still GAS community soo small? And VBA still VERY HUGE!!!
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!
This channel should be promoted by Google
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
I have watched a several of your videos. They are very good! Thank You!
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.
Thank you very much for the series of videos. I have learned a lot from your course materials.
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.
that was awesome! i really learned a lot just looking at how you got to the end.
Thanks for your video. I found the clue to my problem during your video.
Thank you!
Everything worked fine. In the final stage I get this error
Exception: Questions cannot have duplicate choice values.
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.
:)
Thank you so much. Im gonna use this for my students
Thanks for sharing your knowledge! best internet video on this subject
Great video! Excellent class! Thank you!
Thank you!
Everything worked fine. In the final stage I get this error
Exception: Questions "Labels undefined".
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.
What an informative and intuitive tutorials. Thank you very much Bro, it's very helpful for me to maintain my GForm,. :)
It was really helpful. You Made My Day !!!!!
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.
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 ... 😀
Tqvm sharing👍
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.
This is an outstanding tutorial!!! Thank you
This video was incredibly helpful! Thank you!
Cómo siempre profesor, admirable su trabajo, saludos cordiales desde Los Mochis Sinaloa México.
This is an awsome video, I appreciate your detail.
Can you make this script available publicly? I'm having a little trouble following along. Great video, I'm just so new to this.
thanks for excellent tutorial
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.
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
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
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.
toString doesn't work on my end - it gives me "Native Code". any workaround? Thanks!
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
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.
Wow cool did not think that possible
VERY EXCELLENT WALK THROUGH!
Thank you!
Thank you so much for this helpful tutorial. Mega explanation. Easy to understand. Spot on!
Excellent, very useful, very informative, Thank you very much!
What web app would you use for something like this?
How would you Replicate a Layout (which is Auto-Expandable BTW) in Sheets?
What web app would you normally use instead?
very good tutorial
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.
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.
I am really thankful, this is an amazing explanation and very useful information.
Thank you so much
Very instructed work. Is it possible to get an search bar if there are a lot of elements in dropdown list.
Great teamwork
He's making this more complex
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?
Thank you so much for detailed guidance.
Thank you for this very useful tutorial.
Thanks a lot for this, "mini class"! Its was very useful.. :)
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
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
Google sheets is the future
What would Your optimum way of going about this? like you talk about at the end of the video?
very helpfull, thanks
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...
YOU ARE THE BEST!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
love this video very much. thanks
this is awesome but it will be good if google add this to be featured in google forms in the future.
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.
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.
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.
Thank you. You light me up.
This was very helpful and easy to replicate - 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?
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.
Thank you for this tutorial! It woks perfectly for me!
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!
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.
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"?
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.
Thanks for this tutorial!
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.
Thanks for this! Just what I was looking for!
Thanks for this tutorial! It helped a lot!
Awesome!
great course thank you