Filter Column Records That Have Entries?
How do I filter a column to show only those records that have data in that column?
I see = null to show empty fields, but nothing to show fields with data.
You just have to put in the field name like:
if myfield then..... else....
That will check if the field has any content.
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.
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
As a followup, is there a way to use "contains()" in the filter header for a field?
you don't have to do that. Just write your word in the filter field
Thanks, Leo! I’ll give it a go.