# Scripts, scripts, scripts! **URL:** \ **Category:** Ask for Help\ **Created:** [November 26, 2020, 6:15pm UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965 "2020-11-26T18:15:21Z")\ **Posts on this page:** 1\ **Showing post:** 185
**Author:** ![abe.sherman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abe.sherman/32/11260_2.png) [@abe.sherman](https://community.glideapps.com/u/abe.sherman)\ **Post date:** [March 14, 2021, 2:50am UTC](https://community.glideapps.com/t/scripts-scripts-scripts/18965/185 "2021-03-14T02:50:52Z")
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 🚀](https://docs.google.com/spreadsheets/d/1upT-iJ4sfPN1aSNSqhvR7SyM4-CG8lBVeMuslbOOWgc/edit?usp=sharing)** > > 🚀 > > ddns,state,alert\_state,alert\_timestamp,mail 1,mail 2,mail 3,mail 4,mail 5,mail... > [@DDNS customer app](https://community.glideapps.com/t/ddns-customer-app/23693/14): > > 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. function clr() { // Just to clear the store. PropertiesService.getScriptProperties().deleteAllProperties(); } function Alert\_when\_offline\_Online() { const sheet = SpreadsheetApp.getActiveSpreadsheet().ge… --- _[View the full topic](https://community.glideapps.com/t/scripts-scripts-scripts/18965)._