Code for this video is posted below. [code] // Word Based Email Alert System // Kurt Kaiser, 2017 // Declarations var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var lastRow = sheet.getLastRow(); var lastColumn = sheet.getLastColumn(); // Go through recent submission, check for alert word function checkSubmission() { for (var i = 1; i < […]
You are browsing archives for
Tag: Apps Script
How to Code in Google Apps Script – Beginner Project Tutorial
Coding your first application in Google Apps Script can be intimidating. I started using Apps Script about two years ago. There wasn’t many video tutorials that I could find. So I decided to make my own. Below I code a simple project, perfect for beginners. [code language=”js”] // Absence Email Confirmation // By Kurt Kaiser […]