I am coming accross a challange with having a column to display when “column 1” has been modified.
When “column 1” has been manually updated the formula If([Column 1],[Column 1].Modified()+hours(10) ,"") will do the job (I am located in Sofia, Bulgaria, therefore I use the +hours(10) to get my timezone)
But now I am trying to find a solution to display when a COLUMN was modified as result of an update in a reference table. The value in “Column 1” is a result of the outcome of a calculation made with a formula.
You will make my day if we find a solution to this subject
I knot the reply is way delayed, but any chance you’d share a copy or example of the type of table relationship you have and what column you’d want to track for modification? Would love to see if I can help figure this one out!
The usecase for this specific demand to see when a column has been updated is like in the picture above, where we are interested to see when the status was updated.
The picture above is from “Airtable”, and I am aware that with the buttons that Coda has available, we can monitor when this button has been pushed to update the status and therefore the question above isn’t that relevant anymore.
Keep up with the great and unique developments that make Coda stand out
Open up the automations panel, using the robot icon on the right side of the toolbar
Create a new rule, that triggers when a row is changed in the table you want to watch, specifically when the thing changed was the “Status” column of that row
Then, you can do a few different types actions with your automation – notify you or other users, send an email or slack message with packs, create a new row somewhere else, or (in the image below) set a new column value for the last time the status was modified
