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
-
I see = null to show empty fields, but nothing to show fields with data.
-
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
-
I don't understand. Can you be more specific and maybe show screenshots? I'm trying to do it with a filter.
-
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.
-
I could use some help with this please.
-
Hi Mr.K.
try this:
---
!=null
---
Leo
-
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?
-
And thanks too!
-
I think I've read it here in forum before
Leo
-
Cool
-
As a followup, is there a way to use "contains()" in the filter header for a field?
-
Hi Laura,
you don't have to do that. Just write your word in the filter field
-
Thanks, Leo! I’ll give it a go.
Content aside
- 5 yrs agoLast active
- 13Replies
- 3932Views