hello i have an app for technicians who do jobs. I have a table with thech names wich has 2 columns with column A name and B email, i have a manager table with name and email in column A and B. in both tables in the security app formula i use this OR(IN(USEREMAIL(), Managers[Email]), USEREMAIL() = [Email]) wich is wokring perfectly. but now i need to give acces to a new manager but i dont want him/her to be able to add or mod or delete i want that he/she can only read.
Youโll need to set the tableโs Are updates allowed? property to an expression that matches your requirements.
the table is already set to add and update for managers and employees but i want to put one or maybe more managers to read only.
Did you find a solution to this?
i did found a solution. Is it the correct solution oh no it is not . Is it working ? yes it is!! So the solution was simply to copy the app and restrain the access for that particular person. In my case it was simple because it was a customer who only need to have a view only of the jobs it is not a big app with tons of information. If you have a huge app i would definitely not suggest this as an option!
I suggest to look at having a third security level for these new managers if their level of access requiremetns are different to the current managers and technicians
LOLโฆ Okay. Thanks
I keep trying a filter that will either look at the useremail() or managersemailaddy@gmail.com
Not having the best of luck interpreting the peoples help though.
Well Dan, what i can say is that is really hard to help you without having a global view of your app and what exactly will apply to your situation. There is a way and I know it is not an easy one. You might have to rework the employee/manager tab.
What exactly do you need your app to be doing in the end? managers have a full view of everything?
If there is anything i can do to help feel free to send me a private message.
I appreciate it.
Iโve tried both of these in the security filter section, and have had no luck
OR([driver email] = USEREMAIL(), Role = โadminโ)
OR([driver email]=USEREMAIL() , IN(USEREMAIL(), user email [Email M]))
I donโt know if those are valid expressions or not, but when a manager, whoโs email address is listed under the table, User Email, and in the column, [Email M] views the main page, itโs blank.
Same thing happens if I give them an admin role. Iโm pulling my hair out, here. And I donโt have much to begin with.
I am not an expression specialist!!!
well the OR() function means that any of these values is true have you tried AND(). The AND() function requires both of the values to be true.
AND([driver email] = USEREMAIL(), Role = โadminโ)
AND([driver email]=USEREMAIL() , IN(USEREMAIL(), user email [Email M]))
Thanks Andrian. Actually, or works well for my uses. The manager doesnโt have a driver number, so it works great.
thanks for the suggestion.
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |