Hide table from specific users

[brunotbs]

Hi,

I have an app with data from multiple sources and multiple users accessing it.

I currently have 5 tabs displayed on the deck. I want one particular user to have access to all those 5 tabs but other users to only see two tabs in total. For each tab, I already created a slice with 'NOT([Completed])' so the only data it imports from the source are the rows where a specific box hasn't been ticked.

I tried adding UserEmail()<>"user@example.com" to that slice and also to a new slice to restrict access, but that did not seem to work. In fact, when I add it to the existing slice that has the 'NOT([Completed])' on it I get an error message saying 'Extra content: "UserEmail()"'.

Any ideas on how to restrict access to specific tables from specific users, ideally using the same slice I've already created to filter the data that's imported?

Thanks

[yasarcan]

hi

[brunotbs]

I'm not sure this makes sense to me. From what you've said, it seems like I would need to create a separate sheet with each user's details and then create an expression in the slice to allow/restrict access to the users in that sheet?

[brunotbs]

Ok, that solved part of the problem. I now have two slices for this tab, one restricting access to some users and another one filtering data where a tick box has been checked, but I only seem to be able to select one or the other. I want both slices to apply to those users at the same time. Is that possible?

Thanks

[yasarcan]

AND(
NOT([Completed]),
OR(
UserEmail()="user@example.com", // Allows full access to this user
IN([Tab Name], {"Tab1", "Tab2"}) // Other users can only see specific tabs
)
)

For Siles , row filter formul.

[MiguelPilo · Accepted solution]

Just use Security filter from table settings.

<PII Removed by Staff>