Hello Community,
Something weird is happening with my App,
I can’t delete or uptade any details with a specefic table despite the limitation formula i’m using that should allows me to make ALL CHANGES :
IFS(
USERSETTINGS(“USER ROLE”)=“SUPER ADMIN”, “ALL_CHANGES”,
USERSETTINGS(“USER ROLE”)=“ADMIN”, “ALL_CHANGES”,
USERSETTINGS(“USER ROLE”)=“CHEF ATELIER”, “UPDATES_ONLY”,
USERSETTINGS(“USER ROLE”)=“MAGASINIER”, “READ_ONLY”
)
i’m using USERSETTINGS formula to limit access to the table DETAILS CMD
Bellow some captures in order to get more details about this issue :
1- as you can see on this view i can’t modify anything on the table "DETAILS CMD"
2- this is capture of formula i’m using to limit access to the table "DETAILS CMD"
3- the table “DETAILS CMD” is a part of another table name COMMANDES bellow is a capture of limitation formula i’m using with the table COMMANDES i’m thinking that this informationmaybe be usefull…
Thanks in Advance
Solved! Go to Solution.
INDEX(Current_User[User_Role], 1)
To answer you question
All and all, Usersettings was a great idea but poorly executed; it was implemented at a time before actions were a thing, so we needed a way for people to store temporary variables easily.
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |