When the row changes and there are multiple users
This little challenge took me a bit more time than expected and so I thought if I have to think about it, maybe others will benefit from the solution as well.
The problem I faced was the following:
One or multiple users got added to a row to review a task. They should receive a notification automatically inviting them to have a look. It happens that over time new reviewers are added. These new reviewers need to receive a notification, those who already received a notification not.
It looks like a simple thing, but it was difficult:
- we need to feed the automation a filtered list containing only not yet notified reviewers.
- we need to skip the default and confusing coda notification settings
The solution in three steps
The first and simple part is the sending of the notification when the row changes, but not every column, only the reviewers
The second part is the configuration of the the notification logic. Here we have to skip the logic coda suggests. You…
