To throw more light on what I'm asking for: I want to create a google form that when the user enters some inputs in the first section those input will appear in the next section of the form.
I am a coder and have worked with Javascript before. But the fact that she has explained these concepts in such lucid language so that non coders can grasp it is amazing. Great Job. 🎉
ive been in the coding game for about 2 years now, and by far the best tutorial for beginners indeed. usually when people say for "beginners" they still treat it like its advanced, or they already know coding/JavaScript terms. studying for an interview tomorrow and this helped a lot, so thank you. and also thank youfr breaking it down BY TERM for the true (no pun) beginners.
Happy to hear you find the video helpful. By the way, I've started making pure JavaScript videos for beginners. You might find them helpful. All the best for your job interview!
Hello @Saperis, This one video cleared up a bunch of important concepts including adding script execution to the menu etc. Minute for minute the best video on the subject that I've seen. Very neatly done!
Thank you so much! For a complete beginner in programming, this tutorial taught me so much more than I'd expected. Really appreciate your content and your articulate style of teaching. 30 out of 10!
I am a python coder ... i have to say this was a delightful intro to gscript and well worth my time ... i LOVE your style ... so clear and concise ... no fat.
I just want to say what a well explained video. For someone who struggles understanding things easily, you do a fabulous job breaking things down. I am so excited to learn more from your videos. So glad I found this video!
Happy to hear that! We have a playlist full of beginner friendly JavaScript videos you might want to check out: czcams.com/video/x3xZXJmb05U/video.html
Finally, a true BEGINNER’s guide. I have zero knowledge in scripts and the other videos I watched were too overwhelming. This video really helped me a lot. Thank youuu
Glad it helped! There's a playlist with beginner friendly coding videos. Feel free to watch any video that might interest you: czcams.com/play/PLNwCcck1-mNgASuUVvHeK282pvHzgWP-6.html
I am not a coder but loved the way she's explained it. precise and at a pace that a beginner can grasp the concepts and do it simultaneously.. Amazing job!
Very nice teaching here! Not only did the tutorial work and showed me how to do what I wanted, but the way you explained it is clear and understandable. This was my first foray into using the Apps Scripts, but it is not my last! Thank you.
Happy you liked it! We have an entire playlist with Google Apps Script videos. You might want to give it a look: czcams.com/play/PLNwCcck1-mNhiOoAGICW3fYKTP5gHZyjR.html
Happy you liked it! 😀 I have an entire Google Apps Script playlist with lots of video tutorials you might find interesting: czcams.com/play/PLNwCcck1-mNhiOoAGICW3fYKTP5gHZyjR.html
Another dev here. I know lots about Javascript but your video introduced me to the Google Apps sandbox and API and how to expose scripts to my Sheets. Thanks so much!
Thanks Kathie. This is the first time I actually managed to create and run a Google Apps Script successfully. Your presentation is well-structured and easy to follow.
I've watched a lot of tutorials on google apps for beginners and all of them are so hard to understand. THIS IS THE ONLY channel that made sense to me. thanks! :D
Wow! I am impressed. I am a software engineer as well. I have to admit that no one really talks about these basics and good practices any more including the documentation. The whole industry has become adhoc development campus. I normally do not subscribe to the one time videos that I watch, but I did end up subscribing.
Happy to hear you like this video. You know the saying where you give someone a fish and they will eat for a day. But if you TEACH them how to fish they will eat every day. I believe in teaching the HOW and WHY so that aspiring developers can apply concepts instead of only copy & pasting code. And yes, learning to read and use the documentation of any technology is super important in my opinion.
Thanks for the feedback Corey. I put out a new Google Apps Script tutorial every month so stay tuned. 😀 And you might want to check out my online course: courses.saperis.io
Wow, I feel honored I made it on that playlist! I've since changed my style of explaining a bit. If you want to, you could let me know if the new style works well too. This is my newest Apps Script video: czcams.com/video/w9AXRfrhTCQ/video.html
You just made my day Tiph! Thank you for the feedback. 😀 If you have a chance do check out my Google Apps Script online course: courses.saperis.io Have a good one!
Thanks very much for your great tutorial. I've been experimenting with coding because many of my students work in Korea as software engineers. I wanted to understand what they were doing and your tutorial was my first success.
Happy to hear that. By the way, there's an entire playlist with beginner-friendly videos that might interest you: czcams.com/play/PLNwCcck1-mNgASuUVvHeK282pvHzgWP-6.html
Awesome video!! You explained so well. I will have to rewatch it again to understand better. I am completely new to the App Script...Hopefully, I can get used to of using this.
I like when you mention what all the basic stuff means as you go along. I'm new to this craic and it's annoying having to pause other people's videos, Google stuff, then come back lol.
Well, many tutorial creators assume that their viewers already have coding experience. I on the other hand create videos for viewers with little or no coding know-how. That's why my videos are good for beginners but experienced coders find them to be too basic.
Thanx for that quiet , slow explanation and wonderful algorithm of teaching what is coding for beginners. I subscribed and am waiting for your new videos.
Thanks for your motivating words! You might also want to check out my Google Apps Script online course: courses.saperis.io The first lessons are for free so you can try out the course with no strings attached.
Hi Saperis, your videos are awesome! The way you explain things (maybe also because of your voice) makes me wanna listen until the very end which I believe is a very important skill in teaching. May I request a tutorial video on how to copy row values from sheet to sheet using Google Apps Script? Thank you! :)
Hi Merjohn. Thank you for the great feedback! I'll add your request to my list and will publish such a video in the future. So stay tuned to my channel. 😀
Hey Merjohn. I jost published the video you requested about copying a row from one sheet to another. Check it out: czcams.com/video/xmtwWKYLJHs/video.html
Thanks for doing a great job of explaining the basics of Google App Script. Sometimes you just need that one clear lesson to get your head around things, so thank you for that.
Great video to get started in Google Apps Script! One thing I noticed on mine is there's no script editor option in the Tools menu. I found this under Extensions -> Apps Script.
Thank you Jesse! In case you're interested in learning more about how you can automate Google Sheets I'll soon be launching an online course: courses.saperis.io/ Greetings from Switzerland, Chanel
Hi Paul. Thank you very much! I think Google Apps Script is awesome and I'm sure your teachers will be enjoying learning it. I also have some more Apps Script videos on my channel you can check out. Greetings, Chanel
Hi Chanel (hope I've spelt that correctly) - I was trying to duplicate a google slides preso with lots of google charts linked to a google sheet a few days ago but to change all the links to a new sheet - turns out it's not readily possible and stackoverflow shows a few people want this functionality so they can do a new wave/qtr with new data without having to repaste and resize literally every chart - eventually I worked out the only way is to duplicate the preso and also sheet then use GAS to loop thro the chartIds and remove and replace them with the new sheet's chart in the same position with the same width/height - many of your viewers are beginners but I suspect some are more advanced and would love this pro tip :). Mike
Hello Saperis. I'm starting to learn how to use Apps Script and after browsing throughout CZcams, I ended up here, on account of your very calm and tutorial way of explaining things. I have one question, though: on minute 18:25 you say that you could call the function onOpen() whatever you like. So when will the script figure out when to run this onOpe() function to start running? Isn't "onOpen()" the specific name that the script will look for to start running when you open the file? Once more, thank you.
Hi Luis. Yes, the onOpen() function runs when the file is opened. So here you would for example create a custom menu so you can then run the other functions you have created.
Hey thank you so much for this wonderful channel, I was looking forward towards making some projects which involves taking data and values from the sensors and having them on my sheets. Can you please help me out as to what should I approach as a total newbie into this. Once again a heartful thankyou :)
Hi Bharat. I'm happy you like this channel. Well, I think there are many different ways to get started with Google Apps Script depending on your prior knowledge. I have launched an online course for people who don't have any JavaScript knowledge and want to start processing data in Google Sheets. Check it out: courses.saperis.io
Thank you for the video, I have a question: what if I want to add more rows and columns for the table? should I edit the code every time for those changes?
Thank you for making this video. But I wanna ask you something. If I want delete the specific group of cells with the help of onedit function and one cell as trigger to run the script, what i need to write in Appscript. Please help in this regard. Thanks in advance
Well, I can show you how to do many things with Apps Script through the videos we published. But if you want to create a new script that does something else, I can't write the script for you.
Thanks for the video. Your teaching is clear! May I know if you have a video that allows me to call a function from a cell? I’m thinking of converting my excel sheets which has a few functions written in VBA. Thanks!
No, I don't have such a video. But how about going about this differently? Maybe using an onEdit trigger that runs your function when the sheet is updated? See the documentation for more infos: developers.google.com/apps-script/guides/triggers
Thank you so much for the video! I am trying to solve a problem where I have a Google form, and based on what user inputs for Q1, I want to autopopulate the answers for Q2, Q3, Q4, etc. from a Google spreadsheet. This is to save time for the end user filling the survey. I cannot use the prefill functionality as this is dependent on user response for a question. Can this be done using Appscript?
Your delivery of the content was great! Would I use Script Editor to insert a row above an entry automatically upon hitting the enter button in the F7 cell? Also, how would you return to Report Formatting to edit the code? Many thanks!
Hey there. I think your idea should be possible. May check the Google Apps Script documentation here: developers.google.com/apps-script/reference/document/table?hl=en#insertTableRow(Integer) If you want to edit the code gain you have to access Tools > Script Editor. Greetings,
Glad you like them! We have a whole playlist full in case you want to binge watch coding videos: czcams.com/play/PLNwCcck1-mNgASuUVvHeK282pvHzgWP-6.html 😀
... well explained - thank you - subscribed for more. What I missed from watching (my first contact with Google Scripts and without any testing): How is the script stored and how does it relate to my GSheets. Does the menu show up only in a specific sheet. What to do if I want it in all sheets? Does it require a log in (offline)? It would have been nice to publish the script with the video for a quick "rehearsal"
The script is store on Google Drive. You can find a list of all your scripts under script.google.com/u/0/home The script in the video is bound to that Google Sheets file and so it's only available for that file. If you want a script to be available for all your Sheets files you'll have to create an installable add-on. Find out more in the official Apps Script documentation: developers.google.com/apps-script
If you enjoyed this video, you might also like this one: czcams.com/video/x3xZXJmb05U/video.html
Please can you make a video on HOW TO SHOW THE USER INPUTS IN THE NEXT SECTION OF A GOOGLE FORM.
To throw more light on what I'm asking for: I want to create a google form that when the user enters some inputs in the first section those input will appear in the next section of the form.
I am a coder and have worked with Javascript before. But the fact that she has explained these concepts in such lucid language so that non coders can grasp it is amazing. Great Job. 🎉
Thank you for the feedback. I believe in teaching concepts and not simply sharing code which viewers can copy & paste.
@@saperis Did you intend to say "copy and turn to pasta?" ;-)
Check out my Google Sheets Automation online course: courses.saperis.io/
ive been in the coding game for about 2 years now, and by far the best tutorial for beginners indeed. usually when people say for "beginners" they still treat it like its advanced, or they already know coding/JavaScript terms. studying for an interview tomorrow and this helped a lot, so thank you. and also thank youfr breaking it down BY TERM for the true (no pun) beginners.
Happy to hear you find the video helpful. By the way, I've started making pure JavaScript videos for beginners. You might find them helpful.
All the best for your job interview!
Hello @Saperis, This one video cleared up a bunch of important concepts including adding script execution to the menu etc. Minute for minute the best video on the subject that I've seen. Very neatly done!
Great to hear and thank you for watching! 😀
🧡
Thank you so much! For a complete beginner in programming, this tutorial taught me so much more than I'd expected. Really appreciate your content and your articulate style of teaching. 30 out of 10!
Thanks for watching and learning with our video. Learning to code is a challenge but one you can master. 👍
🧡
Hello madam how to make student results viewer in Google sheet by typing index number
Non coders understand? Nah!
I am a python coder ... i have to say this was a delightful intro to gscript and well worth my time ... i LOVE your style ... so clear and concise ... no fat.
I'm happy you liked it. Have fun with Apps Script!
I just want to say what a well explained video. For someone who struggles understanding things easily, you do a fabulous job breaking things down. I am so excited to learn more from your videos. So glad I found this video!
Happy to hear that! We have a playlist full of beginner friendly JavaScript videos you might want to check out: czcams.com/video/x3xZXJmb05U/video.html
I've watched 10+ videos to get started on GS and was about to give up, but thank goodness I stumbled across your channel. Thank you very much
Great to hear! 😀
Finally, a true BEGINNER’s guide. I have zero knowledge in scripts and the other videos I watched were too overwhelming. This video really helped me a lot. Thank youuu
Glad it helped! There's a playlist with beginner friendly coding videos. Feel free to watch any video that might interest you: czcams.com/play/PLNwCcck1-mNgASuUVvHeK282pvHzgWP-6.html
I have watched many coding tutorial videos, and you have done such a fantastic job at explaining code to non-coders. Thank you so much
I am not a coder but loved the way she's explained it. precise and at a pace that a beginner can grasp the concepts and do it simultaneously.. Amazing job!
Happy you liked the video 😀
Very nice teaching here! Not only did the tutorial work and showed me how to do what I wanted, but the way you explained it is clear and understandable. This was my first foray into using the Apps Scripts, but it is not my last! Thank you.
Happy you liked it! We have an entire playlist with Google Apps Script videos. You might want to give it a look: czcams.com/play/PLNwCcck1-mNhiOoAGICW3fYKTP5gHZyjR.html
Your video series was needed years ago. Thank you so much, I learned a lot.
You're very welcome! I'll be adding a new Google Apps Script video every month.
🧡
This is my first video on the journey to learn appscript. I am truly impressed by the way you teach.
Thank you so much for this video.
Happy you liked it! 😀
I have an entire Google Apps Script playlist with lots of video tutorials you might find interesting: czcams.com/play/PLNwCcck1-mNhiOoAGICW3fYKTP5gHZyjR.html
Another dev here. I know lots about Javascript but your video introduced me to the Google Apps sandbox and API and how to expose scripts to my Sheets. Thanks so much!
Glad I could help! 😃
Thanks Kathie. This is the first time I actually managed to create and run a Google Apps Script successfully. Your presentation is well-structured and easy to follow.
Glad it was helpful! 😀
I've watched a lot of tutorials on google apps for beginners and all of them are so hard to understand. THIS IS THE ONLY channel that made sense to me. thanks! :D
Happy to hear that! 😀
Wow! I am impressed. I am a software engineer as well. I have to admit that no one really talks about these basics and good practices any more including the documentation. The whole industry has become adhoc development campus. I normally do not subscribe to the one time videos that I watch, but I did end up subscribing.
Happy to hear you like this video. You know the saying where you give someone a fish and they will eat for a day. But if you TEACH them how to fish they will eat every day.
I believe in teaching the HOW and WHY so that aspiring developers can apply concepts instead of only copy & pasting code.
And yes, learning to read and use the documentation of any technology is super important in my opinion.
What a great tut! I love the way you explain things. I could learn/listen all day!
Thanks for the feedback Corey. I put out a new Google Apps Script tutorial every month so stay tuned. 😀
And you might want to check out my online course: courses.saperis.io
🧡
Love your tutorial. explaining object and then breaking it down to its component. Awesome!
Glad you enjoyed it! 😀
This is one of the best beginner videos I've watched ever on anything.
Thanks for watching and learning with us. We have many more beginner-friendly Apps Script videos you can check out.
legit just made my personal "Data Science" playlist. Great teaching style!
Wow, I feel honored I made it on that playlist!
I've since changed my style of explaining a bit. If you want to, you could let me know if the new style works well too.
This is my newest Apps Script video: czcams.com/video/w9AXRfrhTCQ/video.html
This was super helpful! Thank you for creating this vid, can't wait to see what else you post.
You just made my day Tiph! Thank you for the feedback. 😀
If you have a chance do check out my Google Apps Script online course: courses.saperis.io
Have a good one!
You're a natural teacher, thanks a lot for the quality of the video
Thanks for the kind words. I truly enjoy creating these videos and sharing my knowledge with my viewers.
I love your video. It helps me to understand how does GA Script work as a beginner. Please keep uploading new videos. I believe many will appreciate.
Thanks for setting the record straight 👍
Thanks very much for your great tutorial. I've been experimenting with coding because many of my students work in Korea as software engineers. I wanted to understand what they were doing and your tutorial was my first success.
Happy to hear that. By the way, there's an entire playlist with beginner-friendly videos that might interest you: czcams.com/play/PLNwCcck1-mNgASuUVvHeK282pvHzgWP-6.html
@@saperis I'm going to watch them next for sure.
Awesome video!! You explained so well. I will have to rewatch it again to understand better.
I am completely new to the App Script...Hopefully, I can get used to of using this.
I'm sure you will learn it! Have fun.
I like when you mention what all the basic stuff means as you go along. I'm new to this craic and it's annoying having to pause other people's videos, Google stuff, then come back lol.
Well, many tutorial creators assume that their viewers already have coding experience.
I on the other hand create videos for viewers with little or no coding know-how. That's why my videos are good for beginners but experienced coders find them to be too basic.
Thanx for that quiet , slow explanation and wonderful algorithm of teaching what is coding for beginners. I subscribed and am waiting for your new videos.
Loved that tut. Style and flow - perfect! Thank you.
Glad you liked it! 😀
You definitely have a gift for teaching. I look forward to your other videos
Thanks for your motivating words! You might also want to check out my Google Apps Script online course: courses.saperis.io
The first lessons are for free so you can try out the course with no strings attached.
Very True.
Hi Saperis, your videos are awesome! The way you explain things (maybe also because of your voice) makes me wanna listen until the very end which I believe is a very important skill in teaching. May I request a tutorial video on how to copy row values from sheet to sheet using Google Apps Script? Thank you! :)
Hi Merjohn. Thank you for the great feedback!
I'll add your request to my list and will publish such a video in the future. So stay tuned to my channel. 😀
Hey Merjohn. I jost published the video you requested about copying a row from one sheet to another. Check it out: czcams.com/video/xmtwWKYLJHs/video.html
Thanks for doing a great job of explaining the basics of Google App Script. Sometimes you just need that one clear lesson to get your head around things, so thank you for that.
Happy this video helped you better understand Google Apps Script 😀
Very well made, enjoyed watching it and learned a lot on the way. Thank you soooo much !
Glad it was helpful! 😀
Hi! This helped me understand it better and makes me more motivated to learn Google Scripts, thanks. Cheers!
Great to hear Livia! Have fun with learning Google Apps Script. 😀
Your video is great! The explanation is super crystal clear! Thank you!
Thank you Carol! By the way, check out my Google Sheets Automation online course: courses.saperis.io
Greetings,
Chanel
I appreciate the time and detail you include in your explanations
thank you so much, i am graceful to find your channel!, I'll keep it up watching all your tutorials
Thank you! We are always happy to hear from our viewers. 😀
That's a actually really good intro to programming in general. Very professional and helpful. Thank you
Glad you like it! 😀
just learning how to code and i can say that the way you've demonstrated everything helped me out A LOT, very good tutorial.
Glad it helped! 😃
Brilliant! Best video I’ve seen ! Perfect for a complete newbie ! Thank u 🙏
Glad it was helpful! 😀
Great video!! You made it very easy to follow along and I actually made my first script work!!!
Congrats on your first script! 😀
Very detailed explanation of the basic definitions. Thank you for your video!
Glad it was helpful! 😀
🧡
Excellent. Was having trouble with Google script, but this helped a lot, thanks!
Glad it helped!
Finally, someone who knows how to walk us through it.
If you've liked this video I suggest you check out this playlist: czcams.com/play/PLNwCcck1-mNgASuUVvHeK282pvHzgWP-6.html
Wow, great tutorial! Thank you very much. Really well done!
You're very welcome! 😀
You are a really amzing Teacher. I dont speak english well but I understand everything you teach. Congratulation
"Easy programming language" --- U are the best ! 😊
Thank you 😀
Very well explain video saperis! I have seen many beginner tutorials. this is one of the best :)
Glad it was helpful! 😀
Thank you so much it worked kindly please teach more about google spreadsheets the way you teach is awesome and understandable.
Thank you very much! I'm happy that others can learn from my experience and go on to create useful Google Apps Script automations. - Chanel
Thanks so much for this tutorial, starting to write my Google Script codes !
Happy to hear that! Have fun with Apps Script. 😀
Super helpful tutorial! I created my first Google Apps Script!
Great video to get started in Google Apps Script! One thing I noticed on mine is there's no script editor option in the Tools menu. I found this under Extensions -> Apps Script.
Yep, Google updated the Google Sheets menu since I made this video tutorial.
so nice teaching, teacher like you very rare on CZcams, I just found you today, and soon i will learn a lot from you.... .
Happy to hear that! 😀
Teaching is truly an ART and you got it, I really like your style. 😁
Thank you very much 😀
Super nice! Wasn't looking for that but loved it anyway.
In that case, I'm glad the CZcams algorithm brought you to my video. 😀
Lover from India. Thank you so much. Really appreciate your content and your articulate style of teaching. Keep doing.
Thanks, will do! 😀
You're top notch .... The Best instructor.
Thank you for watching my video and learning through it. 😀
I have subscribed. You are a fantastic teacher, BTW!
Thank you Jesse! In case you're interested in learning more about how you can automate Google Sheets I'll soon be launching an online course: courses.saperis.io/
Greetings from Switzerland,
Chanel
Thank you for your sharing. Very useful for beginners!
This is great! Assigning to my teachers as summer PD!
Hi Paul. Thank you very much! I think Google Apps Script is awesome and I'm sure your teachers will be enjoying learning it. I also have some more Apps Script videos on my channel you can check out.
Greetings, Chanel
Thank you so much, Saperis
It is what I look for so far
Love from Indonesia
Happy to help. 😀
Hi Chanel (hope I've spelt that correctly) - I was trying to duplicate a google slides preso with lots of google charts linked to a google sheet a few days ago but to change all the links to a new sheet - turns out it's not readily possible and stackoverflow shows a few people want this functionality so they can do a new wave/qtr with new data without having to repaste and resize literally every chart - eventually I worked out the only way is to duplicate the preso and also sheet then use GAS to loop thro the chartIds and remove and replace them with the new sheet's chart in the same position with the same width/height - many of your viewers are beginners but I suspect some are more advanced and would love this pro tip :). Mike
Thanks for sharing your solution to this problem Mike! 👍
Hello Saperis. I'm starting to learn how to use Apps Script and after browsing throughout CZcams, I ended up here, on account of your very calm and tutorial way of explaining things.
I have one question, though: on minute 18:25 you say that you could call the function onOpen() whatever you like. So when will the script figure out when to run this onOpe() function to start running? Isn't "onOpen()" the specific name that the script will look for to start running when you open the file?
Once more, thank you.
Hi Luis. Yes, the onOpen() function runs when the file is opened. So here you would for example create a custom menu so you can then run the other functions you have created.
🧡
Mam the way you explained is truly awesome and easily understandable.
Thankyou so much for providing us these types of videos.
Keep up the good work 💯
It's my pleasure 😃
I love your channel, thank you so much.
Please more videos about Google Apps Script and Form.
Greetings from Perú 🇵🇪
Thank you for the feedback! 😀
Hey thank you so much for this wonderful channel, I was looking forward towards making some projects which involves taking data and values from the sensors and having them on my sheets. Can you please help me out as to what should I approach as a total newbie into this.
Once again a heartful thankyou :)
Hi Bharat. I'm happy you like this channel.
Well, I think there are many different ways to get started with Google Apps Script depending on your prior knowledge.
I have launched an online course for people who don't have any JavaScript knowledge and want to start processing data in Google Sheets. Check it out: courses.saperis.io
🧡
Best teacher I have seen in my life 😊😊
That's so nice of you! Check out my online course if you want to dive deeper into Google Apps Script: courses.saperis.io
Yes she is very good, that said however either your to young, you have not seen many teachers or you have the world's worst luck.
Productivity at its peak! Thankyou!
Thanks for watching 😀
just loved it! Thank you for your efforts :)
Glad you enjoyed it!
Thank you for the video, I have a question: what if I want to add more rows and columns for the table? should I edit the code every time for those changes?
You can define a different range in the sheet. Check this video: czcams.com/video/w9AXRfrhTCQ/video.html
well done and clear basics!
Thank you for watching 😃
Thank you for making this video. But I wanna ask you something. If I want delete the specific group of cells with the help of onedit function and one cell as trigger to run the script, what i need to write in Appscript. Please help in this regard.
Thanks in advance
Well, I can show you how to do many things with Apps Script through the videos we published. But if you want to create a new script that does something else, I can't write the script for you.
They're not kidding in the comments section. You're awesome at teaching.
Thank you. It makes me happy to see others learning through our videos. 😀
New subscriber earned. Thanks a bunch!
Awesome, thank you!
Thanks for the video. Your teaching is clear! May I know if you have a video that allows me to call a function from a cell? I’m thinking of converting my excel sheets which has a few functions written in VBA. Thanks!
No, I don't have such a video. But how about going about this differently? Maybe using an onEdit trigger that runs your function when the sheet is updated? See the documentation for more infos: developers.google.com/apps-script/guides/triggers
@saperis if you call the function at line 18 anything other than "onOpen()" then it wouldn't work, and the menu wouldn't appear.
Correct. onOpen is a simple trigger and has to be written like that.
Brilliant tutorial for an introduction to Google Script.
Happy you liked it 😃
Eres la mejor! Graciaaaaas desde Mexico City.
Muchas gracias! Has visto que tengo un curso online? Lo puedes ver en courses.saperis.io
Thank you so much for this great tutorial, much appreciated it.
You're very welcome!
This helps me a lot getting started with App Script. Thank you Chanel
Great to hear! Have fun with Google Apps Script. 😀
Really good way of explaining how to do things and what they mean. really well explained. Thank you
You're very welcome! 😀
🧡
Thanks for the video! With this and some forums I was about to get my first script going!
Happy to hear that!
Excellent tutorial, thank you so much!
You're very welcome!
Thank you so much for the video! I am trying to solve a problem where I have a Google form, and based on what user inputs for Q1, I want to autopopulate the answers for Q2, Q3, Q4, etc. from a Google spreadsheet. This is to save time for the end user filling the survey. I cannot use the prefill functionality as this is dependent on user response for a question. Can this be done using Appscript?
I've never done anything like that. But in theory it should be possible.
Your delivery of the content was great! Would I use Script Editor to insert a row above an entry automatically upon hitting the enter button in the F7 cell? Also, how would you return to Report Formatting to edit the code? Many thanks!
Hey there. I think your idea should be possible. May check the Google Apps Script documentation here: developers.google.com/apps-script/reference/document/table?hl=en#insertTableRow(Integer)
If you want to edit the code gain you have to access Tools > Script Editor.
Greetings,
🧡
🧡
Thank you so much for this beautiful piece of knowledge. Respect and regard for you
Glad it was helpful! 😀
Lovely tutorial, thank you so much!
Glad it was helpful! 😀
Amazing didactics! Thank you for sharing!
My pleasure! 😀
Thank you for making this video. I would love to understand enough to use appscript.
Glad it was helpful! Learning a new skill is all about not giving up. Just keep at it and you'll learn it. 👍
Just lovely! Thank you.
Glad you enjoyed it! 😀
This video really helped me thanks!🙂
Thanks a lot saperis for these Apps script tutorials.👌
Glad you like them! We have a whole playlist full in case you want to binge watch coding videos: czcams.com/play/PLNwCcck1-mNgASuUVvHeK282pvHzgWP-6.html
😀
thank you so much for this video. really appreciate
Glad it was helpful! 😀
Great video! You just got one subscriber :)
Welcome aboard in that case! 😀
... well explained - thank you - subscribed for more.
What I missed from watching (my first contact with Google Scripts and without any testing):
How is the script stored and how does it relate to my GSheets.
Does the menu show up only in a specific sheet.
What to do if I want it in all sheets?
Does it require a log in (offline)?
It would have been nice to publish the script with the video for a quick "rehearsal"
The script is store on Google Drive. You can find a list of all your scripts under script.google.com/u/0/home
The script in the video is bound to that Google Sheets file and so it's only available for that file.
If you want a script to be available for all your Sheets files you'll have to create an installable add-on.
Find out more in the official Apps Script documentation: developers.google.com/apps-script
Super helpful video :) thank you!
You‘re welcome Jacob. Let me know if there‘s any other Google Apps Script related topic you would want me to cover. - Chanel
There was really cool. Thanks for explanation!
Glad you liked it! 😃
Thank you for this!
My pleasure!