Is there a way I'm missing to have a Saved Search ...
# general
r
Is there a way I'm missing to have a Saved Search fire off an email only if the result set is blank? I know there's a Send If No Results checkbox, but I would need basically the opposite functionality, ie Send ONLY if No Results.
t
That's interesting. Commenting to follow thread.
w
I think you'd have to script that
t
Could you flip the criteria around in the saved search that it would only show the results you needed?
r
That's a good idea @Tim Chapman, but I don't think so. This search is looking for the absence of something, which is tricky. Basically our integration that's sending certain records into the system sometimes doesn't run...but not because of some error...it just doesn't run. So there's no error message from it since it doesn't run. Annoying. Anyway, while we try to fix that, I just set up a search that shows the results of records created from that process and fires off an email with the records; it's not that many per day, but they're critical. There's no partial successes, the integration either imports all the records or none of them, so basically I (and some others on my team) just glance at the email from the Saved Search to see if there are records in it. If so, great. If not, we have to go manually run the process. There's a couple integrations this is happening on so the emails are getting a little busy. Ideally the saved search would just fire off the email if we get no results.
t
I see, that seems like a huge thing to keep up on constantly. I hope you find something that works for you.