I wanted to share a simple way to use Table Aggregations in the if statement within your Triggers. in this example, we’ll look at the number of open Work Orders Table and display this in a simple message that changes if there are more than 1 open work orders. using this simple logic, you can enable a lot of advanced workflows in your Apps!!
the logic is as follows: if # of open work orders >= 2, then show: “there are x open work orders”. else show: “there is 1 open work order”.
here’s our Table:
that has the following Table Query to Filter for Open Work Orders (Complete = No) and a simple Count Aggregation:
from our App, we can now link the Query:
and display the Table Aggregation in our App:
last thing that’s left to do is add a Button to check the value of the Table Aggregation:
and now, you can see the Message changes depending on the number of Open Work Orders:
of course, this is a simple demo to display the functionality of using Aggregations in Triggers, but there is a lot of functionality that can be built into your Apps using this logic!!
let us know if you have any questions!!