Ytukyg

function incrimentingQuerystring() {



  Logger.clear();



  var app = SpreadsheetApp.getActive();

  var targetSheet = app.getSheetByName("scriptedQuery");

  var targetCell = targetSheet.getRange(2, 1);

  var refSheet = app.getSheetByName("ref");

  var query;



  //buildQueryFromSubStrings:



  var beginString = ("={"); // Only to be added to first iteration.

  var s1 = refSheet.getRange(3, 9).getValue();

  var s2 = refSheet.getRange(4, 9).getValue();

  var s3 = refSheet.getRange(5, 9).getValue();

  var s4 = refSheet.getRange(6, 9).getValue();

  var s5 = refSheet.getRange(7, 9).getValue();

  var endString = (";"); // To be deducted from last iteration  *************HOW????????*****************



  //Get Chart Of Account Reference Codes to Query:



  var data = app.getSheetByName("COA").getDataRange().getValues();



  //Incriment though each accont in Chart of Acconts Sheet.



  for (var i = 6; i < data.length; i++) {



    var queryIteration = (s1 + (i - 1) + s2 + (i - 1) + s3 + (i - 1) + s4 + (i - 1) + s5 + endString);



    //Logger.log(queryIteration);



    var thisIteration = (queryIteration + thisIteration);



    //Logger.log(thisIteration);

  }



  //Logger.log(i);

  

  //******My attempt at removing var endString****



  var finalIteration = (s1 + ("5") + s2 + ("5") + s3 + ("5") + s4 + ("5") + s5 + "}"); 



  //Logger.log(finalIteration) // This seems correct but is preceded by "undefined" when added to query below:



  var query = (beginString + thisIteration + finalIteration); // results "undefined" being added prior to finalIteration.



  //Logger.log(query); //Runs out of space to see error. Error can be seen in targetCell in spreadsheet.



  targetCell.setValue(query);

}