google-apps-script - 无论输入的值如何，e.values 都返回相同的值

Question

我的组织正在为产品订单建立一个队列系统。谷歌脚本应该发送确认订单的自动电子邮件响应，但无法正确提取电子邮件地址。'var userEmail = e.values[x]' 返回相同的数组值，而与 x 的值无关。

我已经检查了所有相关变量并确保正确设置了可安装触发器。Google 脚本会自动从 onFormSubmit 触发器中提取数组值。另一个组织成功地实现了相同的代码，该组织慷慨地捐赠了代码供我们使用，但在翻译过程中丢失了一些东西。

            var userEmail = e.values[3];
            MailApp.sendEmail(userEmail,
                        "unBound 3D Print #" + lastRow,
                        "Thanks for submitting your 3D print job. \n\nWe'll start " +
                        "working on it as soon as possible. You are currently " +
                        "number " +
                        (lastRow) + " in the queue. \n\nunBound Staff.",
                        {name:"unBound"});

据我了解， e.values 应该将相关答案返回到适当编号的表单问题。在这种情况下，e.values[0] 应该返回第一个问题的答案，即用户提交的电子邮件地址。相反，输入的任何值都会返回第二个问题的答案，即用户的名字，这显然不能用于发送电子邮件。

编辑：按要求记录。以下是 e.values[x] 分别在值为 3、2 和 1 时的返回值。

D {"values":["1/9/2019 15:49:29","[e-mail]","Last","First","Ultimaker 3","File","Orange","0","0","https://drive.google.com/open?id=1NiOj10b002CeSMg6248f2e8yCNprhIN-",""],"namedValues":{"Status":[""],"Est. Weight Grams":["0"],"Print Time (Minutes)":["0"],"Upload File (.stl please)":["https://drive.google.com/open?id=1NiOj10b002CeSMg6248f2e8yCNprhIN-"],"Preferred Printer":["Ultimaker 3"],"Color":["Orange"],"First Name":["First"],"File Name":["File"],"Last Name":["Last"],"Timestamp":["1/9/2019 15:49:29"],"Email Address":["[e-mail]"]},"range":{"columnStart":1,"rowStart":2,"rowEnd":2,"columnEnd":10},"source":{},"authMode":{},"triggerUid":"299378"}

E Invalid email: First at onFormSubmit(Code:53)

D {"values":["1/9/2019 15:50:10","[e-mail]","Last","First","Ultimaker 3","File","Orange","0","0","https://drive.google.com/open?id=1GeyYfqEqJNiEYUVqqDULZs0S7H6U6kUz",""],"namedValues":{"Status":[""],"Est. Weight Grams":["0"],"Print Time (Minutes)":["0"],"Upload File (.stl please)":["https://drive.google.com/open?id=1GeyYfqEqJNiEYUVqqDULZs0S7H6U6kUz"],"Preferred Printer":["Ultimaker 3"],"Color":["Orange"],"First Name":["First"],"File Name":["File"],"Last Name":["Last"],"Timestamp":["1/9/2019 15:50:10"],"Email Address":["[e-mail]"]},"range":{"columnStart":1,"rowStart":2,"rowEnd":2,"columnEnd":10},"source":{},"authMode":{},"triggerUid":"299378"}

E Invalid email: First at onFormSubmit(Code:53)

D {"values":["1/9/2019 15:50:49","[e-mail]","Last","First","Ultimaker 3","File","Orange","0","0","https://drive.google.com/open?id=10XLYK11UGuWtTppYDAyBeAU79jz5CRN8",""],"namedValues":{"Status":[""],"Est. Weight Grams":["0"],"Print Time (Minutes)":["0"],"Upload File (.stl please)":["https://drive.google.com/open?>id=10XLYK11UGuWtTppYDAyBeAU79jz5CRN8"],"Preferred Printer":["Ultimaker 3"],"Color":["Orange"],"First Name":["First"],"File Name":["File"],"Last Name":["Last"],"Timestamp":["1/9/2019 15:50:49"],"Email Address":["[e-mail]"]},"range":{"columnStart":1,"rowStart":2,"rowEnd":2,"columnEnd":10},"source":{},"authMode":{},"triggerUid":"299378"}

E Invalid email: First at onFormSubmit(Code:53)

标签： google-apps-scriptgoogle-sheetsgoogle-forms