=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
BrainFuck Programming Tutorial by: Katie
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
| /* | |
| * Async.gs | |
| * | |
| * Manages asyncronous execution via time-based triggers. | |
| * | |
| * Note that execution normally takes 30-60s due to scheduling of the trigger. | |
| * | |
| * @see https://developers.google.com/apps-script/reference/script/clock-trigger-builder.html | |
| */ |
| /* | |
| PDF Creator - Email all responses | |
| ================================= | |
| When you click "Create PDF > Create a PDF for each row" this script | |
| constructs a PDF for each row in the attached GSheet. The value in the | |
| "File Name" column is used to name the file and - if there is a | |
| value - it is emailed to the recipient in the "Email" column. |
| function onOpen() { | |
| var menuEntries = [ {name: "Create Diary Doc from Sheet", functionName: "createDocFromSheet"}]; | |
| var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
| ss.addMenu("Fitness Diaries", menuEntries); | |
| } | |
| function createDocFromSheet(){ | |
| var templateid = "1O4afl8SZmMxMFpAiN16VZIddJDaFdeRBbFyBtJvepwM"; // get template file id | |
| var FOLDER_NAME = "Fitness Diaries"; // folder name of where to put completed diaries | |
| // get the data from an individual user |