Skip to main content

Using Checkboxes to filter ??

  • February 25, 2024
  • 3 replies
  • 168 views

Forum|alt.badge.img+2

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? 

 

This topic has been closed for replies.

3 replies

Alexey_Gusev
Forum|alt.badge.img+25
  • Brainy
  • February 25, 2024

Hi,
What do you mean?

 


Forum|alt.badge.img+2
  • Author
  • New Participant
  • 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+25
  • Brainy
  • February 26, 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

 


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