0

Second attachment, showing the option in SearchbuilderI 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 select options in formbuilder

Improve this question

2 Answers 2

Reset to default
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

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 %

Improve this answer
2
  • 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.
    – Betty Dolfing
    Commented Sep 6 at 14:24
  • Updated civi to 5.77 and now it is working as above. Still not very userfriendly, but functioning. thanks!
    – Betty Dolfing
    Commented Sep 26 at 7:30
0

You can use SearchKit to find contacts without an email by doing this

enter image description here

Does that help?

Improve this answer
3
  • 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.
    – petednz - fuzion ♦
    Commented Jul 4 at 21:10
  • 1
    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?
    – Betty Dolfing
    Commented Jul 8 at 6:45
  • 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.
    – Betty Dolfing
    Commented Jul 8 at 6:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.