As an admin team we wish to be notified of any new mail loops. I was thinking it would be good to create a notification email if we receive a new ticket from the same customer over 10 times in one hour?
3 respostas
Ah yes, I didn't notice the last hour thing.
I would give this a try - Create a custom formula field on the object and call it something like Time since last update with an output type of Number wth 2 decimal places. The formula would be now()- YourCustomField. 60 minutes would be 1/24th of a day, or approximately .04. Then, your report would include Time since last update is less than .04 as its criteria.
Use more decimal places if you need more precision than this. Hope this helps.
