我如何获得“批准”，“拒绝”的超链接？使用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屋！