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.
I was just refactoring mine. This probably isn’t what you want, but I place on the canvas beneath the multiselect control a formula outputting the multiselect value to a bulleted list, so that I can quickly see what is selected:
What this does is check each checkbox by name within the .If() statements, and if it returns true (i.e. is checked) then adds the related Status value to the array being queried within .Contains(), if it returns false it just leaves the addition blank.
If they’re all unchecked, you get a string filtering on blank, so it displays any rows without a Status, but I can live with that (as there shouldn’t be any really)
That’s funny, I was just solving for this (couldn’t live with it in my case). I appended a second OR statement to my filter for the case when all the checkboxes are unchecked. It works, but adds significant length to the filter formula.
hi all coda noob here: Anyone have advice on how to make this work when referencing a lookup column? Love this approach and have tried to recreate it exactly but can’t seem to get it to work… and not getting any specific “errors” per se so it’s tough to trouble shoot. The only difference i can identify vs. @mallika’s example is that i’m looking at a lookup column vs a text column… formula below.
Without seeing your doc it is hard to tell but as you mentioned Lookup I’d recommend you try entering Paid as @paid and selecting from the options provided. If it is a lookup value it won’t be a string “Paid” but will need to be reference ( same type as lookup). If you share your doc here or via support@coda.io I can take a quick look.
It would be really nice to instead make the multiple-select control more flexible to format (e.g., wider).
And even better, I’d like to be able to create a filter control that renders multiple checkboxes based on available values. The multi-select dropdown can be awkward to use, requiring a lot of clicks to 1) open, 2) select item, 3) close.
But thanks 
thank you-