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.
Like this?
SWITCH(
LOOKUP(USEREMAIL(), "Users", "Email", "UserType"),
"type 2", "ADDS_ONLY",
"READ_ONLY"
)
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โ
)
Give it a try and find out.
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.
This.
ok perfect, One las question is about the size of the text ;
The best you can do is use a format rule to reduce the size of the font used to display the column value.
thanks for al your help
Just for good measure, and to link this topic to a standard answer:
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |