Answers.Body: <p>Welcome to CiviCRM SE, Daryl. If you have a current version you could use CiviCRM's new(ish) Search Kit to achieve that. Navigate to <strong>Search menu » Search Kit</strong> or /civicrm/admin/search#/list?tab=custom and create a search like in the screenshot:</p>
  <p><a href="https://i.sstatic.net/bEIBc.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/bEIBc.png" alt="Search Kit search for contacts without primary e-mail" /></a></p>
  <p>Add all your other search criteria using the search kit's UI and hit search. Then select all found contacts and choose export from the action menu. You could also utilize the &quot;Search Builder&quot; (<strong>Search menu » Search Builder</strong> or /civicrm/contact/search/builder?reset=1) to do so but i would recommend the search kit as the search builder may soon be deprecated / replaced by the search kit.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-07T12:37:10.947Z
Answers.Text: I have the same need. In order to avoid having to build and maintain too many Searches, I'd rather have one Search, and then an affrom to filter results. But I can't find a way to search if a field is empty in a FormBuilder+SearchForm
Answers.UserDisplayName: stackexchange user
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-09-13T09:31:40.293Z
Answers.LastActivityDate: 2022-09-14T12:19:58.263Z
Answers.LastEditDate: 2022-09-14T12:19:58.263Z
Answers.UserDisplayName: Fabian
Body: <p>I'm trying to eliminate records that do not have a mailing address from a list I want to export.  So, how do I do a search to eliminate records in which the city field is blank?</p>
  
Tags: <search>
Title: How do I eliminate records in which a specific field is blank in a search?
ThreadText: # How do I eliminate records in which a specific field is blank in a search?
  
  (Asked by: username_0 on 2022-09-12)
  
  I'm trying to eliminate records that do not have a mailing address from a list I want to export. So, how do I do a search to eliminate records in which the city field is blank?
  
  **Tags:** search
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-09-13. Score: 3
  
  Welcome to CiviCRM SE, username_0. If you have a current version you could use CiviCRM's new(ish) Search Kit to achieve that. Navigate to **Search menu » Search Kit** or /civicrm/admin/search#/list?tab=custom and create a search like in the screenshot:
  
  [![Search Kit search for contacts without primary e-mail](https://i.sstatic.net/bEIBc.png)](https://i.sstatic.net/bEIBc.png)
  
  Add all your other search criteria using the search kit's UI and hit search. Then select all found contacts and choose export from the action menu. You could also utilize the "Search Builder" (**Search menu » Search Builder** or /civicrm/contact/search/builder?reset=1) to do so but i would recommend the search kit as the search builder may soon be deprecated / replaced by the search kit.
  
  > **Comments:**
  > **username_2**: I have the same need. In order to avoid having to build and maintain too many Searches, I'd rather have one Search, and then an affrom to filter results. But I can't find a way to search if a field is empty in a FormBuilder+SearchForm  
  
  ---
  
  