mardi 10 juillet 2018

Google Sheets Script: Basic IF Statement

Stuck at the moment with a basic if statement. Why is my statement selecting ALL the values, instead of just values that match the condition? Only 8 rows worth of values should be selected. I've never had issues before and as I'm going back over old scripts, I can't figure it out.

//UPDATE AGE SHEETS
function updateAgeSheets() {

var exportCurrentRow = 2
var exportCurrentColumn = 1
var exportNumRows = 999
var exportNumColumns = 9


//GIRLS WEB BRACKETS PAGE
var ssWebBracketsGirls = SpreadsheetApp.openById('1PXWf_g1b60qYx8M88bWox7LQIggEVjFeqOFhiKQFeo4');
var sheetWebBracketsGirls = ssWebBracketsGirls.getSheetByName('IMPORT');
var rangeWebBracketsGirls = sheetWebBracketsGirls.getRange(exportCurrentRow, exportCurrentColumn, exportNumRows, exportNumColumns);
var valuesBracketsGirls = rangeWebBracketsGirls.getValues();

//GIRLS SHEETS & RANGES

var F09 = ssWebBracketsGirls.getSheetByName('F09');
var rangeF09 = F09.getRange(exportCurrentRow, exportCurrentColumn, exportNumRows, 9);


for (var i = 0; i < valuesBracketsGirls.length; ++i) {

var columnGirls = valuesBracketsGirls[i];
var colAGirls = columnGirls[0];
var colBGirls = columnGirls[1];
var colCGirls = columnGirls[2];
var colDGirls = columnGirls[3];
var colEGirls = columnGirls[4];
var colFGirls = columnGirls[5];
var colGGirls = columnGirls[6];
var colHGirls = columnGirls[7];
var colIGirls = columnGirls[8];

var imageAGirls = colAGirls;
var groupAGirls = colBGirls;
var imageBGirls = colCGirls;
var groupBGirls = colDGirls;
var imageCGirls = colEGirls;
var groupCGirls = colFGirls;
var imageDGirls = colGGirls;
var groupDGirls = colHGirls;
var ageGirls = colIGirls;

  if (ageGirls == 'U09') {

    rangeF09.setValues(valuesBracketsGirls);
}

}


}//END OF FORMULA

Aucun commentaire:

Enregistrer un commentaire