I’d like to keep tracks of changes made by users in a table
I have tried to use ChangeCounter linked to a Workflow and separately a Workflow set to ALL_CHANGES and adding a new row to a sheet called Changes.
But neither are really successful as I don’t really know which column has changed and what it is was changed from.
The only was I can see to do this is to use a ChangeCounter set to each column and check them all individually.
Is there a better solution I haven’t found yet?
Many thanks for your assistance
Aleksi
February 3, 2020, 9:50am
2
If you don’t have lot of data to follow, you could create a log column and save older updated column’s values there.
Steve
February 3, 2020, 1:38pm
3
The best I’ve been able to come up with is just keeping a copy of every row as it’s changed: use a workflow to, on any change, copy the row (or just critical columns) to the audit table. The audit table will then always have both the historic and current values.
1 Like
Many thanks both of you.
I think I’ll look at copying over critical columns
Thank you both
1 Like