Thanks for the reply. Here is what I have done:
Created a slice called “Current User” and the expression USEREMAIL() = [Email]. [Email] is my first column the Users tab. I have the following roles [Role] - “SuperAdmin”, “CareManager” and “Patient”
Under my “Users” Table with [Email] as my primary key, I input the following formula that you recommended:
IN(INDEX(Current User[Role], 1), list(“SuperAdmin”, “CareManager”, “Patient”))
When I hit save I get the following message: Unable to fetch app definition. Error: Data table ‘Users’ is not accessible due to: Error: Data table ‘Users’ is not accessible due to:
When I remove the expression, the message disappears. I have checked the Google Sheet, regenerated the table.
What I am attempting to achieve is as follows: SuperAdmin sees everything, CareManagers see his/her patients and patients see only their data.
Would appreciate another reply. Thanks.