Answers.Body: <p>Empty / not empty is not available as an exposed filter for SK but would be a great addition!</p>
  <p>As a workaround, expose the email filter operator so it’s set to user select -</p>
  <p><a href="https://i.sstatic.net/MB6hD0lp.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/MB6hD0lp.png" alt="SK Exposed Filter" /></a></p>
  <p>You can then use the Contains and Doesn’t Contain operators with “%” to find members who do and do not have an email address.</p>
  <p><a href="https://i.sstatic.net/TMEWjpjJ.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/TMEWjpjJ.png" alt="Doesn't Contain %" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-09-06T14:24:01.497Z
Answers.Text: Sorry for my late reply (holiday). Good option. Thanks! 
  In my situationt the 'Contains' % gives the correct result. 
  The 'Doesn't Contain %, gives no results. 
  might be my installe. Thanks for now.
Answers.UserDisplayName: Betty Dolfing
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-09-26T07:30:24.680Z
Answers.Text: Updated civi to 5.77 and now it is working as above. Still not very userfriendly, but functioning. thanks!
Answers.UserDisplayName: Betty Dolfing
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-08-09T07:54:24.907Z
Answers.LastActivityDate: 2024-08-09T07:54:24.907Z
Answers.UserDisplayName: Anil
Answers.Body: <p>You can use SearchKit to find contacts without an email by doing this</p>
  <p><a href="https://i.sstatic.net/xs7P1xiI.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/xs7P1xiI.png" alt="enter image description here" /></a></p>
  <p>Does that help?</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-04T21:10:21.420Z
Answers.Text: Not sure why you need this as part of Form Builder - if it is in SK then you can presumably set up two searches, one that finds those with no emails, and one that finds those that have emails.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-08T06:45:05.090Z
Answers.Text: Thanks for that. Yes I know this option. However, I want to use 1 search kit for multiple searches. So create 1 membership report and that CiviCRM users can then filter (depending on the context) on all memberships with a certain status AND email address. Or all Members with a certain membership type, and certain end date AND an email address. 
  
  Then, depending on their needs, the CiviCRM user can decide which filters to set in the form and then which actions to perform. That way we use the flexibility of SK and Forms in CiviCRM. 
  
  Does that clarify?
Answers.UserDisplayName: Betty Dolfing
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-08T06:45:09.187Z
Answers.Text: NB: I used previously also the Search Builder, where there is the option to choose 'Email is empty' (see attachment). That's the one I am looking for as a filter in the form builder.
Answers.UserDisplayName: Betty Dolfing
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-07-04T21:08:54.533Z
Answers.LastActivityDate: 2024-07-04T21:08:54.533Z
Answers.UserDisplayName: petednz - fuzion
Body: <p><a href="https://i.sstatic.net/Dkoc6A4E.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/Dkoc6A4E.png" alt="Second attachment, showing the option in Searchbuilder" /></a>I have build Search Kit with a list of members who need to renew their membership.
  The list contains contact data and email address.</p>
  <p>In the form I want to have the option to select all members that DO have an email address (because then I can send them a renewal email) and all members that do NOT have an email address (they receive a letter).</p>
  <p>I can't find the option for a user to select 'Email' is empty / not empty. When I choose Email ID as a filter field, I can not find an option / operator to get this in the form.</p>
  <p>Is there a way that I can have the users filter on the Email field? See attachment <a href="https://i.sstatic.net/IYufv8rW.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/IYufv8rW.png" alt="email filter in Report - form for user" /></a>
  <a href="https://i.sstatic.net/O2tctn18.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/O2tctn18.png" alt="select options in formbuilder" /></a></p>
  
Tags: <email><formbuilder>
Title: Formbuilder: User select 'Email' --> Empty / Not Empty
ThreadText: # Formbuilder: User select 'Email' --> Empty / Not Empty
  
  (Asked by: username_0 on 2024-07-04)
  
  [![Second attachment, showing the option in Searchbuilder](https://i.sstatic.net/Dkoc6A4E.png)](https://i.sstatic.net/Dkoc6A4E.png)I have build Search Kit with a list of members who need to renew their membership.
  The list contains contact data and email address.
  
  In the form I want to have the option to select all members that DO have an email address (because then I can send them a renewal email) and all members that do NOT have an email address (they receive a letter).
  
  I can't find the option for a user to select 'Email' is empty / not empty. When I choose Email ID as a filter field, I can not find an option / operator to get this in the form.
  
  Is there a way that I can have the users filter on the Email field? See attachment [![email filter in Report - form for user](https://i.sstatic.net/IYufv8rW.png)](https://i.sstatic.net/IYufv8rW.png)
  [![select options in formbuilder](https://i.sstatic.net/O2tctn18.png)](https://i.sstatic.net/O2tctn18.png)
  
  **Tags:** email, formbuilder
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2024-08-09. Score: 1
  
  Empty / not empty is not available as an exposed filter for SK but would be a great addition!
  
  As a workaround, expose the email filter operator so it’s set to user select -
  
  [![SK Exposed Filter](https://i.sstatic.net/MB6hD0lp.png)](https://i.sstatic.net/MB6hD0lp.png)
  
  You can then use the Contains and Doesn’t Contain operators with “%” to find members who do and do not have an email address.
  
  [![Doesn't Contain %](https://i.sstatic.net/TMEWjpjJ.png)](https://i.sstatic.net/TMEWjpjJ.png)
  
  > **Comments:**
  > **username_0**: Sorry for my late reply (holiday). Good option. Thanks!  In my situationt the 'Contains' % gives the correct result.  The 'Doesn't Contain %, gives no results.  might be my installe. Thanks for now.  
  > **username_0**: Updated civi to 5.77 and now it is working as above. Still not very userfriendly, but functioning. thanks!  
  
  ---
  
  ### Answer by username_2 on 2024-07-04. Score: 0
  
  You can use SearchKit to find contacts without an email by doing this
  
  [![enter image description here](https://i.sstatic.net/xs7P1xiI.png)](https://i.sstatic.net/xs7P1xiI.png)
  
  Does that help?
  
  > **Comments:**
  > **username_2**: Not sure why you need this as part of Form Builder - if it is in SK then you can presumably set up two searches, one that finds those with no emails, and one that finds those that have emails.  
  > **username_0**: Thanks for that. Yes I know this option. However, I want to use 1 search kit for multiple searches. So create 1 membership report and that CiviCRM users can then filter (depending on the context) on all memberships with a certain status AND email address. Or all Members with a certain membership type, and certain end date AND an email address.   Then, depending on their needs, the CiviCRM user can decide which filters to set in the form and then which actions to perform. That way we use the flexibility of SK and Forms in CiviCRM.   Does that clarify?  
  > **username_0**: NB: I used previously also the Search Builder, where there is the option to choose 'Email is empty' (see attachment). That's the one I am looking for as a filter in the form builder.  
  
  ---
  
  