Scripts, scripts, scripts!

[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…