问题描述
我希望根据工作表上的用户输入来调用UrlFetchApp.fetch()，但是什么也没有发生.没有错误，只是默默地忽略了呼叫. MailApp.sendEmail()和GmailApp.sendEmail()
I'm looking to call UrlFetchApp.fetch() based on user input on a sheet but nothing happens. No errors, just silently ignores the call. Same goes for MailApp.sendEmail() and GmailApp.sendEmail()
这是在Google Apps域上，只有域用户在使用Google表格.
This is on a Google Apps domain, and only domain users are using the Google Sheet.
推荐答案
像onOpen或onEdit这样的简单触发器无法执行任何需要授权的操作，例如发送邮件，因为它们以静默方式匿名运行.所有这些都在文档中进行解释.
Simple triggers like onOpen or onEdit are not able to do anything that requires authorization like sending mails because they run silently and anonymously.This is all explained in the documentation .
您应该简单地将onEdit函数重命名为其他名称-例如SpecialOnEdit? -并从脚本编辑器菜单中创建一个可安装的触发器(文档)(资源/触发器/创建新触发器...)
You should simply rename your onEdit function to something else - SpecialOnEdit for example ? - and create an installable trigger (documentation) from the script editor menu (ressources/triggers/create a new trigger...)
这篇关于某些方法/功能根本无法在onEdit触发器中使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！