Share
Explore

Notify on table

Tasks
0
Name
Person
Status
1
Join the resistance
EL
Ed Liveikis
Done
There are no rows in this table

Status
0
Name
People to Notify
1
Todo
2
Done
EL
Ed Liveikis
There are no rows in this table

Rule Automation
There is an automated rule in the doc names Send Status change notifications.
It triggers when the Status column of the table changes. The trigger condition puts the Row that changes into Step 1 Result:
image.png
It has a formula that then takes this result to lookup the Status table and send notifications to the people for that status. Alternatively, the Step 1 Result.Person could be sent the notification, if desired. This is the formula:
withName(
Status.Filter(CurrentValue = thisRow.[Step 1 Result].Status)
.First()
.[People to Notify],
_notify_list,
if(
isBlank(_notify_list),
_noop(),
_notify_list
.FormulaMap(
Notify(
CurrentValue,
format(
"Moved to {2}: {1}",
thisRow.[Step 1 Result].Name,
thisRow.[Step 1 Result].Status
)
)
)
)
)
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.