Hello,
I'm trying to filter my Salesforce contact records based on whether the preferred email that they have listed is blank. So for example, if a contact lists their personal email as a preferred email, I want it to filter only records where the personal email is blank. Also, I'd want to grab one of the listed emails if the "Email" field is blank. So for example, I'd want to see records in which the "Email" field is blank, but at least one of the email fields (Personal Email, Alternate Email, etc) is populated. Are either of these scenarios possible? If so, how would I go about these?
