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
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 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.
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.
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.
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! 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!
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 :)
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"); } }
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
Hy i think u can help me.. I want to insert a number in a cell for one minute and for another minute it should be blank alternatively. Can u help me for this code..?
I am getting this error while working on this. Sign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In. Can anyone help?
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)
Sir i have a sheet in which i have imported some data from a website. The value updates every day. I want to print value from a particular cell at the end of everyday, or plot the chart, so that i can analyze the data to see how was the behavior of change for that particular data. Is it possible to to?? If yes then please guide me.
Why there is no saveAndClose () for sheets in app script. My sheets get modified in app script and when emailed automatically in app script , it sends the unmodified email. Help
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
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 )
Is there a way to have a data validation in a cell only if the previous cell fullfill certain set criteria or say data validation with 2 criteria (range and custom formula) Thanks
When I try and run the script on "Sheet 2 " it keeps running the data into "Sheet 1" despite "Sheet 2" being the active sheet. My script matches yours exactly but I cant seem to get this to work. any suggestions? P.s Thank you for the helpful content.
Same problem here. No idea why it's happening. I solved it by manually choosing the sheet I want to use function in var activeSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet2");
Hi, I get error message "You don't have permission setValue()" bla bla... It was working before. EDIT: Eh, now I see, i tried to run my function in the cell. You do it by pressing "Run" command.
When I click review permission, it says "Sign in with Google temporarily disabled for this app" even tho I'm using same gmail for app script and google sheet and google account. Anyone knows why?
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.
never in my life did I think I'd be "advanced" enough in coding to need to learn this.
Excellent.. playing at 1.25x speed works well
*2x lol
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!
Great basic introduction, covered things that other "basic" tutorials failed to.
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 :)
Absolutely fantastic tutorials. The API guide was getting me nowhere. Thank you so much for creating these!
👍
Absolutely the best teacher for novices in programming.
Thank you for seeing the need and creating these tutorials.
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
You teach very clearly and logically like Sal Khan of Khan Academy. Kudos!
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!
thank you very much bro. my works now need this app script. this basic really helped me. from Indonesia here.
bro.. u r the best teacher!!! pls i want more about programming
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!
👍
Awesome instruction! Thank you. Perfect level of detail for my knowledge level.
Very easy to follow, step by step instructions. THX
Excellent Man this is first time I m seeing this video tutorial its so amazing and easy to follow tutorial...God Bless You Brother !!...
Muito Obrigado, por estar compartilhando esses tutoriais de excelente qualidade!
Thank you so much for sharing these excellent quality tutorials!
thank you so much for sharing this!, your tutorials are really helping me in my job...
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.
Thanks for the video ! Very clear. You helped me write my first script ever.
This video was super helpful. Thanks for posting!!
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
Very clear video!
Thanks for taking time to explain deeply !
Today I find something very interesting about google. This is something I want. :)
I needed this so much. Thank you for doing this.
Great Tutorial, you really helped me start using scripts in google spreadsheet.
Really great video - thank-you for taking the time to make it. Much appreciated.
great!!!
Your videos are incredible! thank you!
just wanted to say thank you
hope you do some more on this (app scripts) as one, there isn't loads on RUclips and two your content is really good 👍
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?
Thank you for your sharing!
Great teacher! This has helped me a ton. Keep the videos coming...
The best programming videos, really thanks
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.
:)
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.
Thankyou so much for this video. Its helps me alot.
Mister, you are awesome, thanks for your videos!
Great way of teaching. Great job. Please post more.
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.
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?
Love the way you teach keep it up
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!
Awesome! You are a great teacher, Thanks!
Excellent intro!
Thank you for a detailed explanation
भारत से धन्यवाद!
Thank you for this video! Exactly what I wanted :)
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 :)
Excellent Video, event my english not good I can understand. Indonesia
this is really really really really great! thank you! you are the best! make more videos please!!!
Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)
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");
}
}
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
Hy i think u can help me..
I want to insert a number in a cell for one minute and for another minute it should be blank alternatively.
Can u help me for this code..?
It’s very useful for me . Thank you so much
Very fine. Thank you.
Thank you so much! Excelent job!
Excellent. You Deserved.
I am getting this error while working on this. Sign in with Google temporarily disabled for this app.
This app has not been verified yet by Google in order to use Google Sign In. Can anyone help?
Try to go to myaccount.google.com/permissions
Find the script and remove permissions. Then try to run the script and give permissions again.
It wont let me run, it says i need to review permissions, but when I sign in, it says "this app isn't verified"
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!
Hi.if i want to import data from sheet1 and calculate it and put the result in sheet2 but dont show result in sheet 1.How could i do that
Teacher...doesn't RUclips show what Video I am Commenting on?
It is the First Video of your App Scripps Series.
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)
i need exalty what you did , but in on 2ns sheet of the application
Sir i have a sheet in which i have imported some data from a website. The value updates every day. I want to print value from a particular cell at the end of everyday, or plot the chart, so that i can analyze the data to see how was the behavior of change for that particular data. Is it possible to to?? If yes then please guide me.
Why there is no saveAndClose () for sheets in app script. My sheets get modified in app script and when emailed automatically in app script , it sends the unmodified email. Help
hi which video have you though to pull data from website , Sir
Awesome video tutorial. Very useful!
Awesome tutorial !
Can you help me write a script to export info from google sheets to google doc on a label template? im raw..
Great explained
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
thankyou for making this tutorial!
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.
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.
Man this is great !
very very helpful. thank you!!! 👍💚
How can I get that function Prediction box you have?
Hey please help me
I want a script to generate new invoice from invoice format saved in sheet1.
Also i want to rename next sheet name automatically.
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 )
Is there a way to have a data validation in a cell only if the previous cell fullfill certain set criteria or say data validation with 2 criteria (range and custom formula)
Thanks
When I try and run the script on "Sheet 2 " it keeps running the data into "Sheet 1" despite "Sheet 2" being the active sheet. My script matches yours exactly but I cant seem to get this to work. any suggestions?
P.s Thank you for the helpful content.
I'm going through the same problem and I don't know why
Same problem here. No idea why it's happening. I solved it by manually choosing the sheet I want to use function in
var activeSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet2");
@@marcinkroszel3533 It Worked, thanks mahn!
Excelente!!!!!!!
Is there any script that could help in highlighting the active row in google sheets? Please help!
Amazing content! Thanks for the video
Hi, I get error message "You don't have permission setValue()" bla bla... It was working before.
EDIT: Eh, now I see, i tried to run my function in the cell. You do it by pressing "Run" command.
thank you very much. you do a great job!
Thank you too!
When I click review permission, it says "Sign in with Google temporarily disabled for this app" even tho I'm using same gmail for app script and google sheet and google account. Anyone knows why?
Can you guide me how can I convert a google sheet one tab to convert to people chips
Thank you
Very good tutorial! Thank you!
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