Send a report with changes only

[Kamalov]

Hi,

I am sure there is a way to do this but I am not 100% sure. From looking into it i found this thread Track all changes? - #17 by Colin_Lough. I was hoping there is a simpler way.

Is there a way for an admin to get a report when a change is made to the data on google sheets via the app. It could be a daily report or anytime a change is made.

[Marc_Dillon]

[_THISROW_BEFORE] / [_THISROW_AFTER] Template Generator Tips & Tricks 💡

Good idea! You could set up a separate table (or app) to store an archive of changes, and only log the fields that were updated, along with the timestamp and USEREMAIL(). That would give you a full history of changes, without storing a full copy of the row every time. Another option would be to add a [Last Edit] column to the same table, and save the template result back to the row using an Action. Then each row could store a snapshot of the last time it was edited.