Share
Explore

icon picker
Coda Template Notifications

Use an automation to send a notification only once

Challenge

Sending only one notification per user on row change. The row changes more than once.

Details

When you add a new review role, only the new added person should receive a notification, not every reviewer.
It is a difficult solution because you have use an automation that uses a filtered list (a sub set of all reviewers) and you have to see that you better ignore the default coda settings because they are confusing.

Solution in 3 steps:

Automation based on row change in column reviewRoles
Automation using the users in reviewUsers
Automation adding notified people to column notifiedPeople via ModifyRows()
DB Review
0
1
2
3
reviewRoles
reviewUsers
projectName
notifiedPeople
2 Coda wizard
3 Coda expert
Christiaan Huizer
Project 1
Coda Experts
2 Coda wizard
3 Coda expert
[  ]
Project 3
Christiaan Huizer
Coda Experts
1 Data Master
2 Coda wizard
Rickard Abraham
Project 4
Christiaan Huizer
There are no rows in this table
DB People
0
1
2
3
Name
roles
people
1 Data Master
Data Master
Rickard Abraham
2 Coda wizard
Coda wizard
Christiaan Huizer
3 Coda expert
Coda expert
Coda Experts
There are no rows in this table


All details in my blog:


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.