How do you set up a custom event to trigger when a cell value exceeds a set tolerance?
Hi all,
I have a workflow which is currently producing the below output:
I'd like to set up an automation whereby an email is automatically sent out once the value exceeds 100. Can anyone provide guidance on the best way to do this? I've had a flick through other Community posts and it appears that the best option would be to use the Custom Event/Fire Event process but I'm not too sure on the correct way to set it up.
Thanks
Pete
Tagged:
0
Answers
Hi Pete
Hi Josh,
Thanks for the reply. Finding some of the info around the Fire Event & Custom Event difficult to follow:
Have you got any pointers on the above?
Thanks
Pete
Sounds like you have set up everything correctly. Yes you need a Parameter to assign a value to (desc can be anything or null)
On the Fire event step you want to set the parameter to equal the First column value 'Exceeds Tolerance'
Thanks Josh have slightly amended the Fire Event in line with the above but still don't seem to be receiving the email alert from the automation. Can you see anything wrong with the below?
issue is probably that True and true do not match somewhere
can go back and make the Transform step return something other than true, like 'OVER100'
before that you can test the automation: 1) (temporarily) remove the filter TOLERANCE_LEVEL = True 2) add '@TOLERANCE_LEVEL' to the email content (so you can see the exact value being set) 3) run the workflow (without the filter so it definitely gets sent)