Scripts, scripts, scripts!

Thanks Darren.

2:00:03 PM

2:18:49 PM

Error

Exception: Failed to send email: no recipient

Twilio

@ Code.gs:51

This is the error shown.

Okay, so that error is pretty obvious.

In the code you posted, you have the following function definintion:

But you don’t show how that function is called.
Find the line in your code that calls that function, and check the value of to at that point.

I think this code is a knock out. Check it out.

  1. Send a email based on status change.
  2. Send email to multiple columns.
  3. Send a offline email based on timestamp, After 5 hours in this case. (currently when it goes offline.)

Very very useful code.

Here is a sample spreadsheet you can test and see how it would work
Please change the status in order to see the results.
Please note in the sample sheet. you wont have the email function. Instead click on the link down

Please make a copy of this sheet. And enjoy the magic.

4 Likes

@gvalero

1 Like

Where do you put the scripts for working?

In the GSheet script editor…

Is that what you were asking?

You put them there and work on Glide?

I’m not sure I understand your question.
Scripts are generally used to extend the capabilities of Glide, or fill in the gaps to do things that Glide cannot do.

For example, there is no current way to execute time-based actions with Glide, so scripts can be used for this. There are many other examples where scripts might be used.

1 Like

oh perfect. Thanks!