Slice table by user category

[Losalo]

Hello,

I'm creating a multi-organization app that allows each organization that accesses using its own email account to view only the product that refers to it

I've the following tables with the following columns:
• Products (id, name, organization)
• Organizations (id, name, email address)

I'd like to slice the product table by showing products that relate to a specific organization only to users that access the app using the email that ref to that specific organization.

Can you help with the right expression to use?

Thanks

[TeeSee1 · Accepted solution]

Try

[organization]
=
LOOKUP(
 USEREMAIL(),
 "Organizations",
 "email address",
 "id"
)

here [organization] in products table stores Organization id, not its name.

[Losalo]

nope, doesn't work

[Losalo]

@TeeSee1 sorry my mistake, it works thank you!

The only thing remaining to do is to let a super admin user see all of entries.

Suggestions?

[TeeSee1]

Use OR()

OR(
 USERROLE() = "Admin",  <- replace with an expression that identifies admins as required
 ****place the expression already created here***
)