This is a sample Google Apps Script for running the specific function when the specific sheet is edited.
Please copy and paste the following script to the container-bound script of Spreadsheet and set sheets
object.
// When the cells are edited, this function is run by the fire of event trigger.
function onEdit(e) {
// Please set the sheet name and function as follows.
const sheets = {
Sheet1: functionForSheet1, // Sheet1 is the sheet name. functionForSheet1 is the function name of function which is run when Sheet1 is edited.
Sheet2: functionForSheet2,
};
const sheetName = e.range.getSheet().getSheetName();
if (sheets[sheetName]) {
sheets[sheetName](e);
}
}
// In this sample, when Sheet1 is edited, this function is run.
function functionForSheet1(e) {
console.log("Sheet1 was edited.");
// do something
}
// In this sample, when Sheet2 is edited, this function is run.
function functionForSheet2(e) {
console.log("Sheet2 was edited.");
// do something
}
- In this sample script, when the cells of "Sheet1" and "Sheet2" are edited,
functionForSheet1()
andfunctionForSheet2()
are run, respectively. When other sheets are edited, no functions are run. - In this sample script,
onEdit
of the simple trigger is used. When the functions you want to run include the methods which are required to authorize, please use the installable trigger.
- This method can be also used for other event triggers like OnChange, OnSelectionChange and so son.