How to save only the columns that have changed to the history table.

Hi,

In order to keep a history of table changes, a change history table was created and a bot was created to post values to the change history table when changes are made to the original table.

With the current setup, if any of the columns are changed, the data in all the columns set in “With these values” is saved, but I would like to save the history of only the columns whose values have changed, because it is difficult to understand if data that has not changed is also posted.

What is the best way to do this?

IF([_ThisRow_Before].[Column] = [_ThisRow_After].[Column], “”, [Column])

2 Likes

I see!
Thank you very much.

1 Like