mardi 15 septembre 2020

Google Script - Removing Else statement properly so it skips/ignores

I have a checklist, column C indicates which test is automated by "enabled" or "disabled" written in the cells.

Further down the row is a column for the the Pass / Empty column for each test.

I have code that looks for if Enabled in column C, in X column on that row, mark as Pass automatically (or 'P' in my case).

The problem: If C column contains "Disabled" but also a Pass, when I run the script it replaces that Pass with an empty cell. How can I change the else statement to just ignore that cell and leave whatever is in it for anything but Enabled condition is met

function autoPassPC() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Aug 2020');
  

  //  What to put in the test result
  var values1 = "P";
  // Where to look for Auto:
  var values2 = sheet.getRange("C10:C15" + sheet.getLastRow()).getValues();
  
  // Keyword to look for in Auto: column
  var putValues = [];
  for (var i = 0; i < values2.length; i++) {
    if (values2[i][0] === "Enabled") {
      putValues.push([values1]);
    } else {
      putValues.push([""]);
    }
  }

  //  Put value1 inside row, column# for test result
  sheet.getRange(10, 25, putValues.length, 1).setValues(putValues);
}

Basically how do I get rid of

} else {
  putValues.push([""]);
}

properly? Just deleting this causes the script to put 'P' on every single row. Just want it to ignore the cells instead.

Thanks!

Aucun commentaire:

Enregistrer un commentaire