Table Changes - Seeing What Changed

[jeffs88keys]

I have a table (Sales) where my employees enter their sales.  Occasionally  they need to modify the information in the entry (deliver date, cost, etc).  

I already have a Triggered Action that saves the original entry to a separate table (Sales_History) to maintain record of the original entry.

What I'm trying to achieve is this.....how can I see what the exact change was in the entry.....meaning...which field was changed?  Is there a method to compare the record that is in the main table (Sales) to the one that was moved to the Sales History table?

Example:  Salesperson changes the cost of the item, but all other fields remain the same.  How can I auto determine that it was the price field that changed?

Thanks !!

[NiceDuck]

It is possible with a more complex triggered action. 

The workflow varies from time to time but the basic Idea is something like this: 

First, on the table where you are saving the logs, you will need to have an extra field that will specify which change occur.

Then, you will need a block like this for every single field:
 

I hope this helps.


 

[jeffs88keys]

13 hours ago, NiceDuck said:

It is possible with a more complex triggered action. 

The workflow varies from time to time but the basic Idea is something like this: 

First, on the table where you are saving the logs, you will need to have an extra field that will specify which change occur.

Then, you will need a block like this for every single field:
 

I hope this helps.


 

I can see this making sense.  I'll definitely give it a shot.  Thank you !!!