Isolating table filtering

[Dave_Killeen]

Hi all

Is there a way to prevent another user’s filtering of a table from affecting your own view of that table?

Problem is when we’re both in there at the same time filtering the table for our respective work items, we both see when we both apply an ‘assigned to’ filter.

Thanks!

[Christiaan_Huizer]

hi @Dave_Killeen ,

I see two options:

1. two views of the same table, one for you and one for the other
2. creating a function inside the table that let you see only your items and the other user only his / her items.

I guess other coda users have more experience with this part of Coda like @joost_mineur or @Federico_Stefanato

cheers, Christiaan

[joost_mineur]

Hello @Dave_Killeen ,

Yes, it can be done. It is a little bit of work to setup properly, but once it’s setup properly, it works good. I am using it for a couple of my most frequently used tables, but you can set it up in such a way that one setup can be setup to be used in different places of your doc and applied to different tables, for each table with its own filter settings.

It has been worked out and documented by Paul Danyliuk and you can find the posting here:

[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,…

It has been a while since I looked at the video, so I can’t remember how detailed the explanation is, but once I figured it out, I never looked back. The only drawback (in my opinion) is that you use a field in a table to enter your search terms. By hiding columns, title, headers and the new row symbol the end result is pretty clean, but I hope for a better tool in the future. The newly introduced text object would make for a nice search field, but for now it has the exact samen problem you are having now.

The other drawback is that you have to think in advance on which columns you want to filter, because if you use the build in table filter options, you end up forcing your filter on the other users.

Greetings,
Joost