Add and update for different groups

[Fernanda_Lopez]

Hi
I want to make a group of people be able to add in a view and another group of people just be able to make updates with an action in the same view (I dont want them to be ablet to add)
What do I have to do?

[LeventK]

help.appsheet.com

Limiting Users to Particular Tables, Views, and Actions

How to make sure that your users can see and do only what they need to

[Fernanda_Lopez]

SWITCH(USEREMAIL(),
“admin@mycompany.com”, “ALL_CHANGES”,
“manager@mycompany.com”, “UPDATES_ONLY”,
“READ_ONLY”)

I want to use a SELECT()

[Steve]

Fernanda_Lopez:

I want to use a SELECT()

Go ahead. You can use any expression you want so long as the result is one of the allowed values.

[Fernanda_Lopez]

It not letting me use a SELECT(), what am I doing wrong?

[LeventK · Accepted solution]

SELECT() expression returns a List where SWITCH() expression expects a single value. Wrap your SELECT expression with ANY(SELECT(…)) and ensure that the expression will return an email value as you are evaluating the USEREMAIL() expression’s return value.

Provided you need to evaluate if the USEREMAIL() lies in the List of Selected Values then you need to use an IFS()/IF() and IN() expressions:

IF(
    IN(USEREMAIL(), SELECT(TableName[ColumnName], {Yes/No Condition})),
    "ALL_CHANGES",
    "UPDATES_ONLY"
)