Log updates to a separate table

[Johnny_Ung]

Hi,
I’m trying to create an equipment tracking system. When users update a row on a table, id like that whole row copied over to our logging table. Can anyone help me figure out what formulas to add to each column? The columns are various types (buttons, text, selections, etc). Each time a person edits something on the row, i’d like the whole row copied over to a “logging” table.

thanks
johnny.

[Paul_Danyliuk]

Hey, and welcome!

I think you can achieve this with automations.

Add a rule for “Row changed” on your table (leave column non-selected) and make it add a row to your logging table with the data from that changed row (available via Step 1 Result variable). If your logging table has the same structure as the original table, you’ll have to specify all columns and assignments separately in your rule (in the “set values” section).

[Krunal_Sheth]

Welcome to the community @Johnny_Ung. Aside from using automations as @Paul_Danyliuk mentioned , here are few related articles that could help if you dont want to go automation route. (for most part automations are instant, but in some odd cases, it could be delayed)

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…

How to create a set of records every time a new record is created in table

Hope this helps to members looking for solution to similar problems.

[Johnny_Ung]

Automations was what i was looking for. thanks!