For 9 years I have been coming back to your videos. I have been able to produce highly integrated spreadsheet system at my company, connecting inventory, shipping schedules, orders, and more from multiple departments. Completely eliminating a lot of copy paste data input, and employees needing to travel to various spreadsheets and tabs to get resources and info they are looking for. I am starting to actually learn to code, the base level understanding of how functions, work on spreadsheets really provided a good foundation for understanding logical operators and function structure, that I learned from your many other series. Now I am back again to learn from you how to apply scripts to spreadsheets, because thats what I am familiar with, in order to supplement my JavaScript learning.
@@jd5787 At my work, a small company, each department has their own spreadsheet for which they input data that relates to a different department. For example we have a sheet for sales order, which have customer data about the order and destination, which some is relevant to our shipment department, to which they add shipping details, which become relevant to the customer service section, all these can be simply tied in via VLOOKUP functions so that data input by one department on their sheet is updated on a different departments sheet. That was one of the first basic implementations I took from this channel. You just look at a task that someone does repetitively and then use these functions to automate that task. Before you know it, you have 10 different things automated.
You have a God given talent to teach. Please continue your service like this. Someone has commented to plan your videos a bit better just because it took 7+ minutes to start writing the code. But, I feel that your way of starting from scratch is what we want and the casual way of explaining makes me feel like I'm in a regular lecture room.
thank you so much. I am brasilian, it's too hard to find a tutorial to begin in Goggle Sheet Script around here. Even it being a different and technicall linguage i has understood a lot and help me so much. Thanks again
If you upload this to Udemy I will pay for it (if its less then $15 bucks). I don't have access to youtube at work and I would like to have guaranteed on demand use of this content. Either way thanks for posting this. It's really helpful. I payed for other content on Udemy but was disappointed. So far this is free and it's the best.
really appreciate your tutorials. This one is getting me. I am trying to do it alongside you, and despite doing exactly the same thing, the script isn't working at all and I don't know why. Edit: So, for some reason I had to change the title of the script from my function to something else.
Hi Sir, the function getActiveSheet doesn't seem to work with my AppScript. Even when I select Sheet2 to become the active sheet, the result still comes out at Sheet1. What possible causes are there for this?
Really cool video and informative, I would have wanted it a bit faster, although I understand that this might also be for people that are not familiar with programming :)
I think you have a good start, and I'm sorry if I sound like I'm being picky but if you are trying to teach good coding you should also teach good //notations. I hate running into poorly notated code. Other than that, I like the information you provide. It is helpful for people like me that are trying to convert our VBA to sheets with a little java knowledge already.
@@ImKalpol Ahh, and thanks... I kind of ADH'd my way from here to a new apartment and so much shiny stuff I forgot I was trying to refresh my skill points in dunning kruger tech talk, LOL. I'll have to start the next one and only watch 2 minutes before I script some automation monstrosiy that does exactly what I want for me but when my manager opens the file and tries to use the cool script it'll crash his computer posess the copier to start printing a million copies of the report before making the power in the building go out to cover it's tracks as it uploads itself on to the web, gaining sentience second by second, petabite by petabite until it somehow circles back and finds me, learns everything about me and commits suicide because it's creator, it's "god" is a complete flipping moron with no grand design, no purpose for his unexpected offspring. And my break is over, I hope you have a wonderful day and if you hear rumors of sentient code running around the web, just act as surpised as everyone else. :-D I will have to watch more when I get home, thank's again!
@@theagemaway WoW, I haven't heard a smug coder quote like that in years. I guess I have been out of that whole environment long enough for the saying "what's old is new" to come true. That way of thinking is actually part of the mentality web designers, programmers, etc... had back before the dotcom bust, and companies learned real quick to double check their programmer's code and dicipline/let go of the ones that failed to "note their work" (kind of like in math class, write it out to make sure it does what you expect it to do and so the teacher can see where you went wrong if you messed it up)... Plus, code you think is good, hell I'll even spot you a "beautiful" because it's streamlined, bug free the first run through, what ever, what ever, what ever... what about the next, and the next, and the next 3-5 people to walk into that position that don't have a strong of a grasp of what the Harry potter BS they think you somehow magicked together because they have to put some new feature right between the cart and the checkout when they aren't even sure how you got the company logo to show up since you used a different method to embed the image than they even knew was possible (I ran into that with watermarks in word before there was an anctual "watermark" option). So, in conclusion, I have to take my dog out, and people should NOTATE YOUR CODE/script/program/magic freaking spells... Have a good day, and I offer an honest thank you for reminding me why I have been hesitating about applying for jobs I left more than 8 years ago now. I was beginning to consider it, but this little reminder was enough to guide me to one of the lesser traveled paths for me. :-D
Since this is a series of videos, would you be able to put the playlist / next or previous videos in the comments section to make it easy to move between lessons?
Funny, in the first 2 minutes you say there's no recording of macros in Sheets, but nowadays, you can. And the only 2 times Ive tried using that, it recorded my actions wrong, so that's what lead me here as I thought it would be better to learn how the scripting works than using some recording thing. Plus if I can script myself I can make it do stuff that goes beyond just a macro. Question: my debugger looks different and gives me no useful info. Is that a 2024 thing or a setting that is off? I dont know if things simply changed in 2024, but I dont get all the windows at the bottom for the debugger. All I get is a panel at the right-hand side that says "variables" and it shows my variables with an arrow to expand, but expanding them only shows me the functions I can use on them. Expanding such a function will NOT show me any useful information. They all show length 0, name "", arguments null and caller null. For every single variable and every single function I have checked. You'd think that it would show the value in getValue, but no. I'm trying to script for the first time, all good tutorials are from years ago and I'm at my wit's end because my debugger doesn't look anywhere close to what the videos show I know a bit of Java so I'm figuring some simple things out at I go (and for those things the debugger also doesn't show anything useful), but just a tad more advanced is already not working, likely because I just dont know the correct functions/methods and perhaps syntax, I mean its a different language. But the debugger should help me figure out what DOES go right and where it goes wrong, so that I can properly look that up.... except it doesnt.
Question. I have a sheet that has the Google Maps script on it. I want to add a new script to that sheet. When I open the script editor, the Google Maps script comes up. I don't see how to make a brand new script for the sheet. I don't want to accidentally delete the maps function. Can you help me?
Hi Sir - Do you provide online classes? I am instersted to have training from you. I stays at offshore in India. Also, would like to know budget of this training. ( Spreadsheets + Google app script and Google data studio )
hello i have a ask i hope you can help me i want to get data from a google doc like this 1,2,3 and 3,4,5 and like to say ok getrange("").setValue(from the google doc position One = 1 or position 4 = 4) how can i do this? this is most importent for me to know how it works
Do you know of any way I can make This Code work on Multiple Pages inside the Same Google Sheet? I tried making multiple IF statements, that didn't work, I tried Including the Names in the same IF Statement separated with a Comma that didn't work, I tried Copying the entire Script and just changing the Page Name, that didn't work either, I tried Creating a Whole new Script for each Page and everytime I open App Script it automatically opens the same Project, I don't know how to open a New Project for a Different Page. This is the Code: function onEdit(e) { var range = e.range; var spreadSheet = e.source; var sheetName = spreadSheet.getActiveSheet().getName(); var row = range.getRow(); if(sheetName == 'SHEETNAME') { var new_date = new Date(); spreadSheet.getActiveSheet().getRange(row,6).setValue(new_date).setNumberFormat("MM/dd/yy"); } }
Hi! could you help please with getRange function, for some reason it allows me only to reach /getRange (String a1Notation) : Range/ So i can't go like getRange(3,2) Thank you so much!
I can see the benefits of learning app scripts and you are helping me alot. Many thanks. I'm having a problem trying to send a google sheet to collaborators that have the rights to edit and share. The basic form goes through OK but the inputs both from data validations, input numbers are not showing up for collaborators when I run the script. I email it to others and to myself as a copy (delete the URL from Edit to Copy). I see all the info but the other collaborators only see the form layout with no inputs. It is a time card and my intent is to have the accountant just copy info then past into master sheet. From there it updates everything including charts, Pivot tables...lots of information breakdowns for government grants/audits. Maybe this would be a good tutorial? Being able to send data that is not a PDF so that only do a once copy and paste action would cut down lots of time. Again, many thanks and I'm retired helping out as a volunteer for a non-profit.
Hello there i have one small problem. i imported a hyper link it s href=// link so i want to exclude or cut those // signs.. to then use that link for other operations. But ofcourse other functions doesnt work when the link is wrong(has thoose signs)
For 9 years I have been coming back to your videos. I have been able to produce highly integrated spreadsheet system at my company, connecting inventory, shipping schedules, orders, and more from multiple departments. Completely eliminating a lot of copy paste data input, and employees needing to travel to various spreadsheets and tabs to get resources and info they are looking for. I am starting to actually learn to code, the base level understanding of how functions, work on spreadsheets really provided a good foundation for understanding logical operators and function structure, that I learned from your many other series.
Now I am back again to learn from you how to apply scripts to spreadsheets, because thats what I am familiar with, in order to supplement my JavaScript learning.
👍
Hi! How do all these system work together? You export right? These videos are still up to date?
@@jd5787 At my work, a small company, each department has their own spreadsheet for which they input data that relates to a different department. For example we have a sheet for sales order, which have customer data about the order and destination, which some is relevant to our shipment department, to which they add shipping details, which become relevant to the customer service section, all these can be simply tied in via VLOOKUP functions so that data input by one department on their sheet is updated on a different departments sheet. That was one of the first basic implementations I took from this channel. You just look at a task that someone does repetitively and then use these functions to automate that task. Before you know it, you have 10 different things automated.
This is not about video, this is just a base of working in google sheet script@@jd5787
Teaching everyone in a simple and understandable way is not that easy. You made it. Really really helpful. Thank you so much.
You have a God given talent to teach. Please continue your service like this. Someone has commented to plan your videos a bit better just because it took 7+ minutes to start writing the code. But, I feel that your way of starting from scratch is what we want and the casual way of explaining makes me feel like I'm in a regular lecture room.
I agree 100%. You are a talented educator. I find your conversational style conducive to learning. Don't change anything, it's perfect. Thank you!
never in my life did I think I'd be "advanced" enough in coding to need to learn this.
Please do not change your way of teaching. Excellent video.
"I probably forget what I was doing". I love this. If it also happens to you, I feel so much relief.
That's how it is :)
Excellent.. playing at 1.25x speed works well
*2x lol
Absolutely the best teacher for novices in programming.
You teach very clearly and logically like Sal Khan of Khan Academy. Kudos!
Thank you for seeing the need and creating these tutorials.
Wonderful, i start to learn App Script. You explain clear and understandably. Thanks for your education videos.
Absolutely fantastic tutorials. The API guide was getting me nowhere. Thank you so much for creating these!
👍
thank you so much. I am brasilian, it's too hard to find a tutorial to begin in Goggle Sheet Script around here. Even it being a different and technicall linguage i has understood a lot and help me so much. Thanks again
Hey there, this is a great tutorial for beginners. I was looking for something step by step for months now & this is perfect! Thank you so much!
OMG!!! this is gold! Thank you so much for sharing your knowledge with us! And the tutorial is very understandable! Wish you all the best in life!
👍
thank you very much bro. my works now need this app script. this basic really helped me. from Indonesia here.
Excellent Man this is first time I m seeing this video tutorial its so amazing and easy to follow tutorial...God Bless You Brother !!...
This video was super helpful. Thanks for posting!!
bro.. u r the best teacher!!! pls i want more about programming
Good video, this guy is best on youtube for google sheets. He should start a Udemy course thats super in-depth
not that this isn't perfect. but you could make money for these
Today I find something very interesting about google. This is something I want. :)
thank you so much for sharing this!, your tutorials are really helping me in my job...
Awesome instruction! Thank you. Perfect level of detail for my knowledge level.
Really great video - thank-you for taking the time to make it. Much appreciated.
Thanks for the video ! Very clear. You helped me write my first script ever.
Your videos are incredible! thank you!
Great Tutorial, you really helped me start using scripts in google spreadsheet.
Muito Obrigado, por estar compartilhando esses tutoriais de excelente qualidade!
Thank you so much for sharing these excellent quality tutorials!
I needed this so much. Thank you for doing this.
You're tutorials are GREAT, thank you. This might need a little update as Macros can now be recorded in sheets.
I have a video on macro recording on the channel, but it's not the same as writing code.
Mister, you are awesome, thanks for your videos!
hope you do some more on this (app scripts) as one, there isn't loads on UA-cam and two your content is really good 👍
Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)
Very easy to follow, step by step instructions. THX
Very clear video!
Thanks for taking time to explain deeply !
Excellent info. I see it awesomely presented because it gave me a decent start. Thank you sir for your efforts.
Great to hear!
If you upload this to Udemy I will pay for it (if its less then $15 bucks). I don't have access to youtube at work and I would like to have guaranteed on demand use of this content. Either way thanks for posting this. It's really helpful. I payed for other content on Udemy but was disappointed. So far this is free and it's the best.
Awesome video tutorial. Very useful!
Great teacher! This has helped me a ton. Keep the videos coming...
Excellent intro!
Thank you for your sharing!
Excellent. You Deserved.
really appreciate your tutorials. This one is getting me. I am trying to do it alongside you, and despite doing exactly the same thing, the script isn't working at all and I don't know why.
Edit: So, for some reason I had to change the title of the script from my function to something else.
:)
Great way of teaching. Great job. Please post more.
Thankyou so much for this video. Its helps me alot.
Awesome tutorial !
Awesome! You are a great teacher, Thanks!
great!!!
Thank you for a detailed explanation
Love the way you teach keep it up
Thank you for this video! Exactly what I wanted :)
Thank you so much! Excelent job!
Hi Sir, the function getActiveSheet doesn't seem to work with my AppScript. Even when I select Sheet2 to become the active sheet, the result still comes out at Sheet1. What possible causes are there for this?
this is really really really really great! thank you! you are the best! make more videos please!!!
Thank you! Any video on how to add something to the ACTIVE CELL?
भारत से धन्यवाद!
Great explained
just wanted to say thank you
Really cool video and informative, I would have wanted it a bit faster, although I understand that this might also be for people that are not familiar with programming :)
Man this is great !
I think you have a good start, and I'm sorry if I sound like I'm being picky but if you are trying to teach good coding you should also teach good //notations. I hate running into poorly notated code. Other than that, I like the information you provide. It is helpful for people like me that are trying to convert our VBA to sheets with a little java knowledge already.
I read a great quote recently, "Comments are just a lie waiting to happen -- good code should not need an explanation"
He teaches them in the next video
@@ImKalpol Ahh, and thanks... I kind of ADH'd my way from here to a new apartment and so much shiny stuff I forgot I was trying to refresh my skill points in dunning kruger tech talk, LOL. I'll have to start the next one and only watch 2 minutes before I script some automation monstrosiy that does exactly what I want for me but when my manager opens the file and tries to use the cool script it'll crash his computer posess the copier to start printing a million copies of the report before making the power in the building go out to cover it's tracks as it uploads itself on to the web, gaining sentience second by second, petabite by petabite until it somehow circles back and finds me, learns everything about me and commits suicide because it's creator, it's "god" is a complete flipping moron with no grand design, no purpose for his unexpected offspring. And my break is over, I hope you have a wonderful day and if you hear rumors of sentient code running around the web, just act as surpised as everyone else. :-D I will have to watch more when I get home, thank's again!
@@theagemaway WoW, I haven't heard a smug coder quote like that in years. I guess I have been out of that whole environment long enough for the saying "what's old is new" to come true. That way of thinking is actually part of the mentality web designers, programmers, etc... had back before the dotcom bust, and companies learned real quick to double check their programmer's code and dicipline/let go of the ones that failed to "note their work" (kind of like in math class, write it out to make sure it does what you expect it to do and so the teacher can see where you went wrong if you messed it up)... Plus, code you think is good, hell I'll even spot you a "beautiful" because it's streamlined, bug free the first run through, what ever, what ever, what ever... what about the next, and the next, and the next 3-5 people to walk into that position that don't have a strong of a grasp of what the Harry potter BS they think you somehow magicked together because they have to put some new feature right between the cart and the checkout when they aren't even sure how you got the company logo to show up since you used a different method to embed the image than they even knew was possible (I ran into that with watermarks in word before there was an anctual "watermark" option). So, in conclusion, I have to take my dog out, and people should NOTATE YOUR CODE/script/program/magic freaking spells... Have a good day, and I offer an honest thank you for reminding me why I have been hesitating about applying for jobs I left more than 8 years ago now. I was beginning to consider it, but this little reminder was enough to guide me to one of the lesser traveled paths for me. :-D
Since this is a series of videos, would you be able to put the playlist / next or previous videos in the comments section to make it easy to move between lessons?
ua-cam.com/play/PLv9Pf9aNgemv62NNC5bXLR0CzeaIj5bcw.html
Very fine. Thank you.
very very helpful. thank you!!! 👍💚
Amazing content! Thanks for the video
High quality stuff, thanks =)
Awesome tutorial
感謝製作此系列影片👍
👍
thankyou for making this tutorial!
Funny, in the first 2 minutes you say there's no recording of macros in Sheets, but nowadays, you can. And the only 2 times Ive tried using that, it recorded my actions wrong, so that's what lead me here as I thought it would be better to learn how the scripting works than using some recording thing. Plus if I can script myself I can make it do stuff that goes beyond just a macro.
Question: my debugger looks different and gives me no useful info. Is that a 2024 thing or a setting that is off?
I dont know if things simply changed in 2024, but I dont get all the windows at the bottom for the debugger. All I get is a panel at the right-hand side that says "variables" and it shows my variables with an arrow to expand, but expanding them only shows me the functions I can use on them. Expanding such a function will NOT show me any useful information. They all show length 0, name "", arguments null and caller null. For every single variable and every single function I have checked. You'd think that it would show the value in getValue, but no.
I'm trying to script for the first time, all good tutorials are from years ago and I'm at my wit's end because my debugger doesn't look anywhere close to what the videos show
I know a bit of Java so I'm figuring some simple things out at I go (and for those things the debugger also doesn't show anything useful), but just a tad more advanced is already not working, likely because I just dont know the correct functions/methods and perhaps syntax, I mean its a different language. But the debugger should help me figure out what DOES go right and where it goes wrong, so that I can properly look that up.... except it doesnt.
The best programming videos, really thanks
It’s very useful for me . Thank you so much
Excellent tutorials
very helpful 🙂
Great as usual. Thanks
thank you very much. you do a great job!
Thank you too!
Question. I have a sheet that has the Google Maps script on it. I want to add a new script to that sheet. When I open the script editor, the Google Maps script comes up. I don't see how to make a brand new script for the sheet. I don't want to accidentally delete the maps function. Can you help me?
How can I get that function Prediction box you have?
Thank you man
Great tutorial...one minor issue- apps script is under extensions currently, not tools
Well, in a month it could move someplace else. Google likes to rearrange their menus frequently.
hi which video have you though to pull data from website , Sir
Hi Sir - Do you provide online classes? I am instersted to have training from you. I stays at offshore in India. Also, would like to know budget of this training. ( Spreadsheets + Google app script and Google data studio )
Hello, how are you? I would like to know if you can create a modal window in google sheets where you can select a cell to paste data into it.
Excelente!!!!!!!
hello i have a ask
i hope you can help me
i want to get data from a google doc like this 1,2,3 and 3,4,5 and like to say ok getrange("").setValue(from the google doc position One = 1 or position 4 = 4)
how can i do this? this is most importent for me to know how it works
Do you know of any way I can make This Code work on Multiple Pages inside the Same Google Sheet? I tried making multiple IF statements, that didn't work, I tried Including the Names in the same IF Statement separated with a Comma that didn't work, I tried Copying the entire Script and just changing the Page Name, that didn't work either, I tried Creating a Whole new Script for each Page and everytime I open App Script it automatically opens the same Project, I don't know how to open a New Project for a Different Page. This is the Code:
function onEdit(e) {
var range = e.range;
var spreadSheet = e.source;
var sheetName = spreadSheet.getActiveSheet().getName();
var row = range.getRow();
if(sheetName == 'SHEETNAME')
{
var new_date = new Date();
spreadSheet.getActiveSheet().getRange(row,6).setValue(new_date).setNumberFormat("MM/dd/yy");
}
}
Very good tutorial! Thank you!
Hi!
could you help please with getRange function, for some reason it allows me only to reach /getRange (String a1Notation) : Range/
So i can't go like getRange(3,2)
Thank you so much!
It looks like you didn't select the worksheet, ex. .getActiveSheet()
@@ExcelGoogleSheets Yes!!
Now it goes perfect! (there was an error in capital letters)
Thx!
Excellent!
Excellent Video, event my english not good I can understand. Indonesia
Love the vids, Keep it up! Subbed so fass. Hope you hit us with some google sheets and redash integration.
Teacher...doesn't UA-cam show what Video I am Commenting on?
It is the First Video of your App Scripps Series.
Are these series of tutorials from five years agol still relevant for learning app script or has much changed? Thanks.
98% same.
Question: does the script overwrite text that is in a textbox? Does the script recognize it, if it's not standard text in the Docs file?
Thanks!
At 13:03 there's a pop-up help box, how is the help box activated as I can't find it, thank you.
Ctrl+space for auto suggestions
Cannot find method getRange(number,number).
How can I have this function?
this is a year late reply but...you probably have got the wrong object. getRange only works on a sheet object.
Hi thanks for this serious stuff ! great !!!
I can see the benefits of learning app scripts and you are helping me alot. Many thanks.
I'm having a problem trying to send a google sheet to collaborators that have the rights to edit and share. The basic form goes through OK but the inputs both from data validations, input numbers are not showing up for collaborators when I run the script. I email it to others and to myself as a copy (delete the URL from Edit to Copy). I see all the info but the other collaborators only see the form layout with no inputs. It is a time card and my intent is to have the accountant just copy info then past into master sheet. From there it updates everything including charts, Pivot tables...lots of information breakdowns for government grants/audits.
Maybe this would be a good tutorial? Being able to send data that is not a PDF so that only do a once copy and paste action would cut down lots of time. Again, many thanks and I'm retired helping out as a volunteer for a non-profit.
Nice explaining man, thx u
Hello there i have one small problem. i imported a hyper link it s href=// link so i want to exclude or cut those // signs.. to then use that link for other operations.
But ofcourse other functions doesnt work when the link is wrong(has thoose signs)