我编写了一个代码来发送 1 封常规电子邮件和 1 封条件电子邮件，但条件电子邮件没有发送

Question

我想在表单提交时发送1封一般电子邮件和1封有条件的电子邮件(基于对特定问题的回答是"是"还是"否")。我对发送一般的电子邮件没有问题，但是当我在Google表单中选择"是"选项时，有条件的电子邮件不会发送。这是我到目前为止的代码(我还为sendEmail和sendConditionalEmail设置了相关的触发器)。任何建议都是感激的!

function sendEmail(e) {
var html = HtmlService.createTemplateFromFile("GeneralEmail.html");
var htmlText = html.evaluate().getContent();
var emailTo = e.response.getRespondentEmail();
Logger.log(emailTo);
var subjectofEmail = "TESTING INFORMATION (BRJ)";
var textBody = "This email requires HTML support";
var options = {htmlBody: htmlText};
if(emailTo !== undefined){
MailApp.sendEmail(emailTo, subjectofEmail, textBody, options);
} 
}
function sendConditionalEmail(e){
var Conditionalhtml = HtmlService.createTemplateFromFile("ConditionalEmail.html");
var ConditionalhtmlText = Conditionalhtml.evaluate().getContent();
var subjectOfEmail = "Guided Testing (BRJ)";
var textBody = "This email requires HTML support";
var interested = objectifyingFormforInterested();
var emailTo = e.response.getRespondentEmail();
Logger.log(interested);
if (interested == "Yes") {
MailApp.sendEmail( emailTo, subjectOfEmail,'', {
htmlBody: ConditionalhtmlText, 
cc: '[e-mail]'});
}
}
function objectifyingFormforInterested(myForm){
var myForm = FormApp.openById("13o_WK3G8m6PeopBrI2y6p6SrNp-cGFs3vgpRdqotISY");
var formResponses = myForm.getResponses();
Logger.log(formResponses);
var currentResponse = formResponses[formResponses.length-1];
var responseArray = currentResponse.getItemResponses();
Logger.log(responseArray);
var form= {};
form.user = currentResponse.getRespondentEmail();
form.timestamp = currentResponse.getTimestamp();
form.formName = myForm.getTitle();
var response = responseArray[responseArray.length-1].getResponse();
Logger.log(response);
return response;
}
function camelize(str) {
str = str.replace(/[.,-/#!$%^&*;:{}=-_`~()@+?><[]+]/g, '')
return str.replace(/(?:^w|[A-Z]|bw|s+)/g, function(match, index) {
if (+match === 0) return ""; // or if (/s+/.test(match)) for white spaces
return index == 0 ? match.toLowerCase() : match.toUpperCase();
});
}

Answer 1

地址下面的评论，也许你可以让它正常工作

function sendConditionalEmail(e) {
var Conditionalhtml = HtmlService.createTemplateFromFile("ConditionalEmail.html");
var ConditionalhtmlText = Conditionalhtml.evaluate().getContent();
var subjectOfEmail = "Guided Testing (BRJ)"
var interested = objectifyingFormforInterested();//You are not passing the MyForm parameter to this function
var emailTo = e.response.getRespondentEmail();
if (interested == "Yes") {
MailApp.sendEmail(emailTo, subjectOfEmail, null, {
htmlBody: ConditionalhtmlText,
cc: '[e-mail]'
});
}
}
function objectifyingFormforInterested(myForm) {
var myForm = FormApp.openById("13o_WK3G8m6PeopBrI2y6p6SrNp-cGFs3vgpRdqotISY");
var formResponses = myForm.getResponses();
var currentResponse = formResponses[formResponses.length - 1];
var responseArray = currentResponse.getItemResponses();
var form = {};
form.user = currentResponse.getRespondentEmail();
form.timestamp = currentResponse.getTimestamp();
form.formName = myForm.getTitle();
var response = responseArray[responseArray.length - 1].getResponse();
return response;
}