我一直在尝试按照此处所述整理一个确认脚本：http://alamoxie.com/blog/tech-tips/sending-confirmation-emails-google-docs-form/ http://alamoxie.com/blog/tech-tips/sending-confirmation-emails-google-docs-form/
但我总是收到此错误代码：
TypeError: Cannot read property "values" from undefined. (line 5, file "Confirmation Email")
标准确认书上的脚本的目的是提供一种易于阅读和打印的表格，该表格仅占用一页且仅包含相关信息，而不是标准确认书的 12 页。
在本例中，我使用它来创建食品订单。请求者可以选择他们想要的活动项目，提交它，然后电子邮件确认将发送给管理员，该确认邮件可以打印并交给厨房提取。我已经成功制作了邮件合并类型文档，但它发送了列表中所有内容的确认，而我想要的只是输入的最新行（因此是确认脚本）。
这是我的代码：
function onFormSubmit(e) {
// First establish the variables. Name each variable by the e.values (column number in the spreadsheet).
var timeStamp = e.values[0];
var Activity = e.values[2];
var pickUp = e.values[3];
var pickUptime = e.values[4];
var nPeople = e.values[5];
var submitUser = e.values[6];
var Equipment = e.values[7];
var Drinks = e.values[8];
var Breakfast = e.values[9];
var Lunch = e.values[10];
var Dinner = e.values[11];
var eveningProgram = e.values[12];
var Event = e.values[13];
var Snacks = e.values[14];
var Notes = e.values[15];
var userEmail = e.values[17];
// These are the components of the email confirmation
var emailTo = userEmail;
var CCAddr = "[email protected] /cdn-cgi/l/email-protection";
var subject = "Food Order Request";
var emailBody = "Food Order Requisition\n\n" +
"Pick up Date:" + pickUp +
"\nPick up Time:" + pickUptime +
"\nSubmitted by:" + submitUser +
"\nDate Submitted:" + timeStamp +
"\n\nActivity:" + Activity +
"\nPeople:" + nPeople +
"\nMeal:" +Event +
"\nThe following is needed for" + Activity + "by" + submitUser + "who can be reached at" + userEmail +
"\n\nEquipment and Supplies:\n" + Equipment +
"\n\nDrinks:\n" + Drinks +
"\n\nSnacks:\n" + Snacks +
"\n\nBreakfast:\n" + Breakfast +
"\n\nLunch:\n" + Lunch +
"\n\nDinner:\n" + Dinner +
"\n\nEvening Program/Special Events:\n" + eveningProgram +
"\n\nThe following special notes were also requested:\n" + Notes +
"\n\nProcessed by:___________________ Processed Date & Time:_________________________Food Order Requisition";
/**
* Un-comment this to use it for debugging
*/
// for (var i in e.values) {
// Logger.log("" + i + ":" + e.values[i]);
// }
MailApp.sendEmail(emailTo, subject, emailBody);
}
问题是它告诉我我的值未定义，我不明白为什么......任何人都可以帮忙解决这个问题吗？
该脚本无法从脚本编辑器执行，只有在表单提交触发时才有效，就是这样e(事件信息)获取其参数。如果从脚本编辑器启动，事件信息为undefined，这是合乎逻辑的，因为没有发生任何事件。
所以你应该通过发送表格来测试它。
编辑：你必须创建一个onFormSubmit trigger使脚本在提交表单时运行：请参阅此处的文档 https://developers.google.com/apps-script/understanding_triggers并且here https://developers.google.com/apps-script/understanding_events
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
