Hi there
How can I make a report that shows all “contacts” where the field “Emailadress” is “empty” ?
What character must I give to the Value Field to get this “empty” ?
I already tried * “” NULL %%%% and so on…
Here a screenshot of my issue:
Did anyone get back to you? I would can’t figure this out either. :S
As (a really awful) workaround you could:
. create a text field (you don’t need to add it to your layouts)
. create a logic hook or a custom scheduler or, possibly a workflow that checks the email field and, if empty writes EMPTY in the new field otherwise it writes FILLED
. create your report and ceck for EMPTY in the value of that field
I know that this is a horrible solution but it has worked for a few.