Introduction to Google Apps Script Triggers Google Developers English English (auto-generated)

Introduction to Google Apps Script TriggersYouTube↗ IA↗(long shot)
Science & Technology 78.2K views 481 likes 18 dislikes 04 Dec 2012

Google for Developers 2.7M subscribers United States YouTube↗

Click to Play Video

IKAI LAIN: Hi everybody, my name is Ikai Lain.

hi everybody my name is Kyle Ann and my

KALYAN REDDY: And my name is Kalyan Reddy.

name is Kelly unready and today we're

IKAI LAIN: And today, we're going to be talking about Apps

going to be talking about apps script

Script Triggers.

triggers so what are we gonna be doing

So what are we going to be doing today? We're going to be doing a full-on, I want to call it a

today we're gonna be doing a full on I

show about Apps Script Triggers.

want to call it's a show about app

Where we're going to start talking about first, what they

script triggers where we're gonna start

are, where you'd want to use them, ways to run them, and

talking about first what they are where you'd want to use them ways to run them

we're going to move into a little bit of code.

and we're gonna move into a little bit

I'm not going to type too much code out, but I've been

of code I'm not going to type too much

preparing some samples for you guys.

code out but I've been preparing some

And towards the end, we're going to talk about patterns

samples for you guys and towards the end

and things you can and can't do using triggers.

we're gonna talk about patterns and things you can and can't do using

So that's what we've got today for you guys.

triggers so that's what we've got today

Oh, I have this thing in presentation mode.

for you guys oh I have this thing in

So let's go ahead and get started.

presentation mode so um let's go ahead

KALYAN REDDY: Sounds good.

and get started

IKAI LAIN: And Kalyan's going to be the guy who's going to

sounds good and columns gonna be he's

be asking questions, who's making sure I

gonna be the guy who's gonna be asking questions and just making sure to I

don't go too fast.

don't go too fast gonna paste me he's

He's going to pace me. He's going to help me out. So first off, what are triggers?

gonna help me out okay so first off what

Triggers are a way for us to run code either in response to

are triggers triggers are a way for us to run code either in response to an

an event or non-interactively.

event or non interactively when I say

When I say interactive, what I mean is you've got the script

non interactively when I say interactive what I mean is you've got you've got the

editor, where you can hit play.

script editor we can hit play you can

You can also run a script as a result of something going on

also run a script as a result of

something going on in a script you can

You can have it attach a menu item.

have it attach a menu item or you can

Or you can invoke some code via a web application.

invoke some code via a web application

So that's what I mean when I see interactive, as in,

so that's what I mean why is the

there's a user that goes in and clicks some action or

interactive as in there's a user that goes in and click some action or take

takes some action that causes some code to run.

some action that causes some code to run

And this is one of the most common uses of Apps Script,

and this is one of the most common uses

because you want these to be doing something before the

of Apps Script is that you want to use to be doing something before the app

Apps Script fires.

script fires now you want to use

Now, you want to use triggers because there are lots of

triggers because you want to be able to

cases where you want to run code and not have the user

there are lots of cases where you want to run code and not have the user

necessarily do something.

necessarily do something so a really

So a really good example would be a clock-based trigger.

good example would be a clock based

So let's say that you want it to run some code.

trigger so let's say that you wanted to

You want it to run a scheduled job every day at midnight or

run some code you want to run a scheduled job every day at midnight or

1:00 AM or at every day at noon.

1:00 a.m. or every day at noon let's say

Let's say every day at noon, I wanted to email everyone and

every day at noon I wanted to email

say, hey, go to lunch.

everyone and say hey go to lunch right

That's something you can do with a trigger.

that's something you could do with

Or if you want to set something up to run at a

trigger or if you want to set something

certain date or time, that's something you can do via what

up to run in a certain date or time that's something you can do via what we

we call clock triggers.

call clock triggers the second type of

The second type of triggers are something that we call

triggers are something that we call

spreadsheet triggers.

spreadsheet triggers so we have these

So we have these, they're called onInstall, onOpen,

they're called uninstall on open on edit

onEdit, and on form submit.

And I will talk about these later.

and we'll talk about these later but

But what these allow you to do is to wire up code so that

what these allow you to do is to wire up

when something happens inside a spreadsheet

code so that when something happens inside spreadsheet the code gets

the code gets executed.

executed so this is a very powerful

So this is a very powerful technique and you can build

technique and you can build some really

some really interesting applications using some

interesting application using some

off-the-shelf components, like spreadsheets for UI or forms

off-the-shelf components like spreadsheets for UI or forms for

for collecting user data.

collecting user data and you can wire

And you can widely scale using triggers so that you can build

these together using triggers so that

something that's a full-fledged application.

you can build something that's that's a

So a really good example of something that we've done like

full-fledged application so a really good example of something that we've

this would be something like a help desk application.

done like this would be something like a

Or for those of you who have been to our Apps Script events

help desk application or for those you that have been to our Apps Script events

before, you've seen our signup sheets, that's

before you you've seen our sign-up

just a Google form.

sheets that's just the Google form and

But you're able to get a confirmation email.

but you're able to get a confirmation

We also do some logic in the back end to send out reminder

email we'd also do some logic in the

emails as well as tell you if you're on the waitlist or not.

backend to send out reminder emails as well as tell you if you're on the wait

That's all done via Apps Script,

list or not that's all done via Apps

spreadsheets, and forms.

Script spreadsheets and forms so if

KALYAN REDDY: So if you're familiar with the Unix world,

you're familiar with the UNIX world then

then the cloud based triggers are like a cron job, where you

the cloud-based readers are kind of like

can have a script executed at a certain time.

a cron job where you can have a script

IKAI LAIN: That's right.

executes at a certain time that's right

And do you have a Unix analogy for spreadsheets? KALYAN REDDY: Not so much.

and you have a UNIX analogy for spreadsheets not so much just like bring

IKAI LAIN: Just like bringing you into my trap here.

you into my trap here so why don't we go

So why don't we go ahead and show you guys how to set up

ahead and show you guys how to set up

some of these triggers.

some of these triggers let's go ahead

Let's go ahead and go to Script Editor right now.

and go to script editor right now so

So I've written some code here.

I've written some code here this is Kali

This is Kalyan.

and his email is GK at google.com

His email is [email protected].

everybody knows this he's very popular

Everybody knows this. He's very popular around here. And what I want to do is I want to really bother him.

around here and what I want to do is I

want to really bother him right I just want to tell this guy that he's ooh

I want to tell this guy that, hey, you're such a cool guy.

I want to tell this guy that you know hey you're such a cool guy right I want

I want to tell this guy every day.

to live every day I want to tell them

KALYAN REDDY: Everybody wants to tell me that. IKAI LAIN: I want to tell him every five minutes.

every five minutes so I've written this

So I've written this function, and as you can see, I'm just

function and as you can see I'm just

using standard Mail App.

using a standard mail app so a mail app

So in Mail App you have a recipient, a subject, and a

you have a recipient a subject and a

body of the email.

body of the email so I want to email you

So I want to email you every five minutes, because I want

every five minutes because you know I

you to have high self esteem.

want you to have high self esteem

So let's go ahead and figure out how we can do that.

so let's go ahead and figure out how we

Well, when you're in the Script Editor-- and this is

can do that well when you're in the

script.google.com--

script editor and this is

you click on Resources, Current Script Triggers.

script.google.com you click on resources current script triggers and you'll see

And you'll see that right now, I have no triggers set up.

that right now I have no triggers set up

And that's because I don't have any code yet.

and that's because you know I don't have any I don't have any code yet right I

I haven't set this up yet.

haven't set this up yet I do have code

I do have code, excuse me.

excuse me I'll click on no trigger setup

I'll click on No Trigger Setup.

and which one of these do I want to

And which one of these do I want to select? I want to select email gkal.

select I want to select email G cow

Now one thing you might notice is that I've got a few other

one thing you might notice is that I've

functions in here.

got a feel of functions in here that's

That's because I wanted to go a little bit off topic.

because I want to go a little bit off

We're going to talk about public and private functions.

topic a little bit talk about public and

This is something that's really useful to know.

private functions this is something that's really useful to know you'll see

You'll see that I have a function here called Public

that I have a function here called

and Private function.

public and private function private

Private functions are functions that end with an

functions are functions to end with an

underscore when you have a function ends

When you have a function that ends with an underscore,

with an underscore you're telling a

you're telling Apps Script that this is just for me.

prett that this is just for me I don't

I don't ever want to be able to run this code.

ever want to be able to run this code so

So when you click the drop down for running, you'll see

when you click the drop down for running

that private function is not there and public function is.

you'll see that private function is not there and public function is and the

And the difference is an underscore between the

difference is an underscore between the

function name and the parentheses.

function name and the enter parenthesis

So that's one of the requirements of writing code

so that's one of the requirements of

that you want to execute a trigger, is

writing code that you want to execute

that it must be public.

inside a trigger is that it must be

You can't have an underscore at the end of

public you can't have an underscore in

the function name.

name at the end of function name so

So again, let's go back to current project triggers and

again let's go back to current project

triggers and set one up now I'm gonna

Now, I'm going to pick the function I want.

pick the function I want and again

And again, that's email gkal.

that's email G Cal and I've got a couple

And I've got a couple of options. But right now, since this script is not bound to a

of options but right now since I am this

spreadsheet, that is, I didn't go to the spreadsheets editor

script is not bound to a spreadsheet that is I didn't go to the spreadsheets

and click Tools, Script Editor.

editor and click tools script editor

I just went to script.google.com and started

I just went to script but Google comm

furiously hacking away.

and started furiously hacking away the

The only option I have is time-driven.

only option I have is time driven and

And the next option I want to pick is what kind of

the next option I want to pick is what kind of time driven River what kind of

time-driven trigger is this?

time driven trigger is this first off I

First off, I can pick a specific date and time.

can pick a specific date and time right

So you'll see that I want to enter a year,

so you'll see that I want to enter a year date year month date at a time so

month, date, and a time. So what's a good day to remind you that

what's a good day to remind you that

you're such a cool guy?

you're such a cool guy well right now no

KALYAN REDDY: Right now. IKAI LAIN: No, I don't think you deserve it yet.

I don't think you deserve it yet how

How about on the 25th of December?

about how about on the 25th of December

I mean, you're getting presents.

right I mean you're getting some you're

You're having a day off, drinking some eggnog.

