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/
![[TH] VCT Masters Shanghai Playoffs - Grand Finals // GEN vs TH](http://i.ytimg.com/vi/HL-hhLrtctw/mqdefault.jpg)
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.
Absolutely the best teacher for novices in programming.
Great basic introduction, covered things that other "basic" tutorials failed to.
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!
Very clear video!
Thanks for taking time to explain deeply !
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!
I needed this so much. Thank you for doing this.
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...
Thanks for the video ! Very clear. You helped me write my first script ever.
Great Tutorial, you really helped me start using scripts in google spreadsheet.
Very easy to follow, step by step instructions. THX
Great teacher! This has helped me a ton. Keep the videos coming...
Great way of teaching. Great job. Please post more.
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.
This video was super helpful. Thanks for posting!!
Your videos are incredible! thank you!
Thank you for this video! Exactly what I wanted :)
The best programming videos, really thanks
hope you do some more on this (app scripts) as one, there isn't loads on TH-cam and two your content is really good 👍
bro.. u r the best teacher!!! pls i want more about programming
"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!
Love the way you teach keep it up
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!
👍
Excellent Man this is first time I m seeing this video tutorial its so amazing and easy to follow tutorial...God Bless You Brother !!...
Very good tutorial! Thank you!
Thank you for a detailed explanation
Thank you so MUCH! was great!
thank you very much bro. my works now need this app script. this basic really helped me. from Indonesia here.
this is really really really really great! thank you! you are the best! make more videos please!!!
Today I find something very interesting about google. This is something I want. :)
Awesome tutorial !
Mister, you are awesome, thanks for your videos!
Thankyou so much for this video. Its helps me alot.
Absolutely fantastic tutorials. The API guide was getting me nowhere. Thank you so much for creating these!
👍
Thank you so much! Excelent 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
It’s very useful for me . Thank you so much
Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)
Amazing content! Thanks for the video
Excellent tutorials
Great explained
Great as usual. Thanks
Awesome video tutorial. Very useful!
great!!!
very very helpful. thank you!!! 👍💚
thankyou for making this tutorial!
High quality stuff, thanks =)
Man this is great !
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.
Super tutorial, thanks
Awesome tutorial
Hi thanks for this serious stuff ! great !!!
well explained, awesome
Nice explaining man, thx u
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 :)
Beautiful!
Very fine. Thank you.
Great Vid! Thanks!
Excellent. You Deserved.
thank you very much. you do a great job!
Thank you too!
Excellent!
very helpful 🙂
Excellent info. I see it awesomely presented because it gave me a decent start. Thank you sir for your efforts.
Great to hear!
Thank you man
感謝製作此系列影片👍
👍
Thank you so much.
Excelente!!!!!!!
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
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 videos! I hope you will make a video using filter function in app script editor. (multiple values)
Thank you so fing much
Thank you
Thanks good sir!
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?
ThanQ alot 😁
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 )
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
It wont let me run, it says i need to review permissions, but when I sign in, it says "this app isn't verified"
Nice Video
thank you so much
thanks a lot!
Very useful
Glad to hear that
भारत से धन्यवाद!
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?
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
Love the vids, Keep it up! Subbed so fass. Hope you hit us with some google sheets and redash integration.
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: 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!
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)
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.
:)