Notifications Based on the Result of a Formula

A notification based on the result of a formula triggers from a calculated result. The formula result is calculated every time your data source gets a new registration or updates an existing one. You can add filters and make your notification trigger when the formula result matches a defined value or a target.

1. Go to Gamification > Notifications > + New notification.
2. Name your notification.
3. Select Send notifications based on > The result of a formula.
4. Select the formula that should trigger the notification.

If you add a filter to the notification, the notification will only trigger when the formula result meets the filter conditions. Here are some filtering examples:

• The number of won opportunities reaches 30 or more (formula result > 29)
• The number of outbound calls is 50 (formula result = 50)
• Your revenue passes 10 000 (formula result > 9999)
• The number of open support tickets is 10 or less (formula result < 11)

You can choose to add one or multiple filters to create precise conditions for when the notification should trigger. You can also use filters as your targets.

Available filtering functions

• equal to (=)
• not equal to (!=)
• less than (<)
• greater than (>)
• changed by

Changed by

The "changed by" function allows you to keep track of the changes in your formula result. It calculates the difference between the existing and the new result of your formula.

For example, your formula shows that the current sum of sales is 5000. If you add a filter Formula result changed by 1000, the notification will trigger whenever the formula result is increased or lowered by 1000 or more. Here's how it works:

• The new formula result is 6000 (or more): The notification will trigger.
• The new formula result is 4000 (or less): The notification will trigger.
• The new formula result is 5300: The notification will not trigger because the value hasn't changed by 1000 or more.

You can limit how often the notification triggers once the conditions are met. The notification will trigger from the first time your formula result gets updated (no filters added) or when it meets the filter conditions (a filter is added).

The limit will apply in accordance with the option you've chosen under Compare to formula result. If your Compare to formula result is set to For each selected team and you limit the notification to Once per day, the notification will trigger once a day for each of the selected teams separately.

Plecto will look for notification triggers starting from this date and time. It automatically adds the date and time in this field, which is the moment you have created the notification. Therefore, make sure to adjust these if necessary.

For example, if you enable the notification from the 1st of January 2022, all formula results detected on or after the 1st of January can trigger the notification. This allows you to make sure that updates in older registrations do not trigger the notification.

When setting up a formula-based notification, you can select how to compare the formula result. The main difference is whether the formula looks at the results for each team and employee together or separately.

• For each employee on the selected teams: The notification will trigger for each employee individually. In this field, you need to add all the teams whose members should trigger the notification. Sub-teams will not trigger the notification if only the parent teams are added.
• For each selected team: The notification will trigger for each team separately. If the result of either of the teams matches the filter condition, the notification will trigger for those teams. Once again, make sure to add all the teams to the notification because sub-teams will not trigger the notification if only the parent teams are added.
• For all selected teams combined: Plecto will calculate the formula result for all teams together. Once the total result matches the filter criteria, the notification will trigger. It's enough to add the parent teams here – the sub-teams will trigger the notification even if they aren't added.
• For each selected employee: This option allows you to add specific employees to the notification. If you deactivate an employee profile, Plecto will automatically remove the employee from the notification. However, if you reactivate the employee profile, you need to add the employee back to the notification manually.

Plecto allows you to select from a variety of notification actions - choose one or combine several - it's up to you! These are the currently available notification actions:

To add an action, click on one of the action boxes. Each action has different fields and settings that you need to fill out. Once you have set up the notification actions, all you have to do is click "Save" in the bottom right.