getting presents you know you're having the day off drinking some eggnog so

So let's remind you at 3:00 AM.

let's remind you at 3:00 a.m. and you'll

And you'll see that the field turns white, because now this

see that the field turns white because

is a valid time.

now this is a valid time and I can save

And I can save this thing.

this thing and that's when it'll email

And that's when it will email him.

him up it's gonna ask me for

It's going to ask me for authorization.

authorization so I'm go ahead and

So I'm going to go ahead and authorize.

authorize you guys are all familiar with

You guys are all familiar with this screen.

the screen closed and now I'm gonna save

Close. And now, I'm going to save the trigger.

the trigger remember you must pass the

Remember, you must pass authorization and

authorization and then save it again

then save it again.

it's like the same way when you're

It's like the same way when you're running a script.

running it when you're running a script

You have to authorize and rerun the thing.

you have to authorize and rerun the

So now, if I go to current script triggers, I'll see

thing so now if I go to current script

that, oh, there's an email set up to go out to you.

triggers I'll see that oh there is there's an email set up to go out to you

And it's going to execute this code on December 25.

and gonna execute this code on December 25th

KALYAN REDDY: So it's just going to execute it the one

so it's just gonna execute it the one

time on that date, and that's it.

time on that date let's raise it that's

IKAI LAIN: Right. That's right.

right and you know you sounded

And you sounded disappointed there.

disappointed there so why don't we

So why don't we increase the frequency?

increase the frequency when you create

When you create triggers, you can create many, many triggers

triggers you can create many many

to fire on a single function.

triggers to fire on a single function so

So I'm going to add a new trigger, email gkal.

I'm gonna add a new trigger email G Cal

And I'm going to make it time-driven.

and I'm gonna make a time driven and I

And I want this thing to run every hour.

want this thing to run every hour yeah I

I don't think you deserve that.

don't think you deserve that let's save

Let's set it to every two hours.

to every two hours right so I'm gonna

So I'm going to set it to every two hours.

set it to every two hours I'm gonna hit

I'm going to hit Save.

save and that's gonna start that's gonna

And that's going to start emailing you every two hours.

start emailing you every two hours it's

It's going to execute this code.

gonna execute this code so you can in

So in this type of trigger, you can put almost any kind of

this type of trigger you can put almost

code in here that Apps Script supports.

any kind of code in here that that Apps

I'm using a very simple example to email you.

Script supports so I'm using a very simple example to email you but I could

But I could also edit a spreadsheet.

also edit a spreadsheet right so I can

So I can keep a log of all the times I've emailed you.

keep a log of all the times I've emailed

I can also keep a Google Drive document.

you I can also keep a Google Drive document I can do a lot of things I can

I can do a lot of different things. I can insert a row into a database via

insert a row into a database via cloud

Cloud SQL and JBC.

sequel and JDBC I just anything you can

Anything you can do inside an Apps Script, you can basically

do inside an Apps Script you can

do inside a trigger.

basically do inside a trigger I mean

I mean, obviously, you can't render a UI.

obviously you can't render a UI but that

But that would be silly, wouldn't it?

would be silly wouldn't it it's because

KALYAN REDDY: Because there's no particular use--

there's there's no producer you look at

IKAI LAIN: Who's going to look at?

who's gonna look at anyone right the

Who's going to look at it, right? If a tree falls in an empty forest, I don't know the rest

tree falls in an empty forest I don't

of how that goes.

know the rest of how that goes

Not very philosophical.

not very philosophical so that's how you

So that's how you manually set up a trigger.

manually set up a trigger so but

But sometimes you want to be able to set up a trigger and

sometimes you want to be able to set up

you want to be able to do it so that you can program, and

a trigger and you want to be able to do it so that you can program and you could

you can program a trigger in. For instance, let me show you guys how this should be done.

program a trigger in so for instance let

So let me go ahead and--

me show you guys how this would be done

so let me go ahead and excuse me let me

excuse me. Let me go ahead and do this in code.

go ahead and and do this in code so I'm

So I'm going to create a new function.

gonna create a new function I'm gonna

I'm going to call it scheduleTrigger.

call it schedule trigger

Now what I'm going to do is I'm going to use a trigger

right now what I'm gonna do is I'm gonna

builder to build something that will also schedule

use a trigger builder to build something

something that'll email you every minute.

that'll also schedule something they'll email you every how about every minute

How does that sound?

how does that sound that's how much

KALYAN REDDY: That sounds much better.

better let's go ahead and do this then

IKAI LAIN: Let's go ahead and do this then. So let's say var builder equals ScriptApp.newtrigger.

so let's save our builder equals script app dot new trigger and the first

And the first parameter of new trigger is the function that

parameter of new trigger is the function

you want this trigger to call.

that you want this trigger to call so

So the function I want this to call is email gkal. This must match the case.

the function I want this to call is email G Cal this must match much match the case you know everything in

Everything in Apps Script is case sensitive when you're

JavaScript is everything in Apps Script is case sensitive when you're writing

writing code. So remember that if something is uppercase, you have to

code so remember that if something is

match [INAUDIBLE].

uppercase you have to match a gene if

If something's lowercase, you have to match it.

something's lowercase you have to match

So we're going to chain this.

it so the next we're gonna chain this

And we're going to say, let's make this

and we're gonna say let's make this a

a time-based trigger.

time-based trigger right so I'm gonna

So I'm going to make it time-based.

make it time-based let's set this again

Let's set this. Again, I'm hitting period every time.

I'm hitting period every time and Apps

And Apps Script Editor is smart enough to know, hey,

Script editor is smart enough to know

this is a clock trigger builder time.

hey this is a clock trick bit clock trigger builder tied try saying that 10

Try saying that 10 times fast. And it'll pop up the functions I need to build this trigger.

times fast and it'll it'll pop up the functions I need to build this trigger

So when I say, dot, I want this to be every.

so when I say dot I want this to be

And you can see that as I type, it filters down the

every and you can see that as I type it

function that match every minute.

filters down the functions that match

So let's make this every one minute.

every minute so let's make this every

And let's go ahead.

one minute and let's go ahead and and

that's it so that's the trigger so far

So that's the trigger so far. And when you have a builder, you go ahead and do

and when you have a builder you go ahead

builder.creates.

and you do builder dot create and this

And this returns a trigger instance.

returns a trigger this returns a trigger

But you don't have to necessarily do

instance but you don't have to

anything with a trigger.

necessarily do anything with a trigger

You don't have to return it.

you don't have to return it you could

You can just say builder.create.

just say builder dot create in fact a

In fact, a lot of people, what they do is at the end of this

lot of people what they do is at the end

call, they'll simply say dot create and it

of this call they'll simply say dot

will return a builder.

create anyone we've returned a builder

So a very common thing I've seen people do, is to do dot

so a very common thing I've seen people

create, and that's the end of it.

do is Sadu create and that's the end of

But I want to show you guys that you can use a builder,

it but I want to show you guys that you can

because builders are very, very powerful.

use a builder because builders are very

Builders are a pattern that come from Java.

very powerful builders our pattern that come from they come from Java they come

They come from Java land and they are best described in

from Java land and they're best

this one book called, "Effective

described in this one book called

Java," by Joshua Bloch.

effective Java by Joshua block the nice

The nice thing about builders is that they allow you to

thing about builders is that they allow

programmatically slowly construct a complex object.

you to programmatically slowly construct the complex object

And this was intentionally built.

and and this was intentionally built

This pattern exists to solve the problem of Java not having

this pattern exists to solve the problem of Java having lots of not having name

named parameters.

parameters so in some programming

So in some programming languages, like Python, you

language just like Python you can call a

can call a function.

function and you call name parameter

And then you call a name parameter. You could say name is equal to ABC, value is equal to 123.

right you could say name is equal to ABC VAR value is equal to 1 2 3 but you

But you can't do that in Java.

can't do that in Java so they created

They created this builder pattern where what each of

this builder pattern where what each of

these functions returns is the builder object.

these functions returns is the Builder

So the trigger hasn't been created yet.

object so the trigger hasn't been

You return an instance of a builder and when you're done

created yet you return an instance of

with the builder you call builder.create to essentially,

the builder and when you're done with the builder you call builder create to

finalize the object.

essentially finalize the object so why

So why is this nice? Well, let's say that we want to make it time-based, but we

is this nice well let's say that we want to make a time-based right but we didn't

want to make it every few minutes but we didn't know how

want but we want to make it every few

many minutes we want the interval to be, well, we could

minutes and we didn't know how many minutes we want interval to be well we

have a conditional that says, if some conditional builder dot every one minute.

could have a conditional that says if some conditional builder dot every 1

And if there's a different conditional I could say,

minute and if there's a different conditional I could say bill there

builder dot every five minutes.

thought every 5 minutes so you can hook

KALYAN REDDY: So you could hook this up as a response to

this up but as a response to external

external conditions, as well.

conditions as well like you can pull

You can pull data from an external source and change you

data absolutely source and change their

trigger timers based on that.

trigger timers based on that right

IKAI LAIN: Right, absolutely. So you can do that with triggers.

absolutely so you can you can do that

Is very, very cool.

with triggers it's very very cool and

And that's typically, what's used to build a pattern for

that's that's typically what you use to

because a lot of times you'll have a lot of different

build a pattern for because a lot of times you'll have a lot of different

conditionals, and instead of writing this out every time,

conditionals and instead of writing this

you'll simply modify the builder in the way that you

out every time you'll simply modify the builder in the way that you need it to

need it to change based on the current condition you're

change based on the current condition

you're evaluating I know it seems

I know it seems confusing.

confusing so just take a look at what

So just take a look at what I've done with the code here,

I've done with the code here and you'll

and you'll see what I'm doing here.

see what I'm doing here now obviously

Now, obviously, this is always going to set to every minute.

this is always gonna set every minute

And that's because I'm doing an if true.

and and that's because you know I'm

So let's go ahead and remove that, because

doing an if true so let's go ahead and

that's kind of silly.

remove that because that's kind of silly

So let's go ahead and select this.

so let's go ahead so like this I'm gonna

I'm going to save this.

save this and now you'll see that you

And now you'll see that, once the code finishes saving, I'm

know once the code finishes saving

going to do a drop down.

I'm gonna do a drop down and I'm gonna

And I'm going to pick schedule trigger.

pick schedule trigger and I'm gonna run

I'm going to run this function.

