The onEdit
function is designed to capture and log editing activities in a Google Sheets document. It creates an "Edit Log" sheet to record details such as timestamps, user information, cell location, and old and new values after an edit occurs in the linked spreadsheet.
- Function Invocation:
- The function is automatically triggered upon any edit made within the associated Google Sheets document.