Re: Limiting users to view only

Andrian_Andreev · 05-22-2019 01:15 PM

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.

Steve

You’ll need to set the table’s Are updates allowed? property to an expression that matches your requirements.

Andrian_Andreev

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.

dan_R

Did you find a solution to this?

Andrian_Andreev

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!

1minManager

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

dan_R

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.

Andrian_Andreev

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.

dan_R

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.

Andrian_Andreev

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]))

dan_R

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.