Follow

SmartLists with blank fields

You can create SmartLists based on blank values in specific fields. Below are two examples.

To create a SmartList of donors that live in a specific City who do not have an email address

  • Create a New SmartList and select Donors.
  • From the criteria category dropdown list select Address Info> City Check the city for the donors and then Next. You will have a list of all donors from that city
  • Click on the Don't Show tab and select Add Criteria Set to further define your list.
  • From the criteria category dropdown list, select Phone/Email Info>Partial Email Type *@* in the search text box and click Ok. Because all email addresses contain the @ symbol in the address, you can use this single critical character to search for email addresses. Donors without email addresses, and therefore the @, will now be listed

To create a SmartList of Donors where the organization does not have a contact person listed

  • Create a New SmartList and select Donors.
  • From the criteria category dropdown list select Personal Info>Organization Next click on Refine and select Personal Info>Partial First Name and leave the search text box blank.
  • Click Refine again and select Personal Info>Partial Last Name and leave the search text box blank. Organizations which have missing or partial missing contact information will be listed now
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk