Skip to main content
Solved

Can you filter out blank fields in custom view

  • January 27, 2023
  • 2 replies
  • 75 views

Forum|alt.badge.img+2

I was setting up a custom view and I wanted to exclude assets that were missing a value in a specific column I couldn’t seem to figure out how to exclude rows with null values.

Best answer by nburke

You could create your view and when you choose that custom field as a filter, you can then go into your Settings, filter that custom view, and choose all the categories or items you want but then choose EXCLUDE SELECTED at the bottom.  That way it will give you the result of anything but those that were chosen-which should be all your blank ones.

2 replies

nburke
Contributor
Forum|alt.badge.img+5
  • Contributor
  • Answer
  • January 30, 2023

You could create your view and when you choose that custom field as a filter, you can then go into your Settings, filter that custom view, and choose all the categories or items you want but then choose EXCLUDE SELECTED at the bottom.  That way it will give you the result of anything but those that were chosen-which should be all your blank ones.


Kathryn Carter
Forum|alt.badge.img+18
  • Community Manager
  • January 30, 2023

@nburke Thanks for jumping in and suggesting this work around! Great job!