Multi-Day Booking

little trigger-installer

/* * Rebuild all installable triggers for this spreadsheet project. * Safe to run manually from Apps Script. / function createInstallableTriggers() { const ss = SpreadsheetApp.getActive();

// Remove existing triggers for this project first, // so we don't end up with duplicates. const triggers = ScriptApp.getProjectTriggers(); for (const trigger of triggers) { ScriptApp.deleteTrigger(trigger); }

// Spreadsheet on edit trigger ScriptApp.newTrigger('onApprovalEdit') .forSpreadsheet(ss) .onEdit() .create();

// Form submit trigger ScriptApp.newTrigger('setPendingOnFormSubmit') .forSpreadsheet(ss) .onFormSubmit() .create();

Logger.log('Installable triggers recreated successfully.'); }

Checker Function

/* * Lists current project triggers in the log. / function listProjectTriggers() { const triggers = ScriptApp.getProjectTriggers();

if (triggers.length === 0) { Logger.log('No project triggers found.'); return; }

triggers.forEach((t, i) => { Logger.log( '%s) Function: %s | Event: %s | Source: %s', i + 1, t.getHandlerFunction(), t.getEventType(), t.getTriggerSource() ); }); }