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