help.coda.io Open in urlscan Pro
143.204.98.62  Public Scan

Form analysis
1 forms found in the DOM

/en/

<form action="/en/" autocomplete="off" class="header__form search">
  <input type="text" autocomplete="off" class="search__input js__search-input o__ltr" placeholder="Search for articles..." tabindex="1" name="q" value="">
  <div class="search_icons">
    <button type="submit" class="search__submit o__ltr"></button>
    <a class="search__clear-text__icon">
            <svg class="interface-icon" xmlns="http://www.w3.org/2000/svg" width="16" height="16" viewBox="0 0 16 16">
              <path d="M8.018 6.643L5.375 4 4 5.375l2.643 2.643L4 10.643 5.375 12l2.643-2.625L10.625 12 12 10.643 9.357 8.018 12 5.375 10.643 4z"></path>
            </svg>
          </a>
  </div>
</form>

Text Content

Go to Coda

All Collections
Filters
Beginner
Introduction to filtering your tables


INTRODUCTION TO FILTERING YOUR TABLES

Learn how to filter out unwanted rows in your tables!
Written by Lena Webster
Updated over a week ago


INSIDE THIS ARTICLE

Introduction to table filters
Filtering with formulas

Filter by multiple parameters
Filter items out of a table

Do I have to use the table filter every time I want to filter something?

How do I remove filters from a table?

Watch a video about filtering tables



INTRODUCTION TO TABLE FILTERS

In Coda, we offer the ability to filter out rows in a table or view by
stipulating a logic for the rows you want to view (or not view!). To filter a
table in Coda, you can use a formula or our simple filter builder. Both are
accessible via the "Filter" button above the table or via the "Options" button
(your mouse will need to be hovering over the table for the buttons to appear).





From there you can either write a formula to filter the rows in a table or use
the filter builder. To access the formula editor for the table filter, just
click on the cursive "f" button above and to the right of the filter section.





Here's what the whole thing looks like in a real doc:








FILTERING WITH FORMULAS

As we saw above, you can write out a formula to filter your table. This can be
easier for times when you want to write a more complex logic to filter the table
on, or if you just prefer writing a formula.



If you're familiar with how formulas in other parts of Coda work, it's important
to note that formulas in table filters operate a little bit differently: the way
to think about table filter formulas is that your filter is saying "only show
the rows where the formula is true".



Here's a simple example: this filter is only returning rows in a table where the
"Department" column contains the lookup value "Produce" (you can tell it's a
lookup value in the formula by the icon on the right, or by the light blue
circle styling around the word in the table).








FILTER BY MULTIPLE PARAMETERS WITH FORMULAS

What if you want to filter by two parameters, like Department and Price? To do
this, you can add the word "AND" or "OR" to your formula, for example
Department.Contains(Produce) AND Price <2 .  If you're a recovering programmer,
&& will also work. Note that if you use a formula to chain multiple logical
statements, you'll want to wrap connected ideas using () for the logic to
evaluation properly.



You can similarly use the filter builder to do this manually:







FILTER ITEMS OUT OF A TABLE WITH FORMULAS

Formulas also allow us to filter items out of a table by typing "!=". If you're
new to formulas, "!=" translates to "not equal" and is really just adding "!" in
front of the equals sign to denote that you don't want the values to be equal.



Here's a simple example where we're going to filter out all the rows associated
with a specific owner from a table of tasks:





Of course, you can imagine doing much more elaborate statements or even
filtering out by multiple criteria!




DO I HAVE TO USE THE TABLE FILTER EVERY TIME I WANT TO FILTER SOMETHING?

Nope! Check out this article about filtering tables and views based on controls
to see how you can use controls to filter your tables more easily.




HOW DO I REMOVE FILTERS FROM A TABLE?

To remove a filter, click the "filter" button and look for the trash can icon in
the right side panel that pops up. Here's a gif of what that looks like:






IN CASE YOU'RE MORE OF A VISUAL LEARNER, THIS VIDEO FROM CODA.IO/LEARN WALKS
THROUGH FILTERING IN MORE DETAIL!










Did this answer your question?
😞 😐 😃
 * Terms of Service
 * Privacy Policy

 * 
 *