Google Sheets: onEdit Basics
ฝัง
- เผยแพร่เมื่อ 29 ก.ย. 2024
- Here I show some basics of using onEdit() triggers.
* onEdit() triggers are not meant to be manually run; rather, they automatically run whenever a user changes a value on the spreadsheet.
* An event object is typically passed to the function, typically called e, which contains information such as the range, source, oldValue, and value of the edit made.
* You cannot have multiple functions called onEdit() in the same script file (only the last one will be recognized). Rather, consolidate all conditionals and actions into a single function.
Resources:
Simple Triggers Documentation - developers.goo...
Event Objects Documentation - developers.goo...