English 中文(简体)
表单Emailer 脚本错误消息
原标题:FormEmailer Script Error Message

I have been using the FormEmailer script written by Henrique Abreu. It is an amazing program & I am so glad to have found it. I have one issue that has confounded me though. When I process the lines manually, it works perfectly, however, when I want to use the form submit trigger, I get an error message & it doesn’t work. This is the message: onEdit TypeError: Cannot call method "getSheetByName" of undefined. (line 198) formSubmit I am stumped, any help, or suggestions would be greatly appreciated! Thanks in advance, Michael

最佳回答

您如何设置/ 运行“ 窗体提交书”? 从您的描述来看, 您似乎正在试图直接从代码编辑器中运行它, 您是吗? 如果不是, 那么您正在获取的错误信息会在您的电子邮件中, 对不对?

总之,要运行的正确函数是 timeDriven 。 您应该打开脚本编辑器, 单击“ 资源” 菜单并设定启动程序。 当我写本版本时, 没有 < a href=> http://code.google. com/ p/google- apps- statim- issues/ issues/ detail?id=202" rel=“ nofol=nfoln noferrr" > "noolgle- apps- statimes/issues/ detail? id=128" 。 因此, 我们唯一的安全解决方案是使用时间驱动的触发器, 我建议您使用这个选项。 但是, 如果您的形式使用率有点低, 也就是说, 两个或更多用户几乎不可能同时提交数据 。 那么您可以使用 < imgrequestate > 。

顺便说一下,我不确定Stackoverflow是问有关

问题回答

暂无回答




相关问题
How to use year counter google app script?

I need an urgent help i have data as follows in a google sheet i need to add a year counter to the column d as follows using google apps script

What is the daily email limit in Google Apps Script?

Can someone tell me if there is a webpage that lists the official Google limit (Quotas) on emails sent from a Google Apps Script? In testing my little script I got an error: Service invoked too many ...

Reference Error for property of Javascript Object

I have built an object in Javascript on the Google Apps Script engine and every time I run my script I get a reference error saying uName is not defined. Here is the relivant code: function DataSet()...

Run Google Apps Script on Google-Spreadsheet event?

If I create a Google apps script, can I hook it up to Google spreadsheet to run based on an event, or must I manually invoke it? I don t know if Google Sheets supports any events. For example: a ...

Google gadget/spreadsheet: Grab spreadsheet key for gadget

So I m working on a google gadget(really only gadgetizing so I can get a datastore for this) that I want to be embeddable in a google spreadsheet (after this point, I m going to skip the word google - ...

热门标签