Using a button to set a multi-select filter control to a set of options that includes Blank

1

So here’s my issue. I have a table with a multi-select column. I created a filter control for that column. I have buttons that set that filter control so that people who aren’t familiar with Coda can easily filter the table.

One of those buttons is an “All” button. I had previously set the “All” button to set the value of the filter control to “Option 1, Option 2, Option 3, etc.” Now, however, some rows will have nothing in that multi-select column, and therefore would be hidden by the current “All” button.

On the filter control itself I can just select “Blank” in addition to the other items in order to filter the table appropriately. However, I can’t figure out a way to make the button set the filter control to this state. Any ideas would be appreciated.

2

Have you tried - “” ?

3
4

I have. This sets the control value to none.

5

Found a solution after playing around with it a bit more. I selected the set of options I wanted, including blank, as the default value for the control. Then I made the “All” button simply reset the control value.

1 Like
6

Maybe it is also good to know that you can set one of your filter options (I assume that you are using a switch() or switchif() ) to true(), all your rows will be visible if that option has been chosen.

1 Like