Is It Possible To Have A Prompt Show Up For One Spreadsheet When Activated By Another?

Is it possible to have triggers that work for 2 spreadsheets (2, independent files) with one script? I am stuck at how to do this part, as it needs to be automated. So far in my re

Solution 1:

Triggers are set by spreadsheet, not by sheet, but you could use JavaScript control statements like if..else and switch to control when should be executed parts of your script.

Example:

function respondToOnEdit(e){
  var sheetName = e.source.getActiveSheet().getName();
  if(sheetName === 'Sheet1'){
    //do something when Sheet1 is edited
  } elseif(sheetName === 'Sheet2'){
    //do something when Sheet2 is edited  
  } else {
    //do something when any other sheet is edited
  }
}

You will have to use code to create an installable trigger for each spreadsheet.

Code snippet:

[id1, id2].forEach(id => {
var spreadsheet = SpreadsheetApp.openById(id);
ScriptApp.newTrigger('respondToOnEdit')
.forSpreadsheet(spreadsheet)
.create()
}

Related

• Is there any way to automatically create installable triggers?