Does anyone know how to create an automation whereby any change made to a table with multiple columns gets pushed to a slack channel? Alternatively into a changelog table?
For example, if one of the cells changes from reading “apples” to “oranges,” I’d like a slack message that notifies me of that change (or a table that documents the change) for that row.
Hi @Grace_Lee and welcome to the community!
Are you looking for a simple notification that tells you the row was changed so you can look at the activity on the row or get a message that includes the previous & changed to value like:
The rows names was changed from "Apples" to "Oranges"
Since slacking/recording is straight forward and there’s tons of posts/how to’s around that I’ll assume you want to include the previous value in the slack & change log.
I don’t believe Coda gives you the ability to access the rows previous values in an automation. So you’d have to hack it. Here’s one solution.
Here’s a doc with a quick example that does this for the 1 column
Now if you want to do multiple columns thats were it gets a little tricky but can be done. Happy to elaborate here if needed.
But having a full change log can easily grow out of control depending on how often things are changing. So you should be selective of how to leverage it and what to log as a change. If you don’t need the change log as part of other doc functionality it maybe better to keep the change log lite and leverage table row “Activity” history to see the changes to each column. Just open the row, click on activity
Hidden gem!! I was not aware of this, EXTREMELY handy.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
