Hey Coda Community So I have a problem I hope you can help me with. I would like to filter the first table called “Case”, based on which user is looking at that table. I’ve created another table called “Responsible”, where I can dedicate the responsible user to a project. The field responsible i…

Hi @Viet_Pham , can you try using Responsible.Contains(User()) and see if that works for you?

Hey @mallika I’ve tried using: [image] mallika: Responsible.Contains(User()) But it doesn’t work, it returns an empty table see the image below: [01]

Set column format of Responsible.Responsible to People. And perhaps the format of the Case.Responsible column as well. It works fine for me

Hey @Paul_Danyliuk I’ve tried to: [image] Paul_Danyliuk: Set column format of Responsible.Responsible to People. And perhaps the format of the Case.Responsible column as well. It works fine for me But it still doesn’t work. Can you maybe show me a doc, where you do it? So I can replicate? T…

Thanks for the help @Paul_Danyliuk that solved it!

So what was the problem with your doc?

Hey @Paul_Danyliuk , the problem was that I didn’t use a lookup in the case column and got the data from the responsible column, by using this formula: [image] Viet_Pham: Responsible.Filter(Case=thisRow.Case).Responsible After chaning the Case Column to be a lookup type that got data from the…

Filtering table based on which user is looking at the doc

Superhuman Ask the Community

Paul_Danyliuk August 2, 2019, 1:49pm 6

Try with this one (add yourself there)

Is there a way to do personal filters?

Topic		Replies	Views
How to personalize tables with People lookup value instead of People values Ask the Community	3	531	September 2, 2022
Filter rows in Table 2 based on result of filter in Table 1 Showcase & Tips	6	1334	January 21, 2021
Filter tables based on a separate defined user-username table mapping Ask the Community	3	1028	August 5, 2020
How to filter column based on another tables value? Ask the Community	2	899	July 29, 2021
Filtering a tasks table Ask the Community	1	608	October 15, 2018

Filtering table based on which user is looking at the doc

Related topics