Skip to main content
Question

how do i filter contacts that have empty fields?

  • July 18, 2013
  • 0 replies
  • 594 views

I want to run a query and one of the parameters is that I need to find contacts that DO NOT have any information in one or more fields. They would be empty. How do I run that filter?
This topic has been closed for replies.

Forum|alt.badge.img+12
  • Quickbase Alumni
  • July 18, 2013
When you are in the Filtering section of the Report Builder you want to build a subset of filters within the filter section. To get this feature, you need to click on the "page" icon that appears next to the + - sign at the end of the Filter Row. Set this Subset of Filters to ANY and then in each of your Filter Rows make sure your [Field] is equal to " " and leave the value field empty.

  • Author
  • Quickbase Alumni
  • July 18, 2013
That did not work. Thanks though. Any other thoughts?

Forum|alt.badge.img+12
  • Quickbase Alumni
  • July 18, 2013
Give me a call offline so I can help you.

  • Author
  • Quickbase Alumni
  • July 18, 2013
It is a text field, so null won't work. I need it to find the text fields with no data and pull them.

Forum|alt.badge.img+12
  • Quickbase Alumni
  • July 18, 2013
You don't put "null" for a text field, you leave the box empty.

  • Author
  • Quickbase Alumni
  • July 19, 2013
Thanks for your help! Much appreciated!

Forum|alt.badge.img+6
This does not work anymore!! When I leave a field in the filter empty I still get the record in the report.

Forum|alt.badge.img+12
  • Quickbase Alumni
  • September 3, 2015
If the selection is a drop down, change it to "other" and then leave the last box empty

  • Quickbase Alumni
  • May 18, 2016
This isn't working for me.  Tried leaving blank for both a date field and a formula text field.  Any ideas?

  • Quickbase Alumni
  • March 24, 2017
Use: is less than --- the value --- " "              This worked for me

  • Quickbase Alumni
  • March 24, 2017

Like this

                                 


  • Quickbase Alumni
  • February 14, 2018
I have a text field and I used "is equal to"  the value and left the value blank. It worked for me.