Controls allow you to take your Coda doc to the next level. With Controls, you can add interactive elements to your documents that are typically reserved for applications - for example, you could add a checkbox column and then conditionally format based on that.
How to add a Control on the page
Use the Slash Command to access controls on any page. Simply type /control
to view all available options.
After selecting your option give it a name and custom icon.
You can use your control to filter or search your table by using the Matches()
function in your table filter options.
Hover over your table to expose "Options” in the upper right corner
Select "Filter” from the table options menu
From the filter configuration panel, click "+ Add Filter”
Select “Formula”
Use the
Matches()
formula to set-up search for your table
For example, in the above example, the filter formula is =thisRow.Rating.matches(Customer Rating)
, where Rating is the name of the column with the data to filter by, and Customer Rating
is the name of the rating control above the table.
How to add Controls in a Table
Pro tip - Scale and Slider can be found by search by name or looking under Number
Filtering Tables and Views based on Controls
If you have an existing control or create one for the + menu you can filter a table or view by the control's value using the Matches function. This makes it easy to match not just on exact values, but also for lists and ranges.
Simply click the filter icon to apply your formula of choice to your table.
Pro Tip: You can filter any of your tables and views based on any Control in your doc. There's no need to have it in the same page - pretty handy!