Creating and deleting triggers by script
You can create or delete triggers programmatically as shown in the following sample code:
/** * Deletes all the triggers. * */ function deleteTriggers(){ var triggers = ScriptApp.getProjectTriggers(); triggers.forEach(function(trigger){ try{ ScriptApp.deleteTrigger(trigger); } catch(e) { throw e.message; }; Utilities.sleep(1000); }); }; function createTrigger(){ var ss = SpreadsheetApp.getActiveSpreadsheet(); // Create new trigger ScriptApp.newTrigger("sendEmail") .forSpreadsheet(ss).onFormSubmit().create(); };
Note
In the
deleteTriggers
function, the Utilities
service's sleep
method is used to pause the script temporarily for the specified milliseconds. Otherwise, you may experience the Too many service invocation…
error.