Share
Explore

Notify on table

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

Status
0
Name
People to Notify
1
Todo
​
2
Done
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
Tasks
⁠
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.