Google-sheets – Run Google Sheets script on multiple sheets

google sheetsgoogle-appsgoogle-apps-script

I have a Google Sheets script that's designed to input timestamps whenever there is an edit, but I need it to run on multiple sheets (West, East AND North) on the same drive… How can I make that work?

See the code below:

function onEdit(e) {
  var ss = SpreadsheetApp.getActiveSheet();
  var r = ss.getActiveCell();
  //1.Change 'Sheet1' to be matching your sheet name
  if (r.getColumn() < 9 && ss.getName()=='WEST') { // 2. If Edit is done in any column before Column (L)  And sheet name is WEST then:    
var celladdress ='L'+ r.getRowIndex() 
    ss.getRange(celladdress).setValue(new Date()).setNumberFormat("MM/dd/yyyy hh:mm");
  }
};

Best Answer

Try replacing one line of your code with this

if (r.getColumn() < 9 && ( ss.getName()=='WEST' || ss.getName()=='EAST' || ss.getName()=='NORTH' || ss.getName()=='SOUTH' ) ) {

It's a bit long, but it follows your current logic.

Related Solutions

Google Sheets – Multiple Auto-Populated Select Boxes Script UI

Add a new select with a new id, and assign a set of values the same way.

This should give a good idea how to fill multiple drop-downs from one data array where each column sets the drop-down value.

function onSuccess(values) {
//values is a 2d array.

      var opt,
      dropDown;

    for(i = 0;i < values.length; i++){
      dropDown_one = document.getElementById("id_one");
      if (values[i][0]) { //check if there actually is a value
      opt = document.createElement("option");
      dropDown.options.add(opt);
      opt.text = values[i][0]; //0 is first column
      opt.value = values[i][0]; 
      dropDown_one.options.add(opt);

      }

      dropDown_two = document.getElementById("id_two");
      if (values[i][1]) { //check if there actually is a value
      opt = document.createElement("option");
      opt.text = values[i][1]; //1 is second column
      opt.value = values[i][1]; 
      dropDown_two.options.add(opt);

      }
   }    
}

Google-sheets – Google Sheets Script Editor action not applying to all sheets

Get the sheet that was edited. Change code to:

var sheet, ss;

ss = SpreadsheetApp.getActiveSpreadsheet();
sheet = ss.getActiveSheet();//Get the active sheet

Now the sheet variable is the active sheet that was just edited. So anything done with sheet will affect that sheet.

Best Answer

Related Solutions

Google Sheets – Multiple Auto-Populated Select Boxes Script UI

Google-sheets – Google Sheets Script Editor action not applying to all sheets

Related Topic