Filter Current User Lookup Column

Hello everyone. I have a problem when trying to apply a filter to a table.

I have a table with a column where I filter the jobs for each user I have in the workspace. I want that when a user enters the page he can only see his jobs and not everyone’s job.

For it I apply a filter so that it only shows the rows where “Franquiciado=User()”, but it doesn’t work.

I think it is because it detects that column as a Lookup and not as Users, can it be?

The summary is: I want the column “Franquiciados” to filter by Current User.

Does anyone know what I can do to make it work? I have investigated in the forum but I couldn’t solve it. Thanks

I have tried to explain it better in the document. Let’s see if this way it is more understandable and someone can help me to solve it.

Thank you.

Hey there!

I fixed it for you in your doc - when filtering by current user, the people column has have people values in the column, what you had was lookup values:

Heres what you had in your column that wasn’t working (Lookup Values):

And here is what you need the column to look like (People Values)

So even though you formatted your column as a “People” column, it still had lookup values in them.

Hopefully that helps!

1 Like

Unbelievable! What a simple solution to the problem I have been trying to solve for days.

Thank you very much Scott

1 Like