Explore

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

DB Review

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

DB People

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.