Until now, the only way to create a filter in Coda was by writing formulas. Users told us that having to write formulas was too complex for common scenarios, so we set out to design a simpler filtering experience.
Today, we’re launching the new filtering experience in Coda:
As soon as you choose the column you want to filter your data by, we’ll automatically offer the intuitive filter controls for you to manipulate and see the results update immediately. You can also change the operator on your filter and will get the right control. You can add as many different rules as you like and also add more than one filter on the same column to accomplish more complex scenarios. You can even create different combinations of AND and OR without the need for formulas.
We continue to allow you to create filters using formulas as before by just clicking the formula button on top. You can even create filters using a combination of formulas and simple builders so you don’t have to choose between writing formulas and using the filter controls. We also built a way for you to see the underlying formula for any builder, to make it easier to learn the formula language and have even more control.
Finally, the new experience is smart enough to be able to convert the formulas you write back into builders. We’ve upgraded the existing filters you’ve created using formulas to the new experience. That way, you can modify them easily and see a summary of them in plain english. If you want to continue to use formulas, just click the formula button and we will remember your choice going forward.
Check out the blog post to learn more about our design process. Give the new experience a try on your existing docs or in a new doc. We’d love to hear your thoughts in the comments below.