List Manager Forum

Can filter checkboxes, ignore NULL value?

User DavidLGCrawford 2023-06-27 12:04:46

I have two fields in my table that are either "Yes" or NULL. When I use them as a filter with checkboxes I see:
Field_1

Yes

But what I want to see is just:
Field_1
Yes

Is there a way to make it not show NULL values as an option?

If I wanted to show the top option (I don't know why someone would want to... but *if*) I could always change the NULL values to just an empty string. But for me, I want to hide that option and only have the filter show the YES checkbox.

Moonsoft support 2023-06-28 08:43:56

Hi,
there is no way to hide specific values from a filter, sorry. When you create a filter the possible options will be all different values present at your data table, (and this is required, because you would lose the option to filter only the 'empty' values otherwise).

Best regards

...
Support/development 10 hours

Get a bigger amount of hours for more complex tasks and get a 10% discount

Buy now!
...
CalcBuilder

Create dynamic calculators

Buy now!