Skip to main content

Using Checkboxes to filter ??


Trying to create a filter in interface where all my firelds within the filter are checkboxe field ..  

Why: I'm looking for a hack to work around poor formatting that turns off my audience new to AT.

Problem: 

Each checkbox must perfectly align for that data point to show up.. the default blank.. Does not give option to not filter if Empty. 

make sense to anyone? 

 

3 replies

Alexey_Gusev
Forum|alt.badge.img+12

Hi,
What do you mean?

 


  • Author
  • New Participant
  • 1 reply
  • February 25, 2024

Hi..

kind of  -  hope this makes sense..

If both are unchecked.. sorts all blank but its filtering as if Empty where is selected

If check 1 =checked , it sorts all yes in check one 1, and all empty in check 2  - fine 

But if you a check 3: 

check 1 = checked ,  check 2 - empty ,  check 3 = checked  

in this case, it leaves out data where check 1 = checked & check 3 = blank 

Again.. the main reason I am doing this to make a simple set of check filters for the user.. 

Thx

 


Alexey_Gusev
Forum|alt.badge.img+12
Air_Jordan wrote:

Hi..

kind of  -  hope this makes sense..

If both are unchecked.. sorts all blank but its filtering as if Empty where is selected

If check 1 =checked , it sorts all yes in check one 1, and all empty in check 2  - fine 

But if you a check 3: 

check 1 = checked ,  check 2 - empty ,  check 3 = checked  

in this case, it leaves out data where check 1 = checked & check 3 = blank 

Again.. the main reason I am doing this to make a simple set of check filters for the user.. 

Thx

 


Sorry, but I'm still can't understand what's the problem,
Checkbox can only be checked or unchecked,  exactly 2 options, like  "1" or "0"
Empty equals unchecked.
If you want ternary logic, with 'empty', choose single-select with any options, for example

Update: now I understand!!!  You want user to be able, for any checkbox field to 'show only checked' or 'show only unchecked' or 'empty/undefined etc. (this field doesn't affect filtering)'. Yes, ternary logic can help you.

Also consider multiselect field - it can combine several filters in 1 field


Reply