Scripts, scripts, scripts!

[Richard_Chow]

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.

[Darren_Murphy]

Okay, so that error is pretty obvious.

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

@Richard_Chow

function sendSms(to, body)

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.

[abe.sherman]

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.

For the Glide 🚀

DDNS customer app

This script will send email if the alert_stats changes stats to either up or down. If it goes down the script will send a email in 5 hours after it has bean down. This is a very useful script. You can use it if a stats has changed. and to send multiple emails that’s listed. Enjoy. [image] function clr() { // Just to clear the store. PropertiesService.getScriptProperties().deleteAllProperties(); } function Alert_when_offline_Online() { const sheet = SpreadsheetApp.getActiveSpreadsheet().ge…

[Pablo_Miguel_Martine]

@gvalero

[adriasoce]

Where do you put the scripts for working?

[Darren_Murphy]

In the GSheet script editor…

Is that what you were asking?

[adriasoce]

You put them there and work on Glide?

[Darren_Murphy]

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.

[adriasoce]

oh perfect. Thanks!