I have a table with a “Status” selection box column; this has predefined values such as “Draft”, “Published” and “Archived”.
I want to be able to allow users to filter the table based on “Status”, but so that any combination can be selected. Currently, we’re achieving this using a Multiselect Control, but I’ve had requests to change this to checkboxes; there’s a few reasons why this fits better, but the big one is that instead of it saying “Draft + 2” (for example), it gives immediate visibility on which “Status” options are being filtered for right now.
However, I currently cannot get this to work. I can do it for a single value, but not multiple checkboxes being selected. I’ve tried using formula elsewhere that produces a string of “Status = ‘Draft’ AND Status = ‘Archived’” and referenced that, but it doesn’t work.
Is there anyway to set the value of a multiselect dynamically? If so, I could definitely patch something together. If not, any suggestions on how this might work?
FYI the checkboxes are not contained within the table.