Comparing elements of an array in Google Apps Script

Question

I cannot figure out why the if statement I have marked as "If statement in question", never evaluates to true and its commands never execute.

  function setDuplicatesArray () {
  var sheet = SpreadsheetApp.getActive().getActiveSheet();

  var compareFromCol = "A";
  var compareToCol = "E";
  var compareFromIndex = sheet.getRange(compareFromCol+"1").getColumn();
  var compareToIndex = sheet.getRange(compareToCol+"1").getColumn();
  var maxRows = sheet.getMaxRows();


  var FromValues = sheet.getRange(4,compareFromIndex,maxRows,1).getValues();
  var ToValues   = sheet.getRange(4,compareToIndex,maxRows,1).getValues();

  var count = 0
  for (i=0; i <= maxRows; i++) {
    var from = FromValues[i];
    if (from == "") { break; }
       for ( j=0; j <= maxRows; j++) {
         var to = ToValues[j];

         if (to == "") {break; }

         Logger.log("\n"+from+"\n"+to+"\n\n");

         if (from === to) { //IF STATEMENT IN QUESTION
           count = count++;
           sheet.getRange(i+4,compareFromIndex,1,4).setBackgroundRGB(255,255,0);
           break;
         }
       }
  }

Here is the log to confirm that some elements are the same:

[17-07-08 12:27:57:899 PDT] 
Desk
Cats


[17-07-08 12:27:57:900 PDT] 
Desk
Dogs


[17-07-08 12:27:57:900 PDT] 
Desk
Pigs


[17-07-08 12:27:57:900 PDT] 
Desk
Fish


[17-07-08 12:27:57:900 PDT] 
Cats
Cats


[17-07-08 12:27:57:901 PDT] 
Cats
Dogs


[17-07-08 12:27:57:901 PDT] 
Cats
Pigs


[17-07-08 12:27:57:901 PDT] 
Cats
Fish


[17-07-08 12:27:57:902 PDT] 
Fish
Cats


[17-07-08 12:27:57:902 PDT] 
Fish
Dogs


[17-07-08 12:27:57:902 PDT] 
Fish
Pigs


[17-07-08 12:27:57:903 PDT] 
Fish
Fish


[17-07-08 12:27:57:903 PDT] 
Pencils
Cats


[17-07-08 12:27:57:903 PDT] 
Pencils
Dogs


[17-07-08 12:27:57:904 PDT] 
Pencils
Pigs


[17-07-08 12:27:57:904 PDT] 
Pencils
Fish


[17-07-08 12:27:57:904 PDT] 0.0

Welcome to Stack Overflow! It looks like you need to learn to use a debugger. Please help yourself to some complementary debugging techniques. If you still have issues afterwards, please feel free to come back with a Minimal, Complete, and Verifiable example that demonstrates your problem. — Ivan Pronin
– Ivan Pronin, Commented Jul 8, 2017 at 19:52
Please note that JavaScript is not Java, and Google Apps Script is not Google App Engine; these are totally different things. While [javascript] is relevant, the tag usage guidance specifically excludes Google Apps Script. The most important tag to have here is [google-apps-script], which I now added. — user6655984
– user6655984, Commented Jul 8, 2017 at 21:55

Adam Hill · Accepted Answer · 2017-07-08 21:51:33Z

2

I figured it out.

.getValues() creates a two dimensional array despite there being only one column in its range.

So I changed:

var from = FromValues[i];

to

var from = FromValues[i][0];

and

var from = ToValues[j];

to

var from = ToValues[j][0];

edited Jul 8, 2017 at 21:51

user6655984

answered Jul 8, 2017 at 21:15

Adam Hill

811 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Comparing elements of an array in Google Apps Script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related