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.
Hello,
YES i’m using App Formula to determinate the user Role :
ANY(SELECT(USERS[USER ROLE], ([NOM D’UTILISATEUR]= [_THISROW].[USER_NAME])))
Hello
Any Feedback Please @MultiTech_Visions
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.
Thank You so much !
Those details helped me a lot
User | Count |
---|---|
42 | |
28 | |
24 | |
24 | |
13 |