Problem with privileges expression

[Hernan_da_Silva]

Hello,

Im developing an app using appsheet and i want to control privileges over different tables, but i have a problem with the formula of the “Are updates allowed?” field.

This is the formula im using

SWITCH(LOOKUP(USEREMAIL(),“usuarios”,“email”,“rol”),
“RT”, “UPDATES_ONLY”,
“administrador”, “ALL_CHANGES”,
“READ_ONLY”
)

But im receiving an error:

SWITCH function is used incorrectly: Cannot convert input 2 of type ‘Text’ to ‘List of Text’

Cant understand why since data types and args seems to be correct…

Thank you very much!

[Rafael_ANEIC-PY · Accepted solution]

Hello @Hernan_da_Silva, welcome to our community !

Is your “rol” column in your “usuarios” table an Enum of base type text?

Also do check this post out, it makes handling user permissions waaaaaaaaaaaaaaay easier:

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…

I believe you’re just one slice away from having it completely set up.

[Hernan_da_Silva]

Rafael, thank you very much for your quick and correct response!

Yes, you were right, insted of Enum, EnumList was being used, such a stupid error.

Thanks for your suggestion about slices. Currently im using security filter, because i definitevely don’t want any data to be access by users who shouldnt have that possibility, that is managed through another column in that same users table.

Again, thanks!