> For the complete documentation index, see [llms.txt](https://lochiwei.gitbook.io/web/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://lochiwei.gitbook.io/web/appendix/gas/examples/event-onedit.md).

# event: onEdit

{% tabs %}
{% tab title="💾 程式" %}

```javascript
/**
 * onOpen()
 */
function onOpen() {
  // app UI
  var ui = SpreadsheetApp.getUi();
  
  // ♥ 自製工具
  ui.createMenu('🧰 工具箱')
    .addItem('❶ 原始報表 ➠ 生成資料', 'init')        
    .addToUi();
}

/**
 * onEdit(e)
 * triggered when editing the spreadsheet.
 * @param {Event} e The onEdit event.
 */
function onEdit(e) {

  // ⭐️ edited cell
  var range = e.range;
  let rngGrade = App.range.byName('Grade');

  // 不是「高一、高二、高三」那一格，就請回。
  if (!App.isSameRange(range, rngGrade)) return;
  App.updateCurrentClasses();
}
```

{% endtab %}

{% tab title="📘 手冊" %}

* [Events](https://developers.google.com/apps-script/guides/triggers/events?hl=en)
  {% endtab %}

{% tab title="👥 相關" %}

* [app menu](/web/appendix/gas/app/app-menu.md)
  {% endtab %}
  {% endtabs %}