Skip to main content

Google Apps Script Easy Email Alert Project – Part 2

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

7.2: Report Heading – Header, Implementation & Client Files

7.2: Report Heading – Header, Implementation & Client Files

This programming challenge, 2┬áReport Heading, asks us to create a program that outputs the heading for a company report. We need to create a header, implementation and client file. If you’re not familiar with these three different files, check out my blog about programming challenge 7-1 Date. First, I created the header file, this is […]