Is it possible to trigger an alert notification ONLY if the value of a field increases?

alcapps
alcapps ✭✭✭✭✭✭

I have a formula that counts absences for the past 6 months. A formula in another column looks at the first and when that number reaches 3, it adds an occurrence (value changes from 0 to 1). I've set up automation to notify the supervisor that the team member needs a counseling.

Since my only option for automated notifications is to trigger when that field changes, when the absences drop off (older than 6 months) the occurrence field drops by one which triggers an alert notification. I do not want this one to trigger a notification.

Best Answer

Answers

  • alcapps
    alcapps ✭✭✭✭✭✭

    Yes, that makes sense. i didn't think it could be done but wanted to be sure. This sure would be a nice enhancement :)

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help! 👍️


    Feel free to Submit a Product Enhancement Request when you are able.


    Additionally... If you would like more detail or help setting up the Update Request version, let me know.

    thinkspi.com

Help Article Resources