Problems with views and table settings formulas

AppSheet AppSheet Q&A
,
1

In my application I set some formulas, both on the view side and the table settings so that I could manage the access permissions to the information. I specifically used the LOOKUP() formula to check that the current user (USEREMAIL()) had the right role. To do so I have created a user table with a column “role” with the specific values.

Everything worked perfectly until this morning when this warning showed up: “…” in the expression assistent and now both the views and the permissions on the table settings side have gone bad. I know for a fact that the formulas are correct as they have always worked but now they don’t work.

table settings formula problem.png
table settings formula problem.png925×509 39.3 KB

views formula error.png
views formula error.png921×384 26.9 KB

Is this a temporary malfunctioning or how can I fix this problem?

2

For Show If try to use this formula:

In(Useremail(),Select( utenti[Mail], OR([Ruolo]=“Amministratore” ,Ruolo]=“PM Giubileo” )) )

3

I resolved the problem. In the end the error was in the column order of the user table (I modified the DB without regenerating the structure in AppSheet). The formula that you posted works as well as the one that I wrote down. Thank you anyway for the answer.