App Script Editor Tutorial - Google Sheets - Excel VBA Equivalent - Read & Write to Ranges & Cells
Vložit
- čas přidán 15. 06. 2017
- Video tutorial series about Apps Script (JavaScript) in Google Sheets (Excel VBA Equivalent).
In this tutorial we'll cover how to work with script editor, main spreadsheet app structure, how to write to a cell or a range & how to read information from a cell using Google Sheets Scripts.
Google Sheets
www.google.com/sheets/about/
Website:
www.chicagocomputerclasses.com/
Teaching everyone in a simple and understandable way is not that easy. You made it. Really really helpful. Thank you so much.
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.
Thank you for seeing the need and creating these tutorials.
never in my life did I think I'd be "advanced" enough in coding to need to learn this.
Great basic introduction, covered things that other "basic" tutorials failed to.
Absolutely the best teacher for novices in programming.
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!
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.
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!
Very clear video!
Thanks for taking time to explain deeply !
hope you do some more on this (app scripts) as one, there isn't loads on CZcams and two your content is really good 👍
Please do not change your way of teaching. Excellent video.
thank you so much for sharing this!, your tutorials are really helping me in my job...
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
Great teacher! This has helped me a ton. Keep the videos coming...
Great Tutorial, you really helped me start using scripts in google spreadsheet.
Thank you for this video! Exactly what I wanted :)
Thanks for the video ! Very clear. You helped me write my first script ever.
Excellent.. playing at 1.25x speed works well
*2x lol
This video was super helpful. Thanks for posting!!
Really great video - thank-you for taking the time to make it. Much appreciated.
Your videos are incredible! thank you!
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!
👍
Great way of teaching. Great job. Please post more.
The best programming videos, really thanks
Thank you so MUCH! was great!
Very easy to follow, step by step instructions. THX
this is really really really really great! thank you! you are the best! make more videos please!!!
Love the way you teach keep it up
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 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.
Very good tutorial! Thank you!
"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 :)
Awesome! You are a great teacher, Thanks!
You teach very clearly and logically like Sal Khan of Khan Academy. Kudos!
Excellent Man this is first time I m seeing this video tutorial its so amazing and easy to follow tutorial...God Bless You Brother !!...
Awesome instruction! Thank you. Perfect level of detail for my knowledge level.
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.
Awesome tutorial !
Today I find something very interesting about google. This is something I want. :)
Thank you very much . i have small problem and hope learn me how solve it
i want copy data from cell in sheet1 to another cell in sheet 2 (i make an invoice form )
bro.. u r the best teacher!!! pls i want more about programming
High quality stuff, thanks =)
Amazing content! Thanks for the video
Thank you so much! Excelent job!
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
Absolutely fantastic tutorials. The API guide was getting me nowhere. Thank you so much for creating these!
👍
Mister, you are awesome, thanks for your videos!
Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)
Hi thanks for this serious stuff ! great !!!
It wont let me run, it says i need to review permissions, but when I sign in, it says "this app isn't verified"
Thank you for your sharing!
thank you very much bro. my works now need this app script. this basic really helped me. from Indonesia here.
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?
Great as usual. Thanks
Very good videos! I hope you will make a video using filter function in app script editor. (multiple values)
Beautiful!
Awesome video tutorial. Very useful!
It’s very useful for me . Thank you so much
Man this is great !
Nice explaining man, thx u
Hello Teacher could you please make a video about how to measure time execution of an script and how to optimuze the script according to google limit ?thank you for all your videos are very usefull
Now that a version of TensorFlow available in JS , can it be used in Google Spreadsheets scripts?
very very helpful. thank you!!! 👍💚
Great Vid! Thanks!
感謝製作此系列影片👍
👍
well explained, awesome
Excellent tutorials
thankyou for making this tutorial!
Thankyou so much for this video. Its helps me alot.
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.
Thank you for a detailed explanation
Super tutorial, thanks
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!
Excellent info. I see it awesomely presented because it gave me a decent start. Thank you sir for your efforts.
Great to hear!
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
Awesome tutorial
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.
Love the vids, Keep it up! Subbed so fass. Hope you hit us with some google sheets and redash integration.
thank you very much. you do a great job!
Thank you too!
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)
How can I get that function Prediction box you have?
Great explained
Excellent intro!
Excellent!
great!!!
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.
:)
Very fine. Thank you.
Hi,
Thanks for such a wonderful video. Your videos actually focus on creating script to work with excel just like vba macro in excel. There are many tutorial but they try to teach other than using app script on google sheet. I have one question that is bothering me is that in your video when you type the name of the object and then when you type period you get proper list of methods available for that object and it is pretty explanatory but recently Google has changed the interface so when you type period the list displayed is very confusing so how to get the list in old fashion any idea ??
good question
There is an option of (use classic editor), click on that, to use the older version, it might help you to get the list in old fashion.
Thank you! Any video on how to add something to the ACTIVE CELL?
Thank you for uploading the tutorials. Can I get you in touch through Udemy or other online course platform. I am interested in learning Google API too. Thanks
Excelente!!!!!!!
Thank you so much.
Thank you man
Excellent. You Deserved.
Hi Nice videos its really very helpful for me... Can you put a video how to write a script to pull the records and copy it to the spreadsheet from bigquery?
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 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 )
very helpful 🙂