Google App Script looping through array of values

Question

Hello I'm trying to loop through an array of values and If the any of the values is bigger than 0, then the script should send a specific email. I just cant figure it out how to do it. What am I doing wrong?

  var TO = ['[email protected]','[email protected]'];
  var failedOperation = [0, 0, 0, 52, 2, 5,]
  var message1 = 'Check the sheet';
  var message2 = 'Its Ok';
  var subject = 'Your Google Spreadsheet Alert';

  for(var i in failedOperation && var j in TO){
    if(typeof failedOperation[i] > 0){
      MailApp.sendEmail(TO[j], subject, message1);
    }
    else{
      MailApp.sendEmail(TO[j], subject, message2);
    }
  }

Cooper · Accepted Answer · 2020-04-19 20:08:10Z

1

function www() {
  var TO = ['[email protected]','[email protected]'];
  var failedOperation = [0, 0, 0, 52, 2, 5];
  var message1 = 'Check the sheet';
  var message2 = 'Its Ok';
  var subject = 'Your Google Spreadsheet Alert';
  for(var i=0; i<failedOperation.length;i++){
    if(failedOperation[i]>0){
      MailApp.sendEmail(TO[1], subject, message1);
    }else{
      MailApp.sendEmail(TO[0], subject, message2);
    }
  }
}

answered Apr 19, 2020 at 20:08

Cooper

64.2k7 gold badges28 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

Google App Script looping through array of values

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