JavaScript (Google Script Custom Function) Not Reading Array Properties

Question

I am writing a simple custom function to iterate through a column, and if a cell has a certain value, to check the value of a different column in that same row. If the value in that cell has a certain value, increase a counter. For some reason, I am getting a TypeError when trying to read a specific column.

Here is the error message I am getting:

TypeError: Cannot read property '0' of undefined (line 22).

Line 22 being: if (data[row][0] === "example") {

Does anyone have any solutions? Thank you.

  
  var sheet = SpreadsheetApp.getActive().getSheetByName('Form Responses 1');
  var lastRow = sheet.getLastRow();
  var lastCol = sheet.getLastColumn();
  
  var range = sheet.getRange(2, 2, lastRow, lastCol);
  var data = range.getValues();
  
  var count = 0;

  data.forEach(function (row) {
    if (data[row][0] === email) {
      if(data[row][1] === meeting){
      count += 1;
    }
  }
  });
  return data;
}

Wicket · Accepted Answer · 2022-04-15 04:47:22Z

1

Instead of

data.forEach(function (row) {
    if (data[row][0] === "[email protected]") {
      if(data[row][1] === "Leadership"){
      count += 1;
    }
  }
  });

try

data.forEach(function (row) {
    if (row[0] === "[email protected]") {
      if(row][1] === "Leadership"){
      count += 1;
    }
  }
  });

The above assumes that the first column might contain "[email protected]" and the second might contain "Leadership"

answered Apr 15, 2022 at 4:47

Wicket

39.4k9 gold badges81 silver badges201 bronze badges

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

Collectives™ on Stack Overflow

JavaScript (Google Script Custom Function) Not Reading Array Properties

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