TypeError: Cannot set property '2' of undefined (line 24, file "Code")

Question

I've been trying to figure out this but for the longest time and I've got nothing. How do I fix this error, please help

function myFunction() {
  var form = FormApp.openByUrl('form');
  var allItems = form.getItems();
  var doc = SpreadsheetApp.getActiveSpreadsheet()
  var sheet = doc.getSheetByName("name");
  var last = doc.getLastRow();
  var data = sheet.getRange(1,1,last,8).getValues();

for(i=0,h=1; i<data.length, h<allItems.length;++i,++h){
        
    
    if(data[i][2] == 0 && h==4){ //this where the error messages comes up for the "2"
      
      var newText = allItems[h].asMultipleChoiceItem();
      var title = newText.getTitle();
      var newTitle = newText.setTitle(title+" (Sold out)");
}
}
}

That means that the "data" object is undefined. Check whether the name of the sheet is correct ("name") or the range of the values you are getting ( e.g. var "last"). Could you please add Logger.log(sheet) after the var sheet line? — Marios
– Marios, Commented Jul 26, 2020 at 20:51

TheMaster · Accepted Answer · 2020-07-26 20:53:19Z

2

It means i exceeds data.length=> data[i] will be undefined =>undefined[2]: Well,undefined doesn't have property [2].

TypeError: Cannot set property '2' of undefined

The "condition" of the for-loop seems amiss. The comma operator only returns the last value. Try

 i<data.length && h<allItems.length

instead.

answered Jul 26, 2020 at 20:53

TheMaster

51.6k7 gold badges76 silver badges102 bronze badges

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

Collectives™ on Stack Overflow

TypeError: Cannot set property '2' of undefined (line 24, file "Code")

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