this I'm gonna run this function again

Again, I'm not running the email gkal function.

I'm not running the email decal function

I'm running the schedule trigger function.

I'm running the schedule trigger

So I'm going to go ahead and click Run.

function so I'm gonna go ahead and click play run it's gonna ask me for

It's going to ask me for permission. I'm going to authorize it.

permission I'm gonna authorize it close

Close it. Now again, I haven't run this.

it now again I haven't run this and I

I haven't actually scheduled the trigger yet.

just scheduled a trigger yet so this is

So this is going to create a trigger that

going to create a trigger it runs every

runs every one minute. So when I go to Resources, Current Script Trigger, I'll

so when I go to resources current script

see that, OK, I have the triggers I created before.

trigger I'll see that okay I have the

Let's go ahead and delete these for clarification.

triggers I created before let's go ahead and delete these for clarification so

So you see that there are no triggers set up, right?

you see that there no trigger setup

KALYAN REDDY: So all you've done so far is authorize it?

right I'm gonna all we've done so far is

IKAI LAIN: That's right.

authorize it that's right thank you for

Thank you for the clarification.

thank you for the clarification someone

So I'm going to click Run.

click run it's gonna run schedule

It's going to run schedule trigger. And when I look in Resources, Current Script Triggers, boom,

trigger and when I look in resources current script triggers boom

you'll see that I've

you'll see that I've programmatically

programmatically created a trigger.

created a trigger and this is this is a

And this is a very nice feature, because sometimes you

very nice feature because sometimes you

might want to create a trigger based on what someone is doing

might want to create a trigger based on

in a web app, what's happening in a spreadsheet.

what someone is doing in a web app with some what's happening a spreadsheet so

So you want lots of options.

you want to be you want lots of options

And being able to programmatically schedule

and being able to programmatically

triggers is really nice because,

schedule triggers is really nice because

yeah, you have options.

yeah you you have options and you can

And you can be very flexible in scheduling when you want

you can be very flexible and scheduling

when you want code to run so let's say

So let's talk about how we can use this in practice.

let's talk about how how we can use this

So here, I've set up a demo spreadsheet.

in practice right so here i've i'm i've set up a demo spreadsheet right and this

And we call this fundraising.

is we call this fundraising so this is

So this is just a basic Google spreadsheet.

just a basic Google spreadsheet I've got

I've got two tabs, one for

two tabs one for fundraising one for

fundraising, one for donations.

donations and we have a name and a funds

And we have a name and a funds raised.

racism again it's a very very simple

Again, this is a very, very simple spreadsheet.

I'm dynamically generating a chart from this data.

I'm dynamically generating a chart from

So right now, I have Arun as a slacker.

this data so right now I have a roon as

He's only raised $20.

a slacker you know he's only raised $20

He's a busy guy, right?

he's a busy guy right so let's go ahead

So let's go ahead, and let's say that he's raised $20,000.

and let's say that he's raised $20,000

Well, he's totally blown up the chart now.

well he's totally blown up the chart now

So let's go ahead and lower that scale a little bit.

so let's go ahead and lower this a

KALYAN REDDY: It's a good month for Arun.

little bit the good non-firm he's back

IKAI LAIN: He's back down to $40.

up teas back down to $40 you know it's a

That's a 100% increase in the funds that he's raised.

100% increase in his the funds that he's

So charts a really cool because you can just make

raised so charts are really cool because

changes, and the chart will automatically update.

you can just make changes and the chart

So let's say that with this chart we want to send out a

will automatically update so let's say that you know with this chart we want to

nightly notification with the latest chart that says, hey,

send out a nightly notification that that with the latest chart that says hey

here's the latest status on fundraising.

you know like here's the latest status

Well, how do we do that?

on fundraising well how do we do that we

We do that with triggers.

do that with triggers so inside the

So inside the spreadsheet, I'm going to go ahead and click

spreadsheet I'm gonna go ahead and click

Tools, like so.

tools like so I'm gonna script editor

I'm going to go to Script Editor. And this is going to open up the editor.

and this is gonna open up the editor

Oh, the reason it's doing this is because I had

it's not gonna do it that fellow well the reason it's doing this is because I

the tab open already.

had to tab open already so it's just

So it's just refreshing the tab.

refreshing the tab so this is the script

So this is the script that I have attached to the

that I have attached to the spreadsheet

alright so I've written a funk

So I've written a function that emails that email as a report to myself.

that emails that email as a report to to

This is my test account.

myself this is my test account so you

So [email protected].

know eek I doubt Lana not test at

Please don't ever email me at that email.

gmail.com please don't ever email me at

I will never see it.

that email I'll never see it so let's

So let's walk through this code real quick.

walk through this code real quick first

First off, if you've ever written code to attach a

off if you've ever written code to

spreadsheet before, you recognize this.

attach the spreadsheet before you

You want to get the active spreadsheet.

recognize this you want to get the

And we're storing in a variable, SS.

active spreadsheet and we're storing in

We're going to get the sheet by name.

a variable SS we even get the sheet by

The sheet's name is fundraising.

name the sheets name is fundraising

Because if you remember, it's down here in the lower

because if you remember it's down here

left-hand corner.

in the lower left hand corner you see a

You see a name on the tabs.

name the tabs right and the tab here is

And the tab here is fundraising.

So we're going to get all the charts for your sheet.

so we're gonna get all the charts for

And we'll say, sheet.getCharts.

sheet and we'll say she thought get

We really only want the first one, because there's only one.

charts we really only want the first one

But when you say, get charts, you can only

because there's only one but when you say get charts you can only return all

return all the charts.

the charts like right now there is in

Right now, there is no way to just return

the way just return one particular chart

one particular chart. So we're going to go ahead and create the email template.

nice so we're gonna go ahead and create the email template I'm doing something

I'm taking advantage of HTML template to render an HTML

that's uh I'm taking advantage of HTML template to render an HTML email

email template.

template a lot of times I see people

A lot of times I see people, they're doing this in code.

they're doing this in code they're

They're writing the template out in the script editor.

writing the template out in the script

Or they're using a spreadsheet cell as the email template.

editor or they're using a spreadsheet cell as an email template and they're

There are advantages and disadvantages.

all they all advantages of disadvantages

I personally like to use a template, because it lets me

I personally like to use a template

separate the view from the code.

because it let me separate the view from

So right here, you'll see I'm using htmlService.crea

the code so like right here you'll see

tetemplatefromfi le("reportTemplate").

I'm using HTML service dot create

template from file report template and

And if you've ever written any kind of HTML service apps

I'm doing this and if you've ever written any kind of HTML service apps

before, this should look familiar.

before this should look familiar because

Because once I go to report template, you'll see, hey,

once I go to report template you'll see

it's just an HTML page. Big H1 title, Daily Fundraising Report.

hey it's just an HTML page big h1 title daily fundraiser report this is an HTML

This is an HTML service standard where I

service standard where I can inject the

can inject a variable.

variable and the variable I'm injecting

And the variable I'm injecting here is the date variable.

here is the date variable I'm using the

I'm using the question mark equals notation to say,

question mark equals notation to say

whatever the string value of data is, inject it here.

whatever the string value of data is inject it here I'm doing something here

I'm doing something here, it's a little bit outside the

it's a little bit outside of script with

script apps we've talked about this.

Apps Script talked about this but I feel

But I feel like it's worth talking about.

like it's worth talking about it's um

Inside an email you can have inline images.

inside an email you can have inline

And there are a couple of different ways of doing it.

images and there are a couple of

One of the ways is using an image source tag, and just

different ways of doing it one of the ways is using an image source tag and

using an image that's hosted on whatever CDN or whatever

just using an image to host it on whatever CDN or whatever assets server

asset server that you have. And when you do this, the benefits are that you kind of

that you have and when you do this the

get to count how often people get to view the images.

benefits are that you kind of get the count how often people get to view the

Now, the disadvantage of doing things this way are that when

images now that this advantage is doing things this way are that when you

you send an email to someone in Gmail or in some email

an email to someone in Gmail or in some

clients, they don't display these images by default, and

email clients they don't display these

for good reason.

images by default and for good reason

Because when you request an image from an image asset

because when you request an image from

server, your IP address is logged.

an image asset server your IP address is logged right your the it's good for them

It's good for them, because you get analytics about who's

because you could analytics about who's

seeing the email.

seen email but not everyone displays

But not everyone displays images.

images so their benefits is using an

So there are benefits of using an inline image.

inline image because once you use an

Because once you use an inline image, even though you don't

inline image even though you don't get

get the analytics, people will always see the image.

the analytics people will always see the

So here, the format is cid colon and

image so here the format is to see ID

the name of the image.

colon and the name of the image and

And we'll get to what it means to have a name of an image.

we'll get to what it means seven name of

So back in code.gs, the next line, I'm going to set the

an image so back in code GS the next

line I'm gonna set the date variable

Again, I'm just using utilities.formatDate are to

again I'm just using utilities that

show I only care about month, day, and year.

format date to show I only care about month day and year I'm gonna use mail

I'm going to use MailApp.sendemail.

app dot send email this is very familiar

This is very familiar, because this is just something we've

because this is just something we've

taken out of the tutorial.

taken out of the tutorial I I'm sending

I am sending it to myself.

it to myself I'm sending the title to

I'm sending the title to Daily Fundraising Report.

daily fundraise and report I'm not

I'm not sending a text body.

setting a text body you can and should

You can and should, because not all email clients will

because not all email clients will

render HTML. So we're going to use the last parameter to

render HTML so we're gonna use the last

pass an HTML body.

parameter to pass an HTML body and

And you'll notice that I'm using template.evaluate.

you'll notice I'm using templates not

But I'm doing one more thing.

evaluate I'm doing one more thing I'm

I'm doing .getContent.

doing dot get content you know typically

You don't typically need to do .getContent when you're doing

need to do got dot get content when

an HTML service.

you're do an HTML service but we're

But we're forcing it to render the template as a string,

forcing it to render the template as a

because HTML body takes a string.

string because HTML body takes a string

So we take template.evaluate.getContent,

so we can take template dot evaluate get

turn it into a string, pass it into HTML body parameter.

content turn it into a string passing th mobile HTML body parameter there's

There's another parameter called inline images, which

another parameter called inline images

takes in a JavaScript map.

which takes in a JavaScript map and this

And this is where we had the word chart.

is where we had the word chart oops

