This lesson looks at how to create a Change History Log on a Google Sheet with Google Apps Script Code. The lesson illustrates how to do the following with the Script:
1. Log the Cell Reference that was changed
2. Log the User who made the change
3. Log the Date and Time When the Edit was made
4. Log the Old (Previous) Value and the New Value of the Cell(s)
Learn more about Google Apps Script with this Beginner's Guide Book at Amazon.
https://amzn.to/3MMvDZs
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via this link below
#GoogleAppsScriptAddChangeHistoryLog
#GoogleAppsScriptCreateChangeHistoryLog