Google自动电子邮件

Question

代码如下

在发送一些自动电子邮件时遇到问题。我知道如何根据电子表格自动发送电子邮件，但复杂的是，电子邮件需要在交替的情况下发送。

A组和B组每个周日都需要一封电子邮件，告诉他们一周的日程安排。这两组人要么面对面，要么远程，但他们每周都会轮流。

也就是说，A组本周亲自到场，而B组是远程的。接下来的一周，他们将是相反的(A组远程，B组面对面)

对此有什么想法吗？

​

    function CheckCohortA() 
{
  // Fetch the Cohort
  var CohortRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Cohorts").getRange("C2:C8"); 
  var Cohort = CohortRange.getValue();
  
  // Check Cohort
  if (Cohort = "A"){
    // Fetch the email address
    var emailRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Cohorts").getRange("B2:B8");
    var emailAddress = emailRange.getValues();
  
  //SendEmail
  var sheet = SpreadsheetApp.getActiveSheet();
  var startRow = 2; // Start at second row because the first row contains the data labels
  var numRows = 10000; // Put in here the number of rows you want to process

  // Fetch the range of cells A2:D
  var dataRange = sheet.getRange("A2:ZZ")
  
  // Fetch values for each row in the Range. I modified this after our call on 4/13 and it no references the cells E and F for th subject and message. 
  // May be easier for Principals to navigate and now this code won't have to be touched as long as the rows aren't changed I don't think. 
  var data = dataRange.getValues();
  for (i in data) {
   var row = data[i];
   var name = row[0];
   var emailAddress = row[1]; 
   var subject = row[5];
   var message = row[4]; 
   var CC = row[3];
   MailApp.sendEmail(emailAddress, subject, message,{
         cc: CC
         });
  }
  }
}

​

Answer 1

在if (Cohort = "A"){中，=就是simple assignment operator。要进行比较，请使用==或===。参考https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Expressions_and_Operators#Comparison