Oops, excuse me. And chart here is we're using this again in report template.

excuse me and chart here is we're using

So if I want to name this Chart Fundraising, for this to

this again in report template so if I want to name this chart fund-raising for

work correctly, I would need to save that, come back to

this to work correctly I would need to

code, and name this the chart_fundraising.

save that come back to code name is a chart underscore fundraising and for

And for this, I'm using charts.

this I'm using charts I'm using 0

I'm using 0, because that's the first chart.

because that's the first chart there's

There's only one chart.

only one chart I'm doing dot get blob

And I'm doing .getblog.

and my name it just takes a blob and

Inline images takes a blog.

that's because earlier you got all

KALYAN REDDY: And that's because earlier, you got all charts.

charts that's right and now we were

And now you're referencing the first chart.

referencing the first chart earlier up

IKAI LAIN: Earlier, up here, I'm seeing var charts equals

here I'm seeing bar charts ego sheet get

sheet.getCharts, So I could just as easily say, var chart

charts so I could just as easily save

equals sheet.getCharts, and then just return the first

our chart equals she thought get charts

index, like so.

and then just return to first index like

But it was an arbitrary decision on my part.

so but it was an arbitrary decision on

So I'm going to go ahead and run this function now.

my part so I'm gonna go ahead and run

this function now uh Act I'm gonna go

Let me go ahead and run this email report.

ahead and run this email report I could

I could run this.

run this but I'm actually not going to

But I'm actually not going to.

excuse me I'm gonna go ahead and

Excuse me. I'm going to go ahead and schedule a trigger.

schedule a trigger and it's I have this

And I have this set right now so it emails every

set right now so it emails every night

night at 3:00 AM.

at 3:00 a.m. and again I did this by

And again, I did this by clicking Add a new trigger,

clicking add a new trigger select an

selecting Email report, Time-driven.

email report time-driven

And you'll see that because I'm actually attached to a

and you'll see that because I'm actually

spreadsheet now, I have the From

attached to a spreadsheet now I have the

spreadsheet option as well.

from spreadsheet option as well you're

You're seeing up here, I have an On form submit handler.

seeing up here I have an on form submit

We'll get to that real soon, but not yet.

handler we'll get to that real soon but

I want this run every day, 3:00 AM to 4:00 AM.

not yet I want this run every day 3 a.m.

So let's save this bad boy.

to 4 a.m. so let's save this bad boy and

And what does this look like?

what does this look like well we can

Well, we can wait for it.

wait for it or I can just show you guys

Or I can just show you guys.

so I'll just show you guys this is my

So I'll just show you guys. This is my test email account.

test email account when you click on

When I click on Daily Fundraising Report-- this is

daily fundraising port this is from

from yesterday-- you'll see, hey, Arun's raised $20.

yesterday you'll see hey you know arune's raise $20.00 Eric's raised a lot

Eric's raised a lot of money. That guy's a go-getter.

of money that guy's a go-getter and

And that's how you schedule a nightly report using Apps

that's how you schedule a nightly report

Script and spreadsheets.

using Apps Script and spreadsheets

KALYAN REDDY: Oh, very cool. And then every time the data modifies, the next time the

oh very cool and then every time the

trigger runs, it'll be a new chart.

data modify the next time the trigger runs it'll be a new chart that's right

IKAI LAIN: That's right. That's a very good point, which is that, what's nice

that's a very good point which is that

about this report is that it's taking the latest data from

what's nice about the support is that it's it's taking the latest data from

the spreadsheet.

the spreadsheet so when I do update the

So when I do update the spreadsheet, when I do run

spreadsheet when I do run this this

this, this chart is going to look totally different,

charts gonna look totally different

because everyone's going to presume we raised more money.

because everyone's gonna presumably

I mean, it's a problem if anyone's

raise more money I mean it's it's a problem if anyone's funds raises is

funds raises is dropping.

dropping right it means you're losing

It means you're losing commitments, not closing.

commitments not close this way you're

KALYAN REDDY: This way you're staying on top of it.

staying on top of it and then you can

And then you can blame that person.

blame that person you're sitting on top

IKAI LAIN: You stay on top, then-- not blame

and not blame them you've helped that

them, you help them. We're a team now. So that's how to use triggers to generate a nightly report.

right we're a team now so that's how to use triggers to generate a nightly

Now, I mentioned that there's also form-based triggers and

report now I mentioned that there's also form based triggers and other types of

other types of triggers that you can run.

triggers you can run excuse me

And there are a few types of triggers here.

and there are a few types of triggers here and you'll see that let me go ahead

Let me go ahead and demonstrate. So in this spreadsheet, I'm going to use a clear one.

and demonstrate so in this in this spreadsheet I have a I'm gonna use a

clear one excuse me well nevermind so there are four types

So there are four types of triggers that

of triggers that you can put that are

are spreadsheet based.

spreadsheet-based one is uninstall on

One is on install, on open, and on edit.

open and on edit so let's say that you

So let's say that you want some code to be executed every

want some code to be executed every time

time you open a spreadsheet.

you open the spreadsheet well let's do

Well, let's do this, function onOpen.

this function on open and you would

And you would define something in here.

define something in here and when you

And when you take a look to see current script triggers,

take a look to see current script

you'll see that by naming it on open, you've automatically

triggers you'll see that by naming it on open you've automatically defined that

defined that function as the function you want to run every

function as the function you want to run

time the script is opened.

every time the script is is is open so

So it's the same thing with onEdit.

it's the same thing with on edit we need

When you define a function called onEdit in a spreadsheet

to find a function called on edit in a

attached script, you look in triggers.

spreadsheet attached script you look in

You'll see that it's automatically attached to the

triggers you'll see that it's automatically attached to the to the

script's triggers. Now, if I want to rename this onEditSuper, it's no longer

scripts triggers now if I want to make this if I want to rename this on edit super it's no longer named on edit so

what happens to the trigger well let's

So what happens to a trigger?

take a look let's go to resources

Well, let's take a look. Let's go to Resources, Current Script Trigger.

current script triggers it's gone it's

It's gone. It's no longer an automatic script that will run.

no longer an automatic script that will

So I'm going to have to click Add new trigger, click on

run so I'm gonna have to click add new

EditSuper, From spreadsheet, and click onEdit.

trigger pick on edit super from spreadsheet and click on edit and for

KALYAN REDDY: And for those of you out there who are

those of you out there who are thinking

thinking, where am I going to find all these special

you know we'll where am I gonna find all these you know the special function

function names, you can go to the Apps Script documentation.

names you can go to the app script

And you can look up what are all the special functions that

documentation and you can look up what are all the special functions that

automatically become these trigger functions.

automatically become these trig

IKAI LAIN: Fortunately, there are only three onInstall,

functions fortunately only three

onOpen, and onEdit.

uninstall on open and on edit on install

Oninstall is what happens when someone installs your scripts

is what happens when someone installs

from the script gallery.

your script from the script gallery so

so the problem there are limitations

There are limitations here.

here right you can only do certain

You can only do certain things in onOpen and onEdit.

things and on open and on edit so though

For those of you that define custom spreadsheet menus,

see they have defined custom spreadsheet

you're already familiar with onOpen, because you'll see

menus you're already familiar with on open because you'll you'll see something

something like var ss = Spreadsheet.app.

like var spreadsheet is equal to

getactivespreadsheet.

spreadsheet app dot get active spreadsheet and you'll see spreadsheet

And you'll see spreadsheet.addmenu.

dot add menu right and that's that's

And that's typically what you want to do it

typically what you want to do in a non

in an onOpen hook.

open hook sometimes you want to be

Sometimes, you want to be annoying, and you want to see

annoying and you want to see something

