Rules dependidng of user tables

Sebastian_Munoz · 02-11-2021 08:58 AM

Hi, I have table with all my users email and also a user type, I want to add a condicional to the other tables that only the ones that are users type 1 can only see, users type 2 add.

Steve

Like this?

SWITCH(
  LOOKUP(USEREMAIL(), "Users", "Email", "UserType"),
  "type 2", "ADDS_ONLY",
  "READ_ONLY"
)

Sebastian_Munoz

I think it what i need but, if is more than two types.
Is goint to be something like this ?
SWITCH(
LOOKUP(USEREMAIL(), “Users”, “Email”, “UserType”),
“type 2”, “ADDS_ONLY”,
“type 3”,“UPDATES_ONLY”,
“READ_ONLY”
)

Steve

Give it a try and find out.

Sebastian_Munoz

Other question is if I have some columns that have to be only editable for some type of users is a way to select the colums that have to take that condicion or I have to add the condicion in every column that need it.

Steve

This.

Sebastian_Munoz

ok perfect, One las question is about the size of the text ;

the size of the text in the answer is bigger than the size of the text in the question

Steve

The best you can do is use a format rule to reduce the size of the font used to display the column value.

Sebastian_Munoz

thanks for al your help

MultiTech

Just for good measure, and to link this topic to a standard answer: