What is the Filter formula?
The Filter formula allows you to tell Coda exactly what part of your tables you want to work with. Like with all formulas in Coda, you can build it anywhere by typing "=".
After the = sign, you'll type the table name then ".Filter". Note, the "." is critical. Let's take a look at an example:
1. Calculate the number of produce items:
[Groceries]. Filter(Department=Produce).Count( )
2. Calculate the number of produce items with a stock of less than 5:
[Groceries]. Filter(Department=Produce AND Quantity<5).Count( )
3. Create a bulleted list of the produce items with a stock of less than 5:
[Groceries]. Filter(Department=Produce AND Amount<5).BulletedList( )
Connecting tables with the Filter formula
You can also connect table data together using a combination of the Filter and thisRow formulas. For example, maybe I want a summary table that shows the amount of items we have in each grocery department.
To begin, I would create a new table with each department listed in rows. Then, I would change the column format in our core grocery table to be a Lookup:
Then, I can add the following formula to my summary table:
This formula tells Coda to look at the row in the summary table, and filter the other table by that value:
As a shortcut, once you have lookup columns, you can quickly add relevant columns about the source information when you click the + sign to add a new column: