I'd like some help trying to figure out a Saved Search.
We've got a Saved Search setup for a Custom Record and there is about 6 different Criteria Filter (which includes Expressions, some And's and some Or's). I'd like to be notified via email anytime a Custom Record either now meets this criteria, or does NOT meet the criteria any more. I've checked the "Send Email Alerts When Records are Created/Updated" box, but that does not seem to work since the Custom Record has already been created in most cases, but only now meets all the criteria because it has been modified and updated (by the user).
I also see no way to do the email when a record no longer meets all the criteria so it is "removed" from the Saved Search Results.
Any ideas?