Auto create 'Blank' as a filter option

  • 1
  • Idea
  • Updated 4 months ago
  • Implemented
It would be very helpful if when you create a filter with Pick Options and Condition(s) created automatically, that there was the ability to add 'Blank' to the auto created filter options.

One example of a use case would be if an opportunity is in the 'Finals' stage, show all opportunities where 'Date sent' is blank. This would also be helpful to see all opps where multiple specified fields are blank.

There is no good work around for this. (Unless someone can suggest one I haven't though of!) They all have restrictive limitations. If your picklists have a large number of values then manually creating conditions for each filter becomes time restrictive. Creating toggle buttons based on an 'is blank' condition will get cluttered when used in addition to the normal filters, not to mention the normal filters and the toggle condition buttons can contradict each other. Sorting on a column header does not re-query a model so if there are too many records to display on page load then the result will not be accurate.
Photo of Sue Baldwin

Sue Baldwin

  • 148 Points 100 badge 2x thumb
  • like this has to be a common requirement

Posted 4 months ago

  • 1
Photo of John Dahlberg

John Dahlberg, Champion

  • 2,442 Points 2k badge 2x thumb
If you define your filter in the model, then use your source as picklist for the field, you can add an additional manual source for the blank value.  Leave the value field blank for the Manual option.  Here's a screenshot:

  
Photo of Sue Baldwin

Sue Baldwin

  • 148 Points 100 badge 2x thumb
Thank you so much! This is a huge help. I used the above combined with https://community.skuid.com/skuid/topics/multi-select-filter-option-for-non-picklist-fields and was able to use this for multiselect picklists as well.