https://www.youtube.com/watch?v=DopttQgOEZY 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 […]
You are browsing archives for
Category: Google Apps Script
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 < […]
Google Apps Script Easy First Project – Email Alert Add-on
Google Apps Scripts is a powerful tool. All you need is a basic understanding of JavaScript and you can create any add on your heart desires. Hoping to make Google Apps Script more accessible, I started a new project. This create a simple applicatoin that notifies you when a user has submitted a particular word […]