jeudi 5 juillet 2018

Re-set checkboxes to false - Google Apps Script

I have a google spreadsheet where column A has checkboxes in each row. I have written a script to perform a function on all rows where the checkboxes are checked, but I want to add in at the end a reset function so that all checked boxes are unchecked again after the script is run.

I've tried using a for loop like this:

var dataRange = sheet.getRange('A3:A');
var values = dataRange.getValues();

for (var i = 0; i < values.length; i++) {
for (var j = 0; j < values[i].length; j++) {     
  if (values[i][j] == true) {
    values[i].setValue(false);
  }
}    
} 

But clearly this doesn't work as I get an error. Does anyone know how this could be done?




Aucun commentaire:

Enregistrer un commentaire