something like Browser.msgbox("don't mess

like SS dot excuse me

with this script").

browser dots message box don't mess with this script and browser

And Browser.msgbox pops up a little message box on top of

dot message box pops up a little message

your spreadsheet.

box on top of your spreadsheet so I'm

So I'm just going to go ahead and save this.

gonna go ahead and save this I'm going

I'm going to double check under Resources, Current

to double check under resources' current

Script Triggers. And sure enough, it's there.

script triggers and oh sure enough it's

So let's move onEditSuper, because the

there let's move on it's super because

function no longer exists.

the function no longer exists now I'm

Now, I'm going to go back to spreadsheet, I'm going to

gonna go back to spreadsheet I'm gonna

refresh this, so I'm hitting Command-R right now.

refresh this so I'm hitting command R right now and it's loading loading

And it's loading, loading, loading, loading, loading.

loading loading loading farm equal

Firing up the spreadsheet, fire up scripts.

spreadsheet farm scripts and there's my

And there's my pop-up box, "Don't mess with this script."

popup box don't mess with this script so

So you can do a lot of things in onOpen.

you can do a lot of things in an open

Oop, closed the window.

and close the window so tools script

So Tools, Script Editor, that's how you get to the

editor that's how you get the script

Script Editor from a spreadsheet.

better from a spreadsheet and we're

And we're opening this up right now.

opening this up right now look oh it's

Let's just discard the draft.

just discard to draft we don't care

We don't care about that. So you've got a lot of limitations when you're using

about that so you've got a lot of

onOpen and onEdit.

limitations when you're using on open and on spreaded on edit and there's good

And there's good reasons for this. First off, you can't ask a user, you can't say, who's the

reasons for this first off you can't ask a user you can't say who's the current

current user? You can't send an email.

user right you can't send an email you

You can't open a user's drive.

can't open the users drive in fact the

In fact, the only things you can do it onOpen and onEdit

only things you can do an on open and on

are edit the spreadsheet itself.

edit are edit the spreadsheet itself you

You cannot edit a different spreadsheet.

cannot edit a different spreadsheet and

And the reason for this is that you don't prompt the user

the reason for this is that you don't

for the permissions.

prompt a user for the permissions right

So the only things that you should be able to do are edit

so the only things you should be able to

the spreadsheets.

do are edit the spreadsheet so the

So the downside here is that you can't have an onEdit that

downside here is that you can't have a non open on edit that says every time

says, every time this is edited, email me.

this is edited email me so or I'm sorry

I'm sorry-- yeah, you can't email the user.

yeah you can't email the user like

That's not something you can do.

that's not something you could do

However, you can say every time you edit, add a time

however you can say every time you edit

stamp to the currently edited row, or every time you open a

at a time stamp to the currently edit row or every time you open the

spreadsheet, add a menu.

spreadsheet add a menu and typically

And typically, what you would do instead is in onOpen, you

what you would do instead is you would create the in on open you create a menu

would create a menu that on clicking the menu, then the

that on clicking the menu then the youth

user authorizes your scripts so you can access user's

user authorizes your script so that you

drive, access other spreadsheets, basically, just

can access users drive access other spreadsheets basically just work on

work on behalf of the user.

behalf of the user but you cannot work

But you cannot work on behalf of the user in onOpen or

on behalf of the user in on open or on

onEdit, as in you can't access email, you can't access drive,

edit as in you can't access email you can't access Drive you can't access Docs

you can't access docs, you can't access anything else.

you can't access anything else

So that's how you do that.

so that's how you do that so let's talk

So let's talk about the very special one,

about the very special one which is on

which is On Form Submit.

Form submit and this is the one that we

And this is the one that we very commonly use any time we

very commonly use anytime we work with

work with forms.

forms so again let's go back to our

So again, let's go back to our fundraising spreadsheet.

fundraising spreadsheet we've got two

We've got two tabs. One is for fundraising.

tabs one is for fundraising and the

And the second one is for donations.

second one is for donations so donations

So donations, I've created a Google form

i've created a google form under form

under Form, Edit Form.

edit form and it's because i've already

It's because I've already created this.

created this that's why you're seeing

That's why you're seeing this right now.

this right now so you're seeing that

So you're seeing that when I hit Edit Form, well,

when i hit edit form well basically this

basically, this collects name, email, and a domain email and

collects a name email and a donation

that's all I really want.

amount and that's that's all I really

So I'm going to close this window.

want so I'm going to close this window

When we go to Live Form, you'll see that this is what

and when we go to live form you'll see

my form looks like.

that this is what my form looks like

it's a fundraising it's a form that

It's a form that tells people, hey, give me your name and

tells people hey give me your name and

give me your email, and what your donation amount is.

give me your email and what your

So let's go ahead and try doing this right now.

donation amount is so let's go ahead and try doing this right now right I have

excuse me not gonna do this yet so I

So I have this wired up to an Apps Script to send an email

have this wired up to an app script to

to whoever fills out the form, if you give me a correctly

send an email to whoever fills out the

formed email address.

form if you give me a correctly formed

So let's go ahead back to on form submit.

email address so let's go ahead back to

On form submit is not one of these magic function names.

on Form submit now on Form submit is not one of these magic function names you

You have to go into Resources, click Current Script Triggers, select the function, From Spreadsheet, and

have to go into resources click current script triggers select the function from

click on form submit.

spreadsheet and click on Form submit so

So you have to do that.

you have to do that there's no magical

There's no magical name that you can do to

name that you can do to make this thing

make this thing work. Once you hit Save, whenever someone submits the form,

work once you hit save whenever someone submits the the form

it'll execute the code in whatever function you've

it'll execute the code in whatever

defined to execute.

function you define to execute so in

So, in this case, there are better ways of doing this.

this case there are better ways of doing this you can do e dot values to return

You can do E dot values to return to form values as an array.

to form values as an array you can also

You can also use named parameters.

use name parameters there are lots of

There are lots of things that you could do here.

things that you can do here so I suggest

So I suggest that you check out the triggers documentation

that you check out the triggers

for an exhaustive list of how to get at the parameters.

documentation for an exhaustive list of how to get at the parameters but for now

But for now, we're just going to use an array for clarity.

we're just gonna use an array for

So each one of these values corresponds to

clarity so each one of these values

a spreadsheet column.

corresponds to a spreadsheet column and

And spreadsheet columns are what we call one index.

spreadsheet columns are what we call one

So the very first column here is 1, 2, 3, 4.

index so the very first column here is one two three four however this is a

However, this is a JavaScript array.

JavaScript array and sometimes this

And sometimes this mismatch can be a little bit confusing.

mismatch can be a little bit confusing a

A JavaScript array, it's like a European floor.

JavaScript array it's like a European

It starts at 0.

floor it starts at zero so

So we're going to start at 0, 1, 2, 3.

gonna start at zero one two three so we

So we go back here.

go back here and time stamp is now call

And timestamp is now column 0. Name is column 1.

them zero name is column one email is

Email is column 2. And donation is column 3.

column two and donations column three so

So we're going to create variables for this, just for

we're gonna create variables for this

just for code clarity you don't have to

You don't have to do this.

do this I do this because when someone's

I do this because when someone's reading my code,

reading my code they know what's going

they know what's going on.

on again I'm going to use the HTML

Again, I'm going to use the HTML service trick.

service trick would create template from

We'll create template from file.

file it's now I'm going to set two

Now I'm going to set two variables, name and amount.

variables name and amount so let's take

So let's take a look at notificationTemplate.html.

a look at notification template dot HTML

And you can always create HTML files by going to

and you can always create HTML files by

File, New HTML File.

going to file new HTML file so here I've

So here, I've created a basic HTML file that says, "thank

created a basic HTML file that says

you for your donation." You know, dear name, which is

thank you for your donation you know dear name which is going to be variable

going to be the variable name inject.

and inject thank you for your generous

"Thank you for your generous donation of" some dollar amount.

donation of some dollar amount so we're

So we're going to go ahead and inject that dollar amount.

gonna go ahead and inject that dollar

And I'm going to sign this, because I'm very grateful that

amount and I'm gonna sign this because

you donated money.

I'm very grateful that you donated money

So this is all wired to when a form submits.

so this is all wired to win a form

And when this is done, I'm going to send an email.

submits and when this is done I'm gonna

I'm going to thank you for your donation.

send an email I'm gonna thank you for

And I'm going to say htmlBody dot

your donation and I'm gonna say HTML

template.evaluate.getContent.

body dot template evaluate get content

So let's go ahead and do this now.

so let's go ahead and do this now and

And how much do we donate?

how much should we donate we were

We're Michael Moneybags.

Michael moneybags well I'm a very rich

KALYAN REDDY: Well, I know this very, very rich guy. He's a good friend of mine.

guy his good friend of mine so what's

So let's donate a billion dollars. IKAI LAIN: $1 million.

the million dollars 1 million why would

Why would you donate $1 billion when you

you donate 1 billion dollars when he

can donate $1 million?

could donate 1 million dollars sure

KALYAN REDDY: Sure. IKAI LAIN: A little silly joke for those of us

little silly joke for those of us who

who are kind of--

are kind of nevermind awesome power

nevermind, Austin Powers generation.

generation so I'm gonna hit submit and

So I'm going to hit Submit. And it's just a standard form output that says, hey, your

it's just a standard form output that

response has been recorded.

says hey your response has been recorded

So when we go back to the spreadsheet, we see that

so when we go back to the spreadsheet we

Michael Moneybags has committed to donating $1

see that Michael moneybags has committed to donating 1 million dollars to our

million to our cause.

cause and you notice that the commas win

And you notice that the commas went in.

and this is a nice little spreadsheet

This is a nice little spreadsheet feature. You can format a row.

feature you can format a row so I've

So I've selected this row. And I've gone to--

selected this row and I've gone to this

this is always format, number, and just selected currency.

is always format number and just

So if I select currency with cents, any new thing that

selected currency so if I select currency of cents it'll it'll any new thing that comes in

comes in will be formatted currency with commas, dollar

before mat of currency what commas

signs, and cents.

dollar sign cents so let's go ahead and

So let's go ahead and check my email inbox.

check my email inbox oh I've got a new

Oh, I've got a new email.

email what could this be

What could this be? I'm Michael Moneybags.

I'm Michael moneybags dear Michael

"Dear Michael Moneybags, thank you for your generous donation

moneybags thank you for a generation

of $1 million."

generous donation of 1 million dollars

One thing to notice is that this is not formatted the same

one thing to notice is that this is not

way it's formatted on the spreadsheet.

formatted the same ways format in the

That's because internally, it's still saved

spreadsheet that's because internally it's still

as the value 100000000.

saved as the value one zero zero zero zero zero zero spreadsheet formats are

Spreadsheet formats are purely view only.

purely view only so if I want to format

So if I want to format this so it looks nicer, I'm going to

this so it looks nicer I'm gonna have to

have to go ahead and manually format this thing before I

go ahead and manually format this thing

send it out to the template.

before I send it out to the template so

So keep that in mind that the number you get is not going to

keep that in mind that the number you

look exactly the same as the number you get inside the

get is not gonna look exactly the same as a number you get inside the

spreadsheets like right here I'm just

So right here, I'm just saying the amount.

setting the amount and the raw value I

And the raw value I entered, if you remember, it's just

entered if you remember it's just this

number so that's why it looks like that

So that's why it looks like that in email and it looks

an email and it looks different from

different from the spreadsheet. OK, so that's kind of--

spreadsheet okay so that's kind of loops

oops. That's the next part.

that's the next part don't look it's a

Don't look. It's a secret.

secret so so there are a couple of

So there are a couple of things to know about working

things to know about working with

we're triggers.

triggers right triggers do have CPU

Triggers do have CPU limits. So you can't just write a trigger that runs for days.

limits so you can't just write a trigger that runs four days right so a trigger

So a trigger will time out around a five minute mark.

will timeout around the five minute mark

It'll probably go a little bit longer than that.

you'll probably go a little bit longer

And also, if you run 10,000 jobs a day, you're probably

than that and also if you run ten

going to run out of quota.

thousand jobs that you're probably gonna

So you can't just use triggers as a way of doing infinite

run out of quota so you can't just use triggers as a way of doing infinite

computation you need to you need to

You need to think about what you're doing and kind of

think about what you're doing and kind

balance things out.

of balance things out with triggers when

With triggers, when you want to return the user as running

you want to return to user it's running

as, you want to use section.geteffectiveuser.

as you want to use session get effective

Because it's not an active user, it's an effective user.

user because it's not an active user it's an effective user it's Who am i

It's who am I running as, as opposed to who's actually on

running as as opposed to who's actually

the computer typing away, pushing buttons and whatnot.

on the computer like typing away pushing buttons and whatnot what two things that

Well, two things that I haven't talked about yet that

I haven't talked about yet that I will

I will demonstrate right now are All My Triggers and email

demonstrate right now are all my

triggers and email notifications so when

So when you're in the Script Editor, sometimes, like me,

you're in a script editor sometimes like

you might be working on five or six scripts at once.

me you might be working on five or six

And you don't know what triggers are running.

scripts at once and you don't know what

And that's why there's an All My Triggers resource.

triggers are running and that's why

So if you go to Resources, All Your Triggers.

there's an all my triggers resource so if you go to resources all your triggers

And I'm in a totally different app right now.

and I'm in a totally different app right

You'll see that I've returned all of my triggers across all

now you'll see that I've returned all of

of my different applications.

my triggers across all my different

KALYAN REDDY: We'll see the ones we created with the other

applications and let's see once we created with the other other script is

script as well.

what's right that's right like I have

IKAI LAIN: That's right. I have the email gkal trigger right here.

the email G Cal trigger right here and

And let's go ahead and cancel it.

let's go ahead and cancel it so you're

So you're no longer going to get congratulatory emails.

no longer gonna get congratulatory

So we're going to save this.

emails so we're gonna save this that's

That's really nice.

really nice the other nice thing is that

The other nice thing is that when you go to either All My

when you go to either

Triggers or Triggers, I've kind of been glazing over this

all my triggers of triggers I've kind of

notifications thing.

been glazing over this notifications

thing and uh you know what's nice about

What's nice about this is that you can set up notification so

this is that you can set up

that when there are errors in your script, you get an email.

notifications so that when their errors in your script you get an email and you

And there are no errors in anything that I

know there are no errors and anything

write, because I'm me.

that I write because I'm me kidding but

Kidding. But sometimes, you might get invalid input or there might

sometimes you might get invalid input or

be a bug in your code.

there might be a bug in your code it's

It's very important that you want to get notified.

very important that you want to get

So when you have a notification, you might want

notified so when you when you have a notification you might want to be

to be notified that there's an error.

notified that there's an error and under

And under the notification, there are various options.

the notification of various options you

You might want to be notified every time, immediately when

might want to be notified every time

there's an error.

immediately when there's an error and if

And if you have a low volume usage script, you

you have a low-volume usage script you

sometimes want this.

sometimes want this because someone uses

Because if someone uses your script, it doesn't work, you

your script it doesn't work you don't

don't want them to call you.

want them to call you right like you

You want to be on it.

want to be on it you wanna be on top of

You want to be on top of that thing.

that thing so you go ahead and click

So you go ahead and click Immediately.

immediately and whenever there's a

And whenever there's a failure, you'll get the

failure you'll get the failure right

failure right away. Maybe a common failure is--

away like maybe a common failure is let

let me show you guys something.

me show you guys something else and it's

KALYAN REDDY: And it's still good practice to run your

still good practice to run your your

trigger function before just to test it, make sure

trigger function before just to test it

everything works.

you know make sure everything works but

But this is also a good catch if there is some kind of

this is also a good catch so if there is

extraneous error, then you'll get notified of it.

some kind of a string this error then

IKAI LAIN: Right.

you'll get notified when you get an

When you get an error, it looks something like this.

error it looks something like this you

This is a summary email.

know you get a this is a summary email

But it'll tell you all the errors.

but it'll tell you all the errors to

It'll tell you what the error message was.

tell you what the error message was and

And it'll say what caused it and what time it was.

it'll say that you know what caused it

So this isn't a lot of information.

and what time it was so this isn't a lot

But one of the patterns that you can use is if you know

of information but one of the patterns that you can use is if you know there's

there's some place that you're trying to debug, put a try

some place that's that you're trying to

catch block around it.

debug put a try-catch block around it

And when it does blow up, then go ahead and

and when it does blow up then go ahead

email a stack trace.

and email a stack trace because

Because sometimes the stack trace is more useful.

sometimes as factories is more useful

But we would completely blow up your inbox if we were to do

but we completely blow up your your

that every single time.

inbox if we're doing every single time

You want to record relevant values, as in, what are the

and you want to record relevant values

values that might have caused this error?

that's in one of the values that might

So you're going to want to go ahead and build that.

have caused this error so you're long ago you're going to want to go ahead and build that so again the other values

So again, the other values here, all your triggers, notification.

here all your triggers notification

Besides immediately, you have hourly, daily, weekly.

besides immediately have hourly daily

So most of the time, I just want notifications daily, how

and weekly so sometimes most the time I just want notifications daily how many

many errors there were.

years there were right and you know

And occasionally there's one or two.

occasionally there's one or two and such

And such is life.

is life right like that's just the use

That's just the user putting in wrong input or something.

of putting it wrong input or something

And that's why I might want it daily instead of immediately.

and that's why I might want it daily instead of immediately but then again

But then again, it just depends on a volume or script

you know it just depends on the volume

and what kind of debugging you want, what kind of

or script and what kind of debugging you

notifications you want.

want what kind of notifications you want

So that's how you can add error

so that's how you can add error

notifications to your triggers.

notifications to your triggers because

Because when you're running a script, what I call

when you're running a script what I call

interactively, you get the error right away.

interactively you get the error right

You can dig into it right away.

away you can dig into right away but

But when script is being run as a trigger, there's no other

when script is being run as a trigger

way of figuring out when it's bombing out or

there's no other way of kind of figuring out when it's bombing out or when there

when there are errors.

errors so that's why you want to use a

So that's why you want to use a notification functionality

notification functionality to kind of

to debug your script when there's problems.

debug your script when there's problems

Everything good so far?

everything good so far yeah makes sense

KALYAN REDDY: Yeah, it makes sense. IKAI LAIN: Good.

good good so let's talk about things you

Good. Let's talk about things you can't do.

can't do I touched on this earlier but

I touched on this earlier. But again, you cannot use onInstall, onOpen, and onEdit

again you cannot use uninstall on open

to do anything beyond accessing the spreadsheet

and on edit to do anything beyond

they're contained by.

accessing the spreadsheet they're

You can't send emails.

contained by you can't send emails you

You can't access user's drive.

can't access users drive you can only

You go only edit the spreadsheet.

edit the spreadsheet on form submit and

On form submit and on clock triggers, these run as a user

on clock triggers these run as a user

that installed the trigger.

that installed the trigger so if your

So if your app programmatically creates a

app programmatic creates a trigger for a

trigger for a different user, it runs as a client user.

different user it runs as a client trigger so as a client user so let's say

So let's say, I create a web application.

I create a web application and Colleen

And Kalyan comes, and he clicks some button.

comes and he clicks some button well the

Well, the trigger now runs under him and not under me,

trigger now runs under him and not under

and I'll show you guys what I mean by this.

me and I'll show you guys what I mean by

So here's a web app I've written.

this so here's a web app I've written it

It is in one of these windows.

is in one of these windows cancel cancel

Cancel. Cancel. So I called the schedule trigger from a web app.

so I called a scheduled trigger from a

And I created this just at script.google.com.

web app and I created this just at

It's got a do get handler.

script.google.com it's got a do get handler and it creates a single button

And it creates a single button that's says schedule trigger.

that's a scheduled trigger that creates

That creates a trigger that emails me every one minute. When it calls email me, again I call session dot get

the trigger that emails me every one minute when it calls email me again I

effective user.

call session on get effective user who's

Who is the user I'm running as?

the user I'm running ass and I'm sending

And I'm sending an email that says, you're getting this

an email that says you're getting this

because of a button. Hi, there.

because of a button hi there so if I go

So if I go ahead and deploy this thing,

ahead and I deploy this thing it looks

it looks like this.

Publish the app.

this published the app public whoops

Do not publish at the Gallery.

do not publish at the gallery people

People commonly mix this up with [INAUDIBLE]

commonly mix this up with deploy as web

app I've done a couple of times by

I've done it a couple times by accident.

accident so here's the current web app

So here's the current web app URL.

URL so let's open a new window like so

So let's open a new window, like so. And it's going to load a single button that says,

and it's gonna load a single button that

schedule something for me, schedule a trigger.

says schedule something for me schedule

All right, that's fine.

trigger alright that's fine but right

But right now, as you can see, I'm logged

now as you can see I'm logged in as my

in as my test account.

test account so let's log in as a

So let's log in as a different test account.

different test account so this is a

So this is a different test account.

different test account this is Dino

This is dinodinosaur.test.

dinosaur test um I'm gonna I just copy

I just copy, pasted the URL.

pasted the URL and the first thing I'm

And the first thing I'm going to see is an authorization

gonna see is an authorization dialogue

dialogue, because this is a web app.

because this is a web app so I'm gonna

So I'm going to say, oh, this script wants access to send

say oh this script wants access to send

email and also wants permission to subscribe to

email and it also wants permission to

external events, as in, schedule more triggers.

subscribe to external events as in

So I'm going to authorize this.

schedule more triggers so I'm gonna authorize this it's gonna take me to the

It's going to take me to the web app and it

web app and it looks exactly the same

looks exactly the same. And I'm going to schedule a trigger.

and I'm the schedule trigger that's all

That's all it does.

it does I should have set some feedback

I should have set some feedback or something. But this is a demo application.

or something but you know this is a demo

So I've gone ahead and I've scheduled a trigger.

application right so I've gone ahead and

And what you'll see is that you'll get an email that says,

I've scheduled a trigger and what you'll see is that you'll get an email that

oh, hey, you just installed a web application.

says oh hey you know you just installed

Here's how you uninstall it.

a web application here's the here's the e here here's how you uninstall it so in

So in about a minute, I'll start getting emails.

about a minute I'll start getting emails

And there you go.

and there you go there's my first email

There's my first email.

you are getting this because of button

You are getting this because of a button.

you know a trigger has been scheduled

A trigger has been scheduled for me that's emailing

for me that's emailing Dino dinosaur dot

dinodinosaur.test. And if we go to test script, this is nothing.

test and we go to test script this is

I just save this so I can look at the

nothing I just save this so I can look

current scripts trigger.

at the current scripts trigger there are

There are no script triggers for a current script, because

no triggers for current script because I

I didn't set any up.

didn't set any up this is a blank script

This is a blank script.

but ever go the resources all your

But if I go to Resources, All Your Triggers, oh, well, I

triggers oh well I have an email me

have an email me trigger. It's not attached to a script.

trigger it's not attached to a script so

So I want to cancel this.

I want to cancel this so there are two

So there are two things I can do.

things I can do I can either go back to

I can either go back to this notification email, more

this notification email more

information, and click on uninstall.

informations and click on uninstall or I

Or I can just go here and delete the email me trigger.

can just go here and delete the email me

And that'll kill the trigger off.

trigger and this whole excuse me and yeah that'll that'll kill the trigger

So again, let's go through that again.

off so again let's let's float around

If I click Schedule Trigger, it's already-- whew, wow.

again if I click the schedule trigger it's ready swoo Wow I assumed it a lot

I zoomed in a lot there. Resources, All Your Triggers.

their resources all your triggers I

I pushed a button twice.

pushed a button twice it's kind of and

And now I can cancel it like so, and click Save.

now I can cancel it like so and click Save and that'll get rid of the triggers

And that'll get rid of the triggers. KALYAN REDDY: So this running as the user executing it, will

so this running as the user executing it

this also have implications for a quota of certain things?

will this also have implications for a quota of certain things

IKAI LAIN: Yes. So when it runs, it will use up your user's quota.

yes so when it runs it will use up your

So because it runs as you, it uses your quota.

users quota so because it runs at you it uses your quota it doesn't unless for

Unless, for instance, you saw it when I published the

instance you saw it when I publish the

application, I said run it as the end user.

application I said run it as the end

Let me see if I can show you what I mean. If I execute it as me, [email protected], it's

user let me see if I can show you what I mean if I execute it as me ich island test at gmail.com it's gonna use my

going to use my quota. KALYAN REDDY: So there's uses for both.

quota okay so there's usages for both

One is if you don't want to run over the amount of emails

one is you know if you don't want to run

you can send every day, you can have it run as the user,

over the amount of emails you can send every day you can have it run as as the

and then use their quota instead.

user and then use their quota instead

IKAI LAIN: Exactly. And the thing about that is that when I go here and I

exactly and the thing about that is that

click sent email, you see that, oh, well, this is

when I go here and I click send email you see that oh well this is running as

running as ikai.lain.test.

ich I land test whereas when it runs as

Whereas when it runs as you, Mail App sends this to you, too.

you mail app sends as you - so this is

So this is coming from dinodinosaur.test.

coming from Dino dinosaur Dino dinosaur

When I go to send mail, it's running as the second user.

test when I go to sent mail it's running as the second users I don't you so it's

So it's not just for quota reasons.

not just that you want it's not just for

The main reason should not be quota related.

quota reasons the main reason should not

The main reason should be you want to run it as you.

be quoted relate the main reason should be you want to run it as you write you

You want someone to sign up and get update notifications

want someone to sign up and get update

on, I don't know, the latest documents coming into your

notifications on I don't know the latest documents coming into your drive or

drive, or whatever. So let's go and talk about some advanced patterns.

whatever okay so let's go and talk about

some advanced patterns

So there are three patterns I want to talk about, and of

so they're the three patterns I want to talk about and you know of where you

where you would use triggers outside the

would use triggers outside of the

exams I've showed you.

examples I've shown you one is when you

One is when you want to chain long running jobs.

want to change long-running jobs like

Like right now, as you know, there's a limit to how long a

right now as you know there's a limit to

trigger can run.

how long a trigger can run so let's say

So let's say we want to run a job that going to

you want to run a job that's going to

take, say, an hour.

take say an hour well how would you do

Well, how would you do that?

Well, you really can't right now.

well you really can't right now but you

But you can with triggers.

can with triggers is what you would do

And what you would do is you would create a trigger that

is you would create a trigger that runs

runs every five minutes or so, and just goes ahead.

every 5 minutes or so and just goes

And when it's done executing, it executes the next block.

ahead and when it's done executing it

So you might want to save a point or two where you are in

executes the next block so you might want to save like a pointer to where you

your job, and just keep moving.

are in your job and just keep moving and

And you save that either in a property or in ScriptDb.

you save that I learned a property or in scriptdb and that's how you would do a

And that's how you would do a long running job.

long-running job and when you done with

And when you're done with the job, you can program and

the job you know you can program out

create triggers.

create triggers you can also unschedule

You can also unschedule triggers.

triggers so let's talk about how to do

So let's talk about how to do that

that and so just to be clear you would

KALYAN REDDY: So just to be clear, you would want to do

want to do this because there is an

this because there is an established limit on how long

established limit on how long each

each execution can run.

execution can exactly you have a total

IKAI LAIN: Exactly. You have a total CPU time that you can

CPU time you can use up for your

use up for your triggers.

triggers and it sometimes you just don't

And sometimes you just don't want a runaway trigger.

want a runaway trigger right like if you

If you want a user to be able to cancel all their triggers,

want a user to be able to cancel all

for instance, you can write a trigger that

their triggers for instance you can

says, kill all triggers.

write a trigger that says kill all

And you don't have to name it this.

triggers and you have to name it this

What you would do is you would do

what you would do is you would do script

ScriptApp.getScriptTriggers.

that dot get script triggers this

This returns an array of all the triggers.

returns an array of all the triggers you

You can iterate through this.

can iterate through this whoops there's

There's a syntax error here.

a syntax error here

And this would cancel all the triggers.

and this would cancel all the triggers

So triggers, when I pick the trigger it's currently working

so triggers when I pick the trigger it's

on, I would just say-- opps.

currently working on I would just say

You would delete the trigger via script apps.

oops you would delete the trigger via

So you would say, ScriptApp.deleteTrigger, and

script app so you say script app dot delete trigger and pass it the current

pass it the current trigger.

trigger right and this deletes all the

And this deletes all the triggers. This is like a big red panic button.

triggers it's like a big it's like a big

But really, sometimes you only want to

red panic button but really sometimes

delete a specific trigger.

you only want to delete a specific

So that's when you would put in a conditional like this.

trigger so that's when you would put in a conditional like this triggers the

Triggers, the current one.

current one and you would say well

And you would say, well, what's the handler function?

what's the handler function right if the

If the handler function is email me, go ahead and delete

handler function is email me go ahead

and delete the trigger and there's one

And there's one more way to do this, which is that triggers

more way you could do this which is that

have something called a unique ID, get unique ID.

triggers have something called a unique ID get unique ID and this is unique

And this is unique globally.

globally this is unique across all

This is unique across all scripts for all users. So at the time of trigger creation, what you might want

scripts for all users so at the time of trigger creation what you might want to

to do is say Trigger.getUniqueID, save this

do is say trigger dot get unique ID save

somewhere, like in ScriptDb, or in properties, and that

this somewhere like in scriptdb or in

way, if you've got a bunch of different triggers running for

properties and that way if you've got a

a bunch of different people, you can just go ahead and get

bunch of different triggers running for a bunch of different people you can just go ahead and if get unique ID matches

unique ID matches the one in ScriptDb, delete that trigger.

the one in scriptdb delete that trigger

So that's typically how you want to programmatically

so that's typically how you want to

unschedule triggers.

programmatically kind of unschedule triggers okay so there's one more

So there's one more pattern.

pattern which is I said before that you

I said before that you cannot set up triggers in onOpen.

cannot set up triggers in on open you

When you copy a spreadsheet, it does not

cannot when you copy a spreadsheet it

copy over to triggers.

does not copy over the triggers so if I

So if I go here to the spreadsheet that I created,

go here to the spreadsheet that I

demo fundraising, and I made a copy of this-- make a copy.

created demo fundraising and it made a copy of this make a copy copy demo

Copy demo fundraising. And right now, this is a total copy of the spreadsheet for

fundraising and right now this is a total copy of

the most part, except when I go to Tools, Script Editor.

the spreadsheet for the most part except when I go to tools script editor and

And scripts take a few seconds to copy.

scripts take a few seconds to copy so

So this might not have copied yet.

this might not have copied yet but

But fortunately, I was slow, so it did it.

fortunately you know I was slow so it

You'll see that it's copied all the code.

did it you'll see that's copied all the

But when I go to Resources, Current Script Triggers, only

code I want to go to resources current script figures only the on open and on

the onOpen and onEdit triggers are set up.

edit triggers are set up we don't have

We don't have the trigger that says, run this every hour, run

the trigger that says run this every

this every minute, run this at midnight.

hour run this every minute run this at

That's not copied over.

midnight that's not copied over so this

So this is problematic if your workflow is to create a

is problematic if you if your workflow

spreadsheet and you have people in your organization

is to create a spreadsheet and you have

make a copy of it.

people in your organization make a copy

Because you often want them to copy the

of it because you often want them to

time-based triggers, too.

copy the time-based triggers - so what

So what do we do about this?

do we do about this well a common

Well, a common pattern that I do is I use

pattern that I do is I use the on open I

onOpen to create a menu.

use on open to create a menu in the menu

In the menu, I say, set up a spreadsheet.

I say set up a spreadsheet and I store

And I store it inside script properties, or user

inside script properties or user

properties, or wherever that says, you have created the

properties or wherever that says you

triggers or you have not created the triggers.

have created the triggers or you have

not created triggers alternatively on yeah and what you just excuse me you

You can't access those inside onOpen.

can't access those inside on open but

But what you can do is you create a menu item that says, schedule set up the script.

what you can do is you can you create menu item that says schedule set up the

So you go ahead, and you click the menu item.

script so you go ahead and you click

You say, set up script.

them anyone you see set up script it's

It's going to ask the user for authorization.

gonna ask use for authorization and at

And at that point, it's going to go ahead and schedule the

that point it's gonna go ahead and

triggers for you.

schedule the triggers for you and

Because you have functions like get script triggers, you

because you have functions like get

can look to see if the trigger has already been set up.

script triggers you can look to see if the triggers already been set up so you

So you can run through it.

can run through it you can say does this

You can say, does this trigger exist? Yes, no. If it does, set it up.

trigger exist yes no if it does set it

If not, don't set it up.

up if not don't set it up because if I

Because if I run schedule trigger again and again, if I

run scheduled trigger again and again if

run schedule trigger three or four times, I will create

I run scheduled for three or four times

three or four triggers.

I will create three or four triggers

Because again, you can attach multiple

because again you can attach multiple

triggers to the same function.

triggers to the same to the same

KALYAN REDDY: So basically, it would just run the function

function so basically it would just run

that many times.

the function that many times

IKAI LAIN: Exactly. So a trigger is kind of like me creating a memo that says,

exactly so a trigger is kind of like me creating a memo that says do this job

and you create five copies of the memo

And you create five copies of the memo and I give it to Eric.

and I give it to Eric and if Eric takes

And if Eric takes things very literally, he will do the job

things very literally he will do the job

five times right fortunately Eric will

Fortunately, Eric will just come back to me and say, what

just come back to me and say what are

are you doing, man?

what is this but but this is a computer

But this is a computer.

so what a computer you have to be very

So with a computer you have to be very, very specific about

very specific about what you wanted to

what you want it to do.

do and that's why triggers have this get

And that's why triggers have this get unique ID function.

unique ID function so that even if I

So that if I give him five memos, each memo has an ID

give him five memos each member has an

that says, this is ID 1, this is ID 2, this is ID 3.

ID that says this is ID one this is ID 2

And he knows, oh, these are different jobs.

this is ID 3 and he knows oh these are

And you can do the same thing when you're managing triggers,

different jobs and you can do the same

that once you know the ID, you know that they're different,

thing when you're managing triggers that once you know the ID you can you know

unique triggers.

that there are different unique triggers

And that's what I have for patterns so far.

and that's what I have for patterns so

There are definitely many more patterns.

far they're definitely much many more

These three are the ones that tend to be the most common.

patterns these three are the ones I see that tend to be much muscle that tend to

So I just like to talk about these a lot.

be the most common so I just like to talk about these a lot and that's what I

And that's what I have for you guys today.

have for you guys today if you guys have

If you guys have any more ideas for shows you'd want to

any more ideas for shows you want to see

see, do let us know.

do let us know we have more shows

We have more shows happening this week and

happening this weekend next week as well

next week as well. So again, my email address is [email protected].

so again my email address is ika I at

Or Kalyan's is [email protected].

Google calm or Colleen's is gk al at

You can email him.

google.com you can email him its

It's appeared in this demo multiple times.

appeared in this demo multiple times so

So do you have any questions so far?

do you have any questions so far no I

KALYAN REDDY: No, I think triggers are a great way, for

think triggers are a great a great way

example, to get around some things like making a long

for example to get around some things

like making a long-running job right and

IKAI LAIN: Great, and now you're going to

now you're gonna use them now I'm gonna

use them every day.

use them every day all the time all the

KALYAN REDDY: All the time. IKAI LAIN: All the time.

time I'm gonna set up a trigger to email

KALYAN REDDY: I'm going to set up a trigger to email myself

myself and remind myself how cool I am

and remind myself how cool I am. IKAI LAIN: All right. So when we started this show, no one was asking questions on

alright so when we started to show no

Google Moderator.

one was asking questions on Google

So let's go ahead.

moderator so let's go ahead and

Apparently, the status of this has changed.

apparently the status of this has

So we're going to go a little bit over the time

changed so we're gonna go a little bit

limit for the show.

over the time limit for show originally

Originally, we were set up to go for 45 minutes.

we were set up to go for 45 minutes but

But let's see what questions people have.

let's take let's see what questions

I'm always nervous about live questions. Mostly because people ask something, I don't know

people have I'm always nervous about live questions mostly because people ask

how to answer it.

something's done how to answer it

I'm not going to click play, because that's going to cause

I'm not gonna click play because that's

some crazy feedback.

gonna cause some crazy feedback I'd like

"I'd like a trigger for onClose.

to trigger for on clothes given a three

Given the three triggers available, is there a way to

triggers available is there way a trick

trick one into being in onClose?" Maybe.

went into being a non clothes maybe I I'm not I don't think I'm not sure about

I'm not sure about this, actually.

this actually would be I don't think it

KALYAN REDDY: I don't think it would work in the same way,

would work in the same way because the

because the containing spreadsheet is no longer open.

containing spreadsheet is no longer open

IKAI LAIN: Right.

right i I think that I I was originally

I was recently thinking about something with onEdit.

thinking about something what on edit

When edit stopped for more than a certain amount of time,

wouldn't edit stop for more than a certain amount of time then maybe some

then maybe someone has closed your spreadsheet.

of this close your spreadsheet but

But that's not really good. KALYAN REDDY: You could do something like--

that's not really good so something like

yeah. IKAI LAIN: I don't know.

yeah yeah I don't know man like I don't

I don't think there's a good way of doing this.

think there's a way I don't think there's a good way of doing this but

But definitely put in a feature request.

definitely put in a feature request will

And we'll figure out why there is or isn't a way

figure out why there is or isn't a way

of doing this now.

of doing this now I I remember hearing

I remember hearing something about why there wasn't an

something about why there wasn't it on

onUninstall. But do open a feature request.

uninstall right but do open a future

And we'll check this one out.

arrests will check this one and a

KALYAN REDDY: And a close approximation has set up a

close-up approximation is set up a

time based trigger that will go back and clean up all the

time-based trigger that will go back and

tasks, like whatever you want to do.

clean up all the tasks like whatever you

Maybe you want to clean up some of the fields, or format

want to do there maybe you want to clean

something differently.

up some of the fields or format

You can do it on a time trigger.

something differently you can you can do

Just go back and do that same thing.

it on a time trigger just go back in do

IKAI LAIN: Right, right.

that same thing right right okay the

The next question is "will the emails created with these

next question is will the emails created

triggers gets stored in the Sent folder in Gmail?" If I'm

with these triggers get stored in the sent folder in Gmail if I'm running a

running a trigger as myself and I use Mail App, yes, it

trigger as myself and I use mail app yes

will be in my Sent folder.

it will be in my sent folder if it's

If it's coming from Kalyan, and it's executing as him,

coming from Kalyan and it's executing as

they'll be in his Sent folder.

him they'll be in his sent folder and

And the third question is, "I just want to create social site." Well, that's good for you.

the third question is I just want to create social site well that's good for

And I wish you luck in your endeavors. All right.

you and I wish you luck in your endeavors all right so I think that's it

So I think that's it for now.

for now if you have any more questions

If you have any more questions, we're going to wrap

we're gonna wrap the show up but we're

this show up. But we're doing office hours this Thursday.

doing office hours this Thursday if

If you're watching the show live this Thursday--

you're watching a show live this

and we do them every Thursday or most Thursdays--

Thursday and we do them every Thursday

just go to developers.google.com/live and

or most Thursdays just go to

look for Apps Script Office hours.

developers.google.com/live and look for

We do them almost every week.

Apps Script office hours we do them

So check us out and join us.

almost every week so check us out and

KALYAN REDDY: And you can always go to our Stack

join us and you can always go to our

Overflow posted against our tag.

Stack Overflow posted against our tag

We are pretty active there.

and we're pretty active there and also

And also the issue tracker if you come up with any issues.

the issue tracker if you come up with

IKAI LAIN: That's right.

any issues that's right alright well I

All right, well, I think that's it for today.

think that's it for today all right

Thank you guys very much.

thank you guys very much and we'll see

And we'll see you guys next time. KALYAN REDDY: Thank you.

you guys next time thank you

Similar videos:

Building a Charts Dashboard with Google Apps Script
Google for Developers
74.7K views 459 likes 20 dislikes 11 Dec 2012100% match

Integrating Google Apps with Salesforce using Google Apps Script
Google for Developers
18.8K views 104 likes 1 dislikes 30 Nov 2012100% match

Apps Script Crash Course: ScriptDb
Google for Developers
8.4K views 79 likes 1 dislikes 14 Feb 2013100% match

State of the Script 2013
Google for Developers
5.7K views 34 likes 3 dislikes 12 Feb 2013100% match

Apps Script Crash Course: ContentService
Google for Developers
9K views 97 likes 4 dislikes 24 Jan 2013100% match

Google Drive SDK: Managing your Drive files with Apps Script
Google for Developers
7.4K views 42 likes 9 dislikes 11 Oct 2012100% match

Google Apps Script: Introduction
Google Workspace
49.4K views 81 likes 5 dislikes 26 May 200980% match

Using Apps Script with Twilio
Google for Developers
13K views 102 likes 2 dislikes 10 Dec 201275% match

Google Drive SDK: Building Drive apps entirely on the cloud with Google Apps Script
Google for Developers
9.1K views 78 likes 2 dislikes 05 Mar 201375% match

What is Google Apps Script?
Google for Developers
290.2K views 666 likes 29 dislikes 13 Sep 201360% match

What is Google Apps Script?
Google for Developers
395.8K views 639 likes 103 dislikes 28 Jun 201260% match

Introducción a Google Apps Script - Lección 1
Google for Developers
86.6K views 1K likes 33 dislikes 28 Oct 201337% match

Automate Your Google Analytics Reporting with Apps Script
Google for Developers
14.1K views 119 likes 1 dislikes 15 Nov 201236% match

Google I/O 2012 - Use What You Know: HTML and JavaScript in Apps Script
Google for Developers
30.2K views 213 likes 6 dislikes 03 Jul 201235% match

Introducción a Google Apps Script - Lección 4 (Spanish)
Google for Developers
26.2K views 195 likes 7 dislikes 31 Oct 201333% match

Introducción a Google Apps Script - Lección 3 (Spanish)
Google for Developers
19.9K views 150 likes 4 dislikes 30 Oct 201333% match

Introducción a Google Apps Script - Lección 2 (Spanish)
Google for Developers
47.3K views 431 likes 12 dislikes 29 Oct 201333% match

Apps Script Crash Course - Script Editor
Google for Developers
77.7K views 444 likes 14 dislikes 05 Jun 201330% match

Google I/O 2011: Enterprise Workflow with Apps Script
Google for Developers
33.5K views 87 likes 7 dislikes 13 May 201129% match

Google I/O 2013 - Use Apps Script to Create Dynamic Google Forms
Google for Developers
83.5K views 343 likes 9 dislikes 16 May 201326% match

Tackling Authentication with AngularFire
Angular
24.2K views 0 likes 0 dislikes 18 Jun 201526% match

Google Apps Unscripted - December 2013
Google for Developers
39.1K views 89 likes 14 dislikes 18 Dec 201326% match

Script It! with Fusion Tables
Google for Developers
25K views 151 likes 3 dislikes 04 Apr 201325% match

Google I/O 2011: Developing Apps, Add Ins and More with Apps Script
Google for Developers
28.5K views 87 likes 3 dislikes 11 May 201124% match

Your First Script - Apps Script Tutorials
Google for Developers
419.6K views 1.1K likes 105 dislikes 09 Apr 201321% match

Sending emails from a Spreadsheet - Apps Script Tutorial
Google for Developers
143K views 432 likes 22 dislikes 09 Apr 201321% match

Google I/O 2013 - High Performance Apps with Go on App Engine
Google for Developers
34.4K views 183 likes 5 dislikes 20 May 201320% match

Settings Privacy About Contact Donate