How to calculate total of a grouped field
I have a table called Alerts. Each Alert has a 'type'. I'd like to calculate the # of Alerts by Type and when the # of any one alert type is greater than 10 trigger a notification. As a first s...
Forum Discussion
Or is an alternative that I do create the relationship and then just use the 'Related Type' field in Alerts as my entry field? That would save me from having to do the automation correct? instead they just lookup the type value, or if it doesnt exist they can use the 'Create new Type' option at the bottom of the dropdown. Ideally I don't want the user to have to do that extra step to create a new type but I think that gets me to where I need to be...