Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
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
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