Notification when case is reopened

Question

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?

QuickBaseCoachD · Answer

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

Sign up

Login to the community