Skip to main content

Google Apps Script – Calendar Reservation Project

google apps script calendar reservation code Spreadsheet Youtube Part 2 Part 3 Calendar Reservation Project My new project uses a data submitted to a Google Form to create events on a calendar. The Google Form asks for the person’s name, reason for the visit and allows them to select the day and time for their appointment. The code uses an […]

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