0

Filter Column Records That Have Entries?

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

13 replies

null
    • Mr_K
    • 5 yrs ago
    • Reported - view

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

    • Support
    • 5 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

    • Mr_K
    • 5 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

    • Mr_K
    • 5 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

    • Mr_K
    • 5 yrs ago
    • Reported - view

    I could use some help with this please.

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    Hi Mr.K.

    try this:

    ---

    !=null

    ---

    Leo

    • Mr_K
    • 5 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?

    • Mr_K
    • 5 yrs ago
    • Reported - view

    And thanks too!

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    I think I've read it here in forum before

    Leo

    • Mr_K
    • 5 yrs ago
    • Reported - view

    Cool

    • Laura
    • 5 yrs ago
    • Reported - view

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

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    Hi Laura,

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

    • Laura
    • 5 yrs ago
    • Reported - view

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

Content aside

  • 5 yrs agoLast active
  • 13Replies
  • 3942Views