App Script Editor Tutorial - Google Sheets - Excel VBA Equivalent - Read & Write to Ranges & Cells
Вставка
- Опубліковано 15 чер 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.
never in my life did I think I'd be "advanced" enough in coding to need to learn this.
Thank you for seeing the need and creating these tutorials.
Excellent.. playing at 1.25x speed works well
*2x lol
Great basic introduction, covered things that other "basic" tutorials failed to.
Absolutely the best teacher for novices in programming.
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 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!
Please do not change your way of teaching. Excellent video.
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 !
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 Tutorial, you really helped me start using scripts in google spreadsheet.
Thanks for the video ! Very clear. You helped me write my first script ever.
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 👍
Great teacher! This has helped me a ton. Keep the videos coming...
Thank you for this video! Exactly what I wanted :)
The best programming videos, really thanks
This video was super helpful. Thanks for posting!!
You teach very clearly and logically like Sal Khan of Khan Academy. Kudos!
Really great video - thank-you for taking the time to make it. Much appreciated.
Your videos are incredible! 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 :)
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.
Absolutely fantastic tutorials. The API guide was getting me nowhere. Thank you so much for creating these!
👍
Great way of teaching. Great job. Please post more.
Awesome instruction! Thank you. Perfect level of detail for my knowledge level.
Love the way you teach keep it up
Very easy to follow, step by step instructions. THX
bro.. u r the best teacher!!! pls i want more about programming
this is really really really really great! thank you! you are the best! make more videos please!!!
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 tutorial !
Today I find something very interesting about google. This is something I want. :)
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! You are a great teacher, Thanks!
Very good tutorial! 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 :)
Thank you so MUCH! was great!
Beautiful!
It’s very useful for me . Thank you so much
Mister, you are awesome, thanks for your videos!
Thank you so much! Excelent job!
Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)
great!!!
Great as usual. Thanks
Amazing content! Thanks for the video
Excellent tutorials
Awesome video tutorial. Very useful!
well explained, awesome
High quality stuff, thanks =)
Thank you for your sharing!
Thankyou so much for this video. Its helps me alot.
Awesome tutorial
Great Vid! Thanks!
Thank you for a detailed explanation
Super tutorial, thanks
Hi thanks for this serious stuff ! great !!!
Nice explaining man, thx u
Excellent info. I see it awesomely presented because it gave me a decent start. Thank you sir for your efforts.
Great to hear!
Excellent!
thankyou for making this tutorial!
Man this is great !
Great explained
very very helpful. thank you!!! 👍💚
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.
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
Excellent intro!
Very good videos! I hope you will make a video using filter function in app script editor. (multiple values)
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.
thank you very much. you do a great job!
Thank you too!
Very fine. Thank you.
Thank you so much.
感謝製作此系列影片👍
👍
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.
:)
Thank you man
very helpful 🙂
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 )
Excelente!!!!!!!
Thanks good sir!
Excellent. You Deserved.
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?
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
Thank you so fing much
Love the vids, Keep it up! Subbed so fass. Hope you hit us with some google sheets and redash integration.
thanks a lot!
Nice Video
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 so much
भारत से धन्यवाद!
Thank you
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
ThanQ alot 😁
Thank you! Any video on how to add something to the ACTIVE CELL?
Now that a version of TensorFlow available in JS , can it be used in Google Spreadsheets scripts?
How can I get that function Prediction box you have?