Requesting Filter sets

[Paul_Danyliuk]

How about this old trick?

[Video] User-specific filters (each person tweaks controls independently)

Yet another question that has been asked and answered so many times: How do I let multiple people use the doc at the same time and change filters just for themselves? Time to have the ultimate answer in one place. I recorded the video explaining how to do that using a helper table. I call this approach the Flows Table pattern. [Coda trick: User-specific filters] TL;DR: Create a table where each row is linked to each Coda user. Set up its columns to act as controls (checkboxes,…

This is basically implementing select controls but as column in a table where each row corresponds to a user. Then you can put views of that one row across the whole of your doc.

---

P.S. If all you want is to show the same set of rows as in some other view — you can use this formula as your filter clause:

SomeOtherView.Contains(thisRow)

Then what happens is:

• Filters get applied to SomeOtherView
• Querying the view in a formula returns only those rows that are displayed
• Checking for Contains() will let through only the rows that are displayed in that other already filtered view.