Rules dependidng of user tables

[Sebastian_Munoz]

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]

Sebastian_Munoz_Mart:

I have to add the condicion in every column that need it.

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.

help.appsheet.com

Format Rules: The Essentials

Learn how to change the way information is displayed throughout your app.

[Sebastian_Munoz]

thanks for al your help

[MultiTech]

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

Current_User (Slice) - How to conform your app around WHO is using the app Tips & Tricks 💡

One of the core basic functions, included in just about EVERY app I make, is the ability for the app to know WHO is using the app. If the app knows who’s using it, then I can easily control many different aspects of the app: Add/edit/delete permissions How data should be filtered What views are shown What buttons, or Actions, are visible Which workflows should fire off Which columns should be shown or editable etc. Requirements To accomplish this functionality in your app, you need the follo…