GSA error: Cannot find function includes in object

Question

I have 2 array and i want find in first array have value of second array is push data of first array but i can't.

Error message : "TypeError: Cannot find function includes in object...."

This my code:

function loadArrInArr(){

  var firstArr = ["aaa", "bbb", "ccc"];
  var ss = SpreadsheetApp.openByUrl(urldb);
  var ws = ss.getSheetByName("sheet1");
  var secondArr = ws.getDataRange().getDisplayValues();
  var tmpArr = [];

  for(var i = 0; i < secondArr.length; i++){
    if(firstArr.includes(secondArr[i][0])){ //err this line
      tmpArr.push(secondArr[i]);
    }
  }

}

I found this thread. I think that this thread is useful for your situation. stackoverflow.com/q/50281560/7108653 — Tanaike
– Tanaike, Commented Aug 15, 2019 at 6:09

Tanaike · Accepted Answer · 2019-08-15 06:16:18Z

1

Unfortunately, in the current stage, includes() cannot be used with Google Apps Script yet. So how about this modification? In this modification, indexOf is used instead of includes.

Pattern 1:

When your script is modified, how about this modification?

From:

if(firstArr.includes(secondArr[i][0])){

To:

if(firstArr.indexOf(secondArr[i][0]) > -1){

or

if(~firstArr.indexOf(secondArr[i][0])){

Pattern 2:

As another pattern, how about this modification?

From:

var tmpArr = [];

for(var i = 0; i < secondArr.length; i++){
  if(firstArr.includes(secondArr[i][0])){ //err this line
    tmpArr.push(secondArr[i]);
  }
}

To:

var tmpArr = secondArr.filter(function(row) {return ~firstArr.indexOf(row[0])});

When the length of secondArr is large, to use filter() can reduce the process cost than that of the for loop.

References:

If I misunderstood your question and this wat not the result you want, I apologize.

edited Aug 15, 2019 at 6:16

answered Aug 15, 2019 at 6:00

Tanaike

203k12 gold badges126 silver badges222 bronze badges

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

5 Comments

Naoa Lee Over a year ago

Thanks for your help, I tested it and succeeded. You're so good !

Tanaike Over a year ago

@Naoa Lee Thank you for replying. I'm glad your issue was resolved. I added one more script. Could you please confirm it? The additional script is faster than the script using the for loop.

Naoa Lee Over a year ago

Tks you so much, Please give me the link !

Tanaike Over a year ago

@Naoa Lee The additional script is "Pattern 2" in my answer.

Naoa Lee Over a year ago

I'm sorry, ^^ Thank you for your enthusiasm !

Collectives™ on Stack Overflow

GSA error: Cannot find function includes in object

1 Answer 1

Pattern 1:

From:

To:

Pattern 2:

From:

To:

References:

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Pattern 1:

From:

To:

Pattern 2:

From:

To:

References:

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related