Are updates allowed? Formula Issues

[Aplicaciones_Hu]

Im trying to set an expression to limit permission for users & admin

I set the following expression:

IFS(IN(Useremail(), MAIL[MAIL CUADRILLA]),“ADDS_AND_UPDATES”, IN(Useremail(), Supervisores[Email]),“READ_ONLY”,),
,“READ_ONLY”

the problem is when i try to make an “ADD” with a [MAIL CUADRILLA] email that has “ADDS_AND_UPDATES_” allowed.

I get the following error.

idk why, maybe the expression is not compatible?

I try with a “SWITCH” expression and i receive another issue…

ie:

SWITCH(USEREMAIL(),
“user1@mydomain.com”, “UPDATES_ONLY”,
“user2@mydomain.com”, “ALL_CHANGES”,
“READ_ONLY”)

when i make the test the only rule applies is the “READ_ONLY” all the others permissions i set just getting ignore by the app.

Maybe im doing something wrong? I follow some post about this… but i cant find the solution.

Idk why expression is the best to set permissions in the “Updates allowed” section.

[Steve]

This expression is malformed:

user1@mydomain.com and user2@mydomain.com are examples; replace them with something appropriate for your need.

[Aplicaciones_Hu]

thanks for the advice, what is the correct method to build up this expression?

IFS(IN(Useremail(), MAIL[MAIL CUADRILLA]),“ADDS_AND_UPDATES”, IN(Useremail(), Supervisores[Email]),“READ_ONLY”,),
,“READ_ONLY”

[Steve · Accepted solution]

Aplicaciones_Huinoil:

what is the correct method to build up this expression?

help.appsheet.com

IFS()

First-match conditional evaluation

Aplicaciones_Huinoil:

i think the best way is setting userroles or with “All updates allowed”

I agree! Just got to get that expression working.

[Aplicaciones_Hu]

i build the expression from this site:

AppSheet Training

Learn to use the IFS AppSheet Expressions with our in-depth Library -...

Deep Dive on the IFS AppSheet Expression, or search for AppSheet expressions that may solve a particular problem, put your own expressions on display, or get inspired by other’s creations

[Aplicaciones_Hu]

The only way i reach to make some “filters based on useremail” is setting

IN(Useremail(), usertable[emailcolumn])

in every each “ADD” button to make the add button hide from some users.

but i think the best way is setting userroles or with “All updates allowed” but this last i didnt understand how works at this moment.}

seems like “All updates allowed” expression boxs works differently from other expression boxes.