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.