Solved: Restrict data slice to user's team

Colin_Lough · 10-22-2020 12:46 PM

Hi - 1st time post and getting going here

I have 2 tables, a listings table and a user table. The link between the 2 tables is TeamName and I would like to create a slice of data where the rows from the listings table will show only those where there is a match to the team of the current logged in user.
Appreciate your help.

Marc_Dillon

View solution in original post

Colin_Lough

To clarify; So where there is a match on the email address from the users table = the same as the username() virtual field in the top table.

Marc_Dillon

Your slice condition would be:

[team name] =
LOOKUP( USEREMAIL() , “Users” , “Useremail” , “Team Name” )

There’s no need for the LoggedInUser virtual column that you have.

Colin_Lough

Fantastic, worked a charm. Thank you @Marc_Dillon

Colin_Lough

@Marc_Dillon Is it possible to do the same lookup where the email is included in a multi-option column?

In the screenshot, I’d like to be able to return rows 19 & 20 if the logged in user was useremail1@test.com

Marc_Dillon