提交Google表单后发送确认电子邮件

问题描述：

我已经查看了很多资源以找出我的脚本出了什么问题，但没有任何工作。我正在尝试在Google表单提交后发送确认电子邮件。好像我的脚本没有从表单中正确地调用电子邮件地址。
我原来的脚本来自http://acrl.ala.org/techconnect/?p=2343，我修改了我的表单。
这是它看起来像：提交Google表单后发送确认电子邮件

function swykemailconfirm(e) { 
    var userEmail = e.values[10]; //email from column K 
    var firstName = e.values[2]; //first name from column C 
    var lastName = e.values[1]; //last name from column B 
    var test = e.values[4]; //test name from column E 
MailApp.sendEmail(userEmail, 
        "Thank you " +firstName + lastName + "for signing up to take the " + test + "Show What You Know test. " + 
        "Make sure you see Ms. May to get your pass. " + 
        "See you on Thursday in room 32 at 3:30." + 
        "The Math Department"); 
}

我做一个测试表单提交后收到此错误消息的电子邮件：找不到方法（类）sendEmail（字符串，字符串）。（6号线，文件“守则”）

搜索这里Google Forms Confirmation Script一种方式来编辑我的剧本后，我用的建议之一，改变了我的代码如下：

function swykemailconfirm(e) { 
    var userEmail = e.values["E-mail"][0]; 
    var firstName = e.values[2]; 
    var lastName = e.values[1]; 
    var test = e.values[4]; 
MailApp.sendEmail(userEmail, 
        "Thank you " +firstName + lastName + "for signing up to take the " + test + "Show What You Know test. " + 
        "Make sure you see Ms. May to get your pass. " + 
        "See you on Thursday in room 32 at 3:30." + 
        "The Math Department"); 
}

我正在一个在提交测试表单后提交此错误消息的电子邮件： TypeError：无法从undefined读取属性“0”。（第2行，文件“代码”）

任何帮助非常感谢！

答

您的原始功能（上）可以通过一个小修改正常工作。因为sendEmail方法需要传递三个参数：收件人（字符串），因此Google Docs向您发送错误消息“无法找到方法（类）sendEmail（string，string）。（Line 6，file”Code“）。，主题（字符串），主体（字符串）。目前，您只传递两个参数：收件人和正文。查看文档here

将您的功能修改为以下内容，一切都应该工作！

function swykemailconfirm(e) { 
    var userEmail = e.values[10]; //email from column K 
    var firstName = e.values[2]; //first name from column C 
    var lastName = e.values[1]; //last name from column B 
    var test = e.values[4]; //test name from column E 
    MailApp.sendEmail(userEmail, 
     "Registration Confirmation Subject Line", 
     "Thank you " +firstName + lastName + "for signing up to take the " + test + "Show What You Know test. " + 
     "Make sure you see Ms. May to get your pass. " + 
     "See you on Thursday in room 32 at 3:30." + 
     "The Math Department"); 
}

希望有所帮助！

提交Google表单后发送确认电子邮件

相关推荐