Save old value in another table

[daniil]

Good day!
I would like to find solution to save previous value.

Here is example
I try to save each changes made in Value table. It is easy to save new one with triggered automation, but how to save old value, that was before change?

[Federico_Stefanato]

Hi @daniil,

A common way would be to create an additional table (Logs, for instance) and save the record state at a specific timestamp (i.e. before every data change). this allows you to have multiple data changes without adding too many columns.

If you have only one value, it’s just a matter of creating two separate actions (RunActions(ModifyRows(...), ModifyRows(...))) in sequence where you first copy the old value, then you update the new one.

If it’s not clear, let me know and I’ll try to share an example.

[Jean_Pierre_Traets]

Dear @daniil

Next to the directions of @Federico_Stefanato, I recommend also to have a look at this post:

Capture `History` of changes / Create Log of changes to important value of record

Hi, At times, I feel like I want to preserve history of changes to important column in a record (while coda has built-in change tracking and you can see that inside Row Activities - it is hard to query that changes or create a log of all the changes. Here’s what I use in some of my documents and has worked out really well. Example use case here is: I have Projects and I want to make sure all changes to Project Cost for each project is captured as history. The steps are: create Projects Ta…