00:00:00 Intro 00:02:30 Getting Started With Google Apps Script 00:09:40 What Can You Do With Google Apps Script 00:17:00 Writing first script 00:28:30 Google Workspace Services Examples 00:39:15 IDE Overview Apps Script Editor 00:41:05 New Project (not really) 00:51:17 Debugging 00:59:00 Autocomplete Apps Script Code 01:08:00 Menu LeftSide Nav Apps Script 01:24:05 Deploy Library Apps Script 01:37:40 App Script Web App Deploy 01:46:10 App Script IDE Features
@@LaurenceSvekisCourses I can see a lot of people watch your Apps Script tutorial, in fact it's the most watched video you have made. As a marketer, I recommend you make a comprehensive Apps Script tutorial for your potential and current audience with a title of "Complete App Script Tutorial for Everyone/Beginners/Advanced", and you can cut informative pieces of your video and make "Check Out My Full Tutorial" clips on all social media platforms. You will see the results. Good luck, you have already done a great job!
Hello, greetings. I'm looking for videos that explain how I can create a logging system, that is, I need that when a user with access to the spreadsheet as an editor makes some insertion, change or even deletes a cell from a specific range of a given tab, this information is written in another tab called: "Logs" where ifnrome the date and time of the event, the user's email and what the status of the action was, whether the content was deleted, inserted or changed. Is there any way you can help me with this?
Hi I haven't any experience in Web Development but i have a knowledge of VBA. Can i learn Google App Script. and how much time to learn Google App Script.
How to give Individual Worksheet View, Edit & download Access to Specific Email in one Google Sheet Workbook? For example: Sheet1 can be viewed, edited & downloaded by Mr. A only, Sheet2 can be viewed, edited & downloaded by Mr. B only, likewise
Do you have a video that will help show me how to run a script on 2 different files. I created one to gather data & update information and it works great in my test file but the real use is across 2 different spreadsheets and i can't seem to figure it out.
Hello Laurence, I am interested in your Google App Script trainings. But you have much app script lessons on udemy that i do not know with which to start. Can you please guide me. I should start with which one and continue with which? I have very very little knowledge on coding. Thanks
Hi, I have some doubts : Doubt 1 : Is there a way to add Google script to a Google Slide that contains the code that gets triggered everytime an event occurs like whenever a key is pressed ? Example 1 : Whenever the key Spacebar is pressed from the keyboard. Example 2 : whenever the key Next or Presvious is pressed from the keyboard. Doubt 2 : Can we write google script for a Google Slide that contains code that gets triggered everytime a new Slide get opened, or everytime a specific slide is opened ? Doubt 3 : Can we disable the keys for next or previous navigation in google slide when it is in present mode by running a Google script ? Doubt 4 : When we present a google slide then a small menu appears on the left bottom, which gives option to go to a spefoc slide or move to next or go to previous slide etc. Is it possible to hide that menu using google script ?
@@LaurenceSvekisCourses thanks for replying. So you're saying i can get blob of two pdf files then add it to another file? If yes please provide way to add blob of 2 files into one. Thanks
The only difference is the triggers on the bound scripts, and no access to the UI. You can setup time based triggers or other ways to run code in a standalone script.
@@LaurenceSvekisCourses I'm the owner of a s/sheet with some protected cells. I need to share this s/sheet with different users. I also need the user to run some script, which won't run - unless triggered by myself - because of the protected cells. However, if the script is run as me (owner of the s/sheet) then the script should run even when triggered by the user. I'm therefore exploring the opportunity to run the script as a web app, I'm still early stages though...
hello I don't understand the code at all, I asked gpt to make me some code and it is unable to correct it because it doesn't work, could I show you what it did to me
@@LaurenceSvekisCourses sir just one more doubt!! what if a person is not familiar with javascript? cause i am just 12 and dont know how to do java script.
I am trying to get a Change Date Script to work on all TABS inside the Same Main Google Sheet, so that when ever anyone Updates an Amount on my Inventory List it will automatically change the Date to the Current date in the "Date Adjusted" Column. How can I use the Same Script on all TABS in the Same Sheet? 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 == 'MASTERPG1') { var new_date = new Date(); spreadSheet.getActiveSheet().getRange(row,8).setValue(new_date).setNumberFormat("MM/dd/yy"); }
} But I have other TABS named "Desks", "Chairs", "Tables" etc How do I make this work on ALL The TABS?
The video is a merging of course lessons, the first 2 minutes is an introduction to the upcoming content. I don't know how to put times on the video sorry.
00:00:00 Intro
00:02:30 Getting Started With Google Apps Script
00:09:40 What Can You Do With Google Apps Script
00:17:00 Writing first script
00:28:30 Google Workspace Services Examples
00:39:15 IDE Overview Apps Script Editor
00:41:05 New Project (not really)
00:51:17 Debugging
00:59:00 Autocomplete Apps Script Code
01:08:00 Menu LeftSide Nav Apps Script
01:24:05 Deploy Library Apps Script
01:37:40 App Script Web App Deploy
01:46:10 App Script IDE Features
thank you :)
@@LaurenceSvekisCourses I can see a lot of people watch your Apps Script tutorial, in fact it's the most watched video you have made. As a marketer, I recommend you make a comprehensive Apps Script tutorial for your potential and current audience with a title of "Complete App Script Tutorial for Everyone/Beginners/Advanced", and you can cut informative pieces of your video and make "Check Out My Full Tutorial" clips on all social media platforms. You will see the results. Good luck, you have already done a great job!
Thank you!
these time stamps helped me alots, thanks mate
00:41:05 : he mentionsed that, it is a standalone project(new project)
Thanku Sir for creating these videos .I am learning through these.
Thank you for the tutorial. Very useful to have a general idea of what we can do with app scripts
Glad it was helpful!
this video is very helpful, thank you🙏🙏
Awesome content here, thank you! Very thorough. I'll be watching the whole series.
Thank you so much! It’s a well laid out & helpful tutorial.
Thank you for taking the course
Glad it was helpful!
Excellent. Lucid and professional. Thank you.
Thank you too!
Very thoroughly executed! Thank you.
Glad it was helpful!
Awesome content, greatly appreciated! Liked and subbed
Amazing class.
Thank you Laurence for sharing this. Very helpful tutorial. =)
Glad it was helpful!
Where’s the bit about getting input from a user and passing that into a function, such as the TH-cam search you did??
Yes you can use the TH-cam service to access youtube search
This is a very good tutorial! Thx
Thank you for taking the course
You're welcome!
Hello, greetings.
I'm looking for videos that explain how I can create a logging system, that is, I need that when a user with access to the spreadsheet as an editor makes some insertion, change or even deletes a cell from a specific range of a given tab, this information is written in another tab called: "Logs" where ifnrome the date and time of the event, the user's email and what the status of the action was, whether the content was deleted, inserted or changed.
Is there any way you can help me with this?
I got to this late but this is wonderful and giving me some great ideas for productivity in my small team
Glad it was helpful!
Hi I haven't any experience in Web Development but i have a knowledge of VBA. Can i learn Google App Script. and how much time to learn Google App Script.
Depends on if you have JavaScript experience you can get started quickly with it
Thank You Very Much
Thank you for taking the course
Glad it helped
hello, do you know api connector?
do you use AI for coding?
can I find "templates" ?
Thanks a lot
Most welcome
hello I thought that appscript is only used to connect an API to it? but in fact it's more than that?
Спасибо!
How to give Individual Worksheet View, Edit & download Access to Specific Email in one Google Sheet Workbook?
For example: Sheet1 can be viewed, edited & downloaded by Mr. A only,
Sheet2 can be viewed, edited & downloaded by Mr. B only, likewise
Do you have a video that will help show me how to run a script on 2 different files. I created one to gather data & update information and it works great in my test file but the real use is across 2 different spreadsheets and i can't seem to figure it out.
I continued watching & you explained it, guess I'll hold my comments until the end. 😂
Hello Laurence,
I am interested in your Google App Script trainings. But you have much app script lessons on udemy that i do not know with which to start.
Can you please guide me. I should start with which one and continue with which?
I have very very little knowledge on coding.
Thanks
how does the script reconnect the google form with the spreadsheet on the original sheet
Hi Laurence good day! It is posible to print a pdf file on google drive using apps script.
You mean to get a file and send it to print, thats a frontend function to send a document to print, can be done with a webapp
Hello, could you help me understand if my ideas are feasible?
I was wondering why you put const instead of var as variable type.
The newer version of Apps script uses ES6+ code so const and let allow for variable scoping. In general its best practice with JavaScript
Can U please provide the jdbc code to upload files from Google Drive to MySQL Database & then delete it from Google Drive???
Please refer to the source code at git
Perfect
Thanks for watching
ok
Hi,
I have some doubts :
Doubt 1 :
Is there a way to add Google script to a Google Slide that contains the code that gets triggered everytime an event occurs like whenever a key is pressed ?
Example 1 : Whenever the key Spacebar is pressed from the keyboard.
Example 2 : whenever the key Next or Presvious is pressed from the keyboard.
Doubt 2 :
Can we write google script for a Google Slide that contains code that gets triggered everytime a new Slide get opened, or everytime a specific slide is opened ?
Doubt 3 :
Can we disable the keys for next or previous navigation in google slide when it is in present mode by running a Google script ?
Doubt 4 :
When we present a google slide then a small menu appears on the left bottom, which gives option to go to a spefoc slide or move to next or go to previous slide etc.
Is it possible to hide that menu using google script ?
No reason to doubt all the code will work - please try the sample code at github
anyone know if you can put a Google app script on a private domain?
You can frame in apps script web apps,
Is merging two pdf files into one pdf file included in this video? If no can you provide a resource to do so?
No although you can do this as you convert them to blobs
@@LaurenceSvekisCourses thanks for replying. So you're saying i can get blob of two pdf files then add it to another file? If yes please provide way to add blob of 2 files into one.
Thanks
Is there a way to run a script living in a standalone file from a google sheet?
The only difference is the triggers on the bound scripts, and no access to the UI. You can setup time based triggers or other ways to run code in a standalone script.
@@LaurenceSvekisCourses I'm the owner of a s/sheet with some protected cells. I need to share this s/sheet with different users. I also need the user to run some script, which won't run - unless triggered by myself - because of the protected cells. However, if the script is run as me (owner of the s/sheet) then the script should run even when triggered by the user. I'm therefore exploring the opportunity to run the script as a web app, I'm still early stages though...
uh, sir i have a doubt, how did you connect docs and apps script together?
thats what apps script does using the id
@@LaurenceSvekisCourses thanks sir
hello I don't understand the code at all, I asked gpt to make me some code and it is unable to correct it because it doesn't work, could I show you what it did to me
Hello Coder, I want to learn Google Apps Script with you, what is the requirement?
Thanks for watching
Can i get id of any url through DriveApp script.
I have taken your paid course already
You can select the folder using a search then user getID() to get the id
Welp. Time to recreate tetris in google sheets.
I believe there is an example of Tetris in Google Sheets ;)
need the other half of the video!
I've uploaded all the videos in this series
How to fix Response Code: 413. Message: response too large
Please give me resolution
sir i am having an error which says 'TypeError: body.appendParaghaph is not a function'
you don't have the paragraph element selected as the object
@@LaurenceSvekisCourses sir just one more doubt!! what if a person is not familiar with javascript? cause i am just 12 and dont know how to do java script.
How to create libraries??
You can link to the code id
I am trying to get a Change Date Script to work on all TABS inside the Same Main Google Sheet, so that when ever anyone Updates an Amount on my Inventory List it will automatically change the Date to the Current date in the "Date Adjusted" Column. How can I use the Same Script on all TABS in the Same Sheet? 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 == 'MASTERPG1')
{
var new_date = new Date();
spreadSheet.getActiveSheet().getRange(row,8).setValue(new_date).setNumberFormat("MM/dd/yy");
}
}
But I have other TABS named "Desks", "Chairs", "Tables" etc How do I make this work on ALL The TABS?
You can add a trigger onChange() then check the active range match against the columns and rows you want to allow changes on.
Do you think you can send it to me the vid codeing
its on my website and at github basescripts.com
Thanks I can't find it though
17:08
Thanks for watching
this is not a course for a beginner, what is a method? what is a class? what is a property?
Its beginners to Apps Script which is based on JavaScript, prior coding experience with JavaScript is suggested
bro what's this language
Its based on JavaScript V8 engine some syntax with added Google Methods
To fast I’m doing, but not learning anything
Do you have prior coding experience, as Apps script is based on JavaScript so prior Javascript is helpful
Do you have prior coding experience, as Apps script is based on JavaScript so prior Javascript is helpful
37:00 (my pinned)
Looong overdue ide
Yes its a great improvement hopefully even more to come
Hello
Please improve your presentation for new learners. You seem to be talking to yourself.
Regards, Rajinder.
These are full courses, step by step to accomplish the objectives. There is a lot of work and time that I put into them.
The man goes on and on talking about nothing. Get to the point or put times in the video!
The video is a merging of course lessons, the first 2 minutes is an introduction to the upcoming content. I don't know how to put times on the video sorry.
Hi @@LaurenceSvekisCourses, they'll appear is the video timeline when you paste the time code and title in the description.
Great course btw 🙂.
Thank you for the tutorial. Very useful to have a general idea of what we can do with app scripts
Glad you liked it
This is a very good tutorial! Thx
Glad it was helpful!