Solved: User with privileges - Page 2

Benni · 11-07-2023 11:19 AM

Hi all 👋

I want some icons in the navigation menu to be visible only to users with privileges. To achieve this, I created a field called: "USER WITH PRIVILEGES?". If the field remains blank, the answer is NO and the field will not be visible to an unprivileged user.
I'm not getting the desired result. Where am I doing wrong?
Thanks for your answer.

TeeSee1

Your expression ISNOTBLANK(VOLONTARIO[USER WITH PRIVILEGES?]) evaluates to TRUE if only one of the rows in the table VOLONTARIO has a value in this field.

I am not entirely sure how your app is configured but you would probably want to create an ENUMLIST field (ie [privilege list]) in your users table and in any of the show-if parameter set something like

IN(
 "Name of the privilege that grants access to this view", 
 SELECT(
  users[privilege  list], 
  [userID]=USEREMAIL()
 )
)

View solution in original post