Got ANOTHER awesome question today from @Fernando_Sudicovich about filtering a table in Coda similarly to Excel’s Data Segmentation tool, where you can select options in multiple categories above and filter your table accordingly.
You can do this by adding controls onto the canvas. For example, you can create a control called “Colors to Show”, a slider called “Greater Than”, and another slider called “Less Than”… Then you can filter your table to only show rows where the Color is selected in “Colors to Show”, and the Number is between the “Greater Than” and “Less Than” values. Then as you make selections in the controls, your table/view updates live.
Here’s an example doc with sections to show a couple ways to do this. One uses a select list for colors, and one uses a Colors table with checkboxes for show/hide – and then sets the “Color” column in the filtered table to lookup from the “Colors” table.
Play around, open up the filter formulas to understand how they work, and reply with questions and followup ideas! You can really go crazy with this and add as many dimensions as you want for your filter. And the fun part is you can customize exactly how each control interacts with your table filters.
Happy filtering!
Moriah