Google应用程序脚本 - onChange或OnEdit [英] Google Application Script - onChange or OnEdit

问题描述

我有一个google应用程序脚本，可以在电子表格中的onLoad事件中更改A1中的值。这触发了一连串的变化。当我们说单元格F200由于编辑单元格A1而发生更改时，我想要检测该事件。如何设置触发器来检测这种变化？

I have a google application script that changes a value in A1 in onLoad event in a spreadsheet. This triggers a cascade of changes. I would like to detect the event when let's say cell F200 is changed because of the edit to cell A1. How do I set up the triggers to detect this change?

推荐答案

当用户打开电子表格，文档，或者他或她有权编辑的表格。
当用户修改电子表格中的值时，将会运行可安装的编辑触发器。
当用户修改电子表格结构时，可以安装更改触发器 - 例如，通过添加新工作表或删除列。
可安装的表单提交触发器当用户回复表单时运行。表单提交触发器有两个版本，一个用于Google表单本身，另一个用于表单，如果表单提交到电子表格。

An installable open trigger runs when a user opens a spreadsheet, document, or form that he or she has permission to edit. An installable edit trigger runs when a user modifies a value in a spreadsheet. An installable change trigger runs when a user modifies the structure of a spreadsheet itself — for example, by adding a new sheet or removing a column. An installable form-submit trigger runs when a user responds to a form. There are two versions of the form-submit trigger, one for Google Forms itself and one for Sheets if the form submits to a spreadsheet.

这篇关于Google应用程序脚本 - onChange或OnEdit的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！