I’ve got a table that includes a column of “Team Members” on a project. I want to open this column up to editing by the managers of teams, but want to track the changes.
I want to be able to see the “diff” of the changes, and am having trouble thinking through the most user friendly way to do this. I wanted to use Automation, but I’m not sure there’s a “Historical” option. One thing I was considering was:
- Create column that is called “Historical record of people”
- Create automation that runs when “Team Members” column is changed
- When automation runs, it captures what the new “Team Members” is, writes that to a new table, along with the historical record column, then it updates the historical record column to match the new team members, effectively giving me a “diff”
Is there a better way to do this? To capture diffs throughout any column without needing a log column?