0

Filter Column Records That Have Entries?

How do I filter a column to show only those records that have data in that column?

13replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Mr. K.
    • Mr_K
    • 4 yrs ago
    • Reported - view

    I see = null to show empty fields, but nothing to show fields with data.

    Like
    • Support
    • Support
    • 4 yrs ago
    • Reported - view

    Hi, 

    You just have to put in the field name like: 

    if myfield then..... else.... 

    That will check if the field has any content.

    Best, Jörg

    Like
    • Mr. K.
    • Mr_K
    • 4 yrs ago
    • Reported - view

    I don't understand. Can you be more specific and maybe show screenshots? I'm trying to do it with a filter.

    Screen Shot 2018-07-20 at 12.37.37 PM

    Like
    • Mr. K.
    • Mr_K
    • 4 yrs ago
    • Reported - view

    If the field is set up multiple choice, then I can sort (not empty). But the field I want to sort is a text field.

    Screen Shot 2018-07-20 at 5.25.19 PM

    Like
    • Mr. K.
    • Mr_K
    • 4 yrs ago
    • Reported - view

    I could use some help with this please.

    Like
  • Hi Mr.K.

    try this:

    ---

    !=null

    ---

    Leo

    Like
    • Mr. K.
    • Mr_K
    • 4 yrs ago
    • Reported - view

    Leo, Perfect! I have to ask. How do you know that? I couldn't find anything like that in the manual. Is it knowledge of code?

    Like
    • Mr. K.
    • Mr_K
    • 4 yrs ago
    • Reported - view

    And thanks too!

    Like
  • I think I've read it here in forum before

    Leo

    Like
    • Mr. K.
    • Mr_K
    • 4 yrs ago
    • Reported - view

    Cool

    Like
    • Laura
    • Laura
    • 4 yrs ago
    • Reported - view

    As a followup, is there a way to use "contains()" in the filter header for a field?

    Like
  • Hi Laura,

    you don't have to do that. Just write your word in the filter field

    Like
    • Laura
    • Laura
    • 4 yrs ago
    • Reported - view

    Thanks, Leo! I’ll give it a go.

    Like
Like Follow
  • 4 yrs agoLast active
  • 13Replies
  • 3820Views