DYNAMIC USER CONTROLS (EDIT, NO ACCESS ETC)

[jaichith]

DEAR FRIENDS,

           I need help,   I am struck with a problem , i am planning to create a custom user control. but i could not frame a expression for it.  I have multiple users and user role and custom permissions for each table, views etc. (please check out the images) 

The allowed values are "READ_ONLY", "UPDATES_ONLY", "ADDS_ONLY", "ADDS_AND_UPDATES", "DELETES_ONLY", "UPDATES_AND_DELETES", "ADDS_AND_DELETES", and "ALL_CHANGES" (Enum)

I dont the expression for no access. kindly tell me the expression for no access. 

I have framed a expression but it did not work. 

SWITCH(USEREMAIL(),
Select(users[user role], [email]= useremail() ), Select(users permissions[Message settings], [user role]= [_this row].[user role]), 

"READ_ONLY")

[Aurelien · Accepted solution]

Hi @jaichith 

What about:

for table DASHBOARD:
LOOKUP(
  LOOKUP(USEREMAIL(),"USERS", "EMAIL", "USER ROLE"),
  "USER ROLE & PERMISSION","USER ROLE", "DASHBOARD"
)

for table STATUS:
LOOKUP(
  LOOKUP(USEREMAIL(),"USERS", "EMAIL", "USER ROLE"),
  "USER ROLE & PERMISSION","USER ROLE", "STATUS"
)

and more generally, for table YOURTABLENAME:
LOOKUP(
  LOOKUP(USEREMAIL(),"USERS", "EMAIL", "USER ROLE"),
  "USER ROLE & PERMISSION","USER ROLE", "YOURTABLENAME"
)

I never tried a CRUD expression with a LOOKUP expression though, I hope this work 🙂

[jaichith]

BRO, THANKS FOR SUGGESTIONS LET ME TRY WITH MY TEAM. REVERT YOU BACK WITH THE RESULTS

[jaichith]

Worked Perfectly

[Marc_Dillon]

For "no access", you would set a Security Filter to FALSE.

[jaichith]

BRO, THANKS FOR SUGGESTIONS LET ME TRY WITH MY TEAM. REVERT YOU BACK WITH THE RESULTS