从工作表发送电子邮件的更简洁的方式

Question

我目前有一个正在工作的谷歌脚本，它在谷歌游泳池化学监测表中读取仪表板上的值。人们将提交一个表单，如果这些数字大于或小于一个设定的数字，它将发送一封带有特定消息的电子邮件。

这工作很好，但如果有多个数字是关闭的，我会收到多个电子邮件，这是恼人的。

     function sendEmails() {
      var sheet = SpreadsheetApp.getActiveSheet();

    //----vvvvvPool
      var IDPpHReading = sheet.getRange('A6:A7').getValue();
      var IDPpHTest = sheet.getRange('B6:B7').getValue();
      var IDPORP = sheet.getRange('A9:A10').getValue();
      var IDPSetPoint = sheet.getRange('B9:B10').getValue();

      var IDPCL = sheet.getRange('A12:A13').getValue();
      var IDP_Filter1_INF = sheet.getRange('A16:A17').getValue();
      var IDP_Filter1_EFF =  sheet.getRange('B16:B17').getValue();
      var IDP_Filter2_INF = sheet.getRange('A20:A21').getValue();
      var IDP_Filter2_EFF =  sheet.getRange('B20:B21').getValue();

// insert email here
    var emailAddress = "[e-mail]";  
//-------------------- IDP pH 
    if (IDPpHReading  > 7.8) {
      var subject = "High pH Reading IDP";
      var message = " An Aquatic Specialist recently logged a chemical reading that was too high for the Indoor Pool. Please check the situation asap.";

      MailApp.sendEmail(emailAddress, subject, message);
    }
  else if  (IDPpHReading  < 7.2) {
      var subject = "Low pH Reading IDP";
      var message = " An Aquatics Specialist recently logged a chemical reading that was too low for the Indoor Pool. Please check the situation asap.";

      MailApp.sendEmail(emailAddress, subject, message);
    }
   if (IDPpHTest  > 7.8) {
      var subject = "High pH Test IDP";
      var message = " An Aquatics Specialist recently logged a chemical reading that was too high for the Indoor Pool. Please check the situation asap.";

      MailApp.sendEmail(emailAddress, subject, message);
    }
  else if  (IDPpHTest  < 7.2) {
      var subject = "Low pH Test IDP";
      var message = " An Aquatics Specialist recently logged a chemical reading that was too low for the Indoor Pool. Please check the situation asap.";

      MailApp.sendEmail(emailAddress, subject, message);
    }

};

var message 1;
var message 2;
etc

然后使用email-mailapp.sendeMail(emailAddress,subject,Message1+Message2...)；

但我觉得这样做太草率了。

Answer 1

我已经做过几次了，我通常做的是使用字符串连接来构建消息，然后发送它：

  var subject = "Abnormal pH Reading IDP";    
  var message = 'An Aquatics Specialist recently logged a chemical reading at the indoor pool and found:\n';
  var needsCheck = false;

    if (IDPpHReading  > 7.8) {

          var message = message + "\nA reading that was too high.";
          var needsCheck = true;

        }
      else if  (IDPpHReading  < 7.2) {
          var message = message + "\nA reading that was too low.";
          var needsCheck = true;

        }
       if (IDPpHTest  > 7.8) {
          var message = message + "\nA test that was too high.";
          var needsCheck = true;

        }
      else if  (IDPpHTest  < 7.2) {
          var message = message + "\nA test that was too low.";
          var needsCheck = true;
        }

  if (needsCheck){
    var message = message + "\n\nPlease check the situation asap.";
    MailApp.sendEmail(emailAddress, subject, message);
  }