Untitled

/**
 * Setup function to install the onEdit trigger
 * Run this once to set up the installable trigger
 */
function setupTrigger() {
  try {
    // Delete any existing onEdit triggers to avoid duplicates
    var triggers = ScriptApp.getProjectTriggers();
    triggers.forEach(function(trigger) {
      if (trigger.getHandlerFunction() === 'onEdit') {
        ScriptApp.deleteTrigger(trigger);
      }
    });
    
    // Create new installable onEdit trigger
    ScriptApp.newTrigger('onEdit')
      .onEdit()
      .create();
    
    console.log("Setup completed successfully");
    SpreadsheetApp.getUi().alert("Setup completed! The checkbox trigger is now active.");
    
  } catch (error) {
    console.error("Error during setup:", error);
    SpreadsheetApp.getUi().alert("Setup error: " + error.message);
  }
}