I’m trying to create a notification to get the user to take an action.
I have Parent Table: Commitments, and Child Table: Weekly Actions
I want to first check the Child table to see if any records with a particular status exist and if not send a notification.
I have two approaches in mind creating a virtual column that:
a. counts records in the Weekly Actions table with a status of 2. In Progress
b. uses a yes/no expression to evaluate if there are any matching child records with the 2. In progress status
I would then create a notification workflow that checks the value of the virtual column. If the value is a. 0 or b. FALSE it would trigger the notification
Here is the expression I’ve used for Option B:
2. In Progress,
[_THISROW].[Plan ID] = [Commitment]),
I get a notice that this could be costly in terms of app sync time. Is there a better approach?