我如何获得“批准”,“拒绝”的超链接?使用Apps脚本在电子邮件中工作 [英] How can i get the hyperlink for "Approve", "Reject" work in Email using Apps Script
问题描述
问题:每次提交Google表单时,经理都要征得经理的批准,经理需要查看详细信息,然后单击批准或拒绝
Problem: Seeking approval from manager upon each google form submission, the manager need to review the details and clicking approve or reject
但是:我如何获得超链接对于批准,拒绝工作
BUT: how can i get the hyperlink for "approve", "reject" work
所需的解决方案:首选的Google Apps脚本,当响应者单击批准或提交时,应将响应保存到Google工作表中并发送第二封电子邮件进行第二层审批
Desired solution: preferable Google Apps Scripts, when respondent click approve or submit, should save the response into google sheet and send second email to second layer approval
尝试过:能够从Google表单中提取详细信息,但无法执行批准和拒绝按钮
Tried: Able to extract detail from google form, but not able to perform approval and rejection button
推荐答案
可能的工作流程如下:
- 使用表单提交触发器-适用于FormApp或(可选)适用于SpreadsheetApp-如果响应是自动存储的在目标工作表中
- 在onForm上触发将要发送给管理者的通知电子邮件
- 在通知电子邮件中添加两个链接-一个用于批准,一个用于拒绝
- 创建两个 WebApps -一个包含脚本的脚本,该脚本批准表单提交,将表单响应复制到Google工作表中,然后将电子邮件发送给第二级批准;第二个Web应用程序包含一个脚本,该脚本应在被拒绝的情况下运行(例如,向提交者发送有关拒绝的通知电子邮件)
- 使用Web应用程序URL作为批准和拒绝链接,通知邮件给经理
- Use the form submit trigger - either for FormApp or, optionally, for SpreadsheetApp - if the responses are automatically stored in a destination sheet
- Trigger onFormSubmit a notification email to be sent to the manager
- Implement into the the notification email two links - one for approval, one for rejection
- Create two WebApps - one that contains a script approving the form submission, copying the form response into a google sheet and sending emails to a second level approval; the second Web App contains a script that should be run in case of rejection (e.g. a notification email to the submitter about the rejection)
- Use the Web App URLs as approval and rejection links in the notification mails to the manager
我希望这些说明足够清楚并且对您有所帮助!
I hope those instructions are clear enough and helpful to you!
这篇关于我如何获得“批准”,“拒绝”的超链接?使用Apps脚本在电子邮件中工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!