禁用我通过自己拥有的模板创建的Google表格文件副本的自动评论通知 [英] Disable auto comment notifications for copies of Google Sheet files I create from a template that I own

问题描述

我有一个模板Google Sheet文件和自动化程序，可以制作许多副本.

I have a template Google Sheet file and automation that makes numerous copies of.

现在，当有人在任何副本中发表评论时，我都会收到通知.

Right now, when someone makes a comment in any of the copies I get a notification.

当我的自动化程序从模板创建副本时，如何永久或以编程方式禁用该通知.

How can I disable that notification -- either permanently or programatically when my automation creates the copy from the template.

**编辑**

该问题已结束，表示需要更多详细信息.我不确定我还能提供什么其他细节.

This question was closed saying it needs more details. I'm not sure what other details I can provide.

我以某种方式自动获得对我拥有/复制/创建的Google Spreadsheet文件的评论通知的权限.我试图弄清楚如何以编程方式禁用该功能.我已经搜索了Google文档/帮助和社区，但找不到任何东西.有一些帮助文章，介绍了如何通过工具>配置电子表格的通知.通知，但这与我谈论的不是同一件事-再加上我从来没有以这种方式启用通知.

Somehow I am getting auto-subscribed to comment notifications for Google Spreadsheet files I own/copy/create. I am trying to figure out how to disable that programatically. I already searched Google documentation/help and the communities but can't find anything. There are help articles on how to configure notifications for Spreadsheets from Tools > Notifications but that is not the same thing I am talking about -- plus I never enabled notifications that way in the first place.

这些是我/我正在采取的步骤:

These are the steps I took/am taking:

1. 我创建了一个新的电子表格文件-模板
2. 我的自动化功能可以在有人提交Google表单时启动.自动化创建模板文件的副本(来自#1)

就是这样.现在，由于某种原因，无论何时有人在创建的任何副本中发表评论(在步骤2中)，我都会收到一封电子邮件，说有新评论.我要禁用的是电子邮件/通知.

That's it. And now, for some reason, whenever someone makes an comment in any of the copies created (in step #2), I am getting the email saying there is a new comment. It is that email/notification I am trying to disable.

**编辑2 **

这是我用来复制模板的代码:

Here is the code I am using to make copies of my template:

var template = DriveApp.getFileById("...file ID of a Google Sheet...");
var newFileDestination = DriveApp.getFolderById("...folder ID of destination folder...")
var newFile = template.makeCopy("new file name", newFileDestination)

但是，值得注意的是，如果您手动制作文件副本，也会自动订阅评论通知.

However, it is worth noting, that the auto-subscribe to comment notifications also happens if you manually make a copy of a file.

**编辑3 **

自动订阅新文件的注释/通知的问题可以手动复制:

The issue of auto-subscribe to comments/notifications for new files can be manually reproduced:

1. 创建一个全新的Google表格文件

1. Create a brand new Google Sheet file

将此新文件(#1)的评论通知设置为仅限您自己-请参阅管理您的评论通知"在 https://support.google .com/docs/answer/65129?guide = 1208624& visit_id = 637353849233956627-596889868& rd = 2

Set comment notifications for this new file (#1) to Only yours -- see "Manage your comment notifications" in https://support.google.com/docs/answer/65129?guide=1208624&visit_id=637353849233956627-596889868&rd=2 for how

创建新文件的副本(#1)-File > Make a copy

Create a copy of the new file (#1) - File > Make a copy

现在，如果您检查副本(#2)，您将看到评论通知返回到全部.

Now, if you check the copy (#2) you will see that comment notifications are back to All.

推荐答案

不幸的是，在回答此问题时，Apps Script中没有方法可以禁用文档中的注释通知.如果您想请求添加此功能，可以在此处提交功能请求.

Unfortunatelly, at the moment of this answer there is no method in Apps Script to dissable comment notifications in Documents. If you want to request this feature to be added, you can file a feature request here.

或者，您可以在电子表格中转到 Tools->通知规则，然后删除您可能拥有的规则.您也可以转到页面右上角的评论图标，然后将通知设置为无或只有你.

Alternatively, in your Spreadsheet you can head over to Tools-> Notification Rules and delete the ones you might have. You can also head to the comment icon in the top right of the page and set the notifications to None or Only you.

但是，由于新文件是通过从原始文件复制而创建的，因此它们可能会重置其设置，因此会继续发送评论通知.要避免在您的邮件收件箱中放入过多此类邮件，一种解决方法是设置标签和过滤器在您的Gmail帐户中进行处理(通过存档或删除).

However, as new files are created by copying from the original file they might get their settings reset and therefore keep sending the comment notifications. One workaround to avoid getting too many of these in your mail inbox is to set a label and filter in your Gmail account to handle these (either by archiving or deleting them).

我希望这对您有所帮助.让我知道您是否需要其他任何东西，或者您是否不了解某些内容. :)

I hope this has helped you. Let me know if you need anything else or if you did not understood something. :)

这篇关于禁用我通过自己拥有的模板创建的Google表格文件副本的自动评论通知的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！