Notification when case is reopened

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
I have a status field that has several options. I want a notification to be sent when when the status changes from Closed to any other status. (Meaning case was reopened). What's the best way to do that?
Photo of Ashley Asante

Ashley Asante

  • 696 Points 500 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
I have not tested this but it might work.  Maybe you can try it and let us know.

Make a New field called [Status when saved]
Make another new field called [Old Status when saved]

Make a form rule that says

When the record is saved
 and [Status has changed]

Change [old status when saved] to the value in [Status when saved]
Change [Status when saved to the value in [Status]

Then trigger the email when  the status changes and 
after the record is saved
[Old status when saved] equals [Closed]
 and
[Status] is not equal Closed
Photo of Ashley Asante

Ashley Asante

  • 696 Points 500 badge 2x thumb
This works perfectly! 

Thank You 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
Great, thx for letting me know.