Access Issues

Question

I have a 1 app - and 1 table. there are 5 users
all the users have access to all the fields on the form on the table to view or edit the fields in the own record. So permission is view and modify all fields. and record level restriction is where owner is the logged in user. There is record level resctriction so user 1 cannot see user 2 records.
i want to make a report where all the users can view all the records 5 particular fields. but cant view or modify the record of other users.
However i want to create a visibility report to show all records from today to all the users but only a few limited fields. I have created the report, disable view and edit to the records and given all records access to the user. But the problem is if the user 1 will do advance search randomly, they can view all records from default search results. If I restrict that then no user will be able to open the records from the search which will be a blocker. how do i get past this ?

if i restrict field level then they wont be able to enter or modify their own records as well. so cant do that. how to achieve this?

MarkShnierYou · Accepted Answer

My suggestion is to create a Connected Sync Table where you bring across just those 5 open unrestricted fields.  Its very easy to set that up and set it to refresh hourly during the day time working hours.  Open up access to all users.

DonLarson · Answer

With out reviewing the application, I believe that you need to create tightly controlled dashboards that have reports that will allow the Users access to only the data allowed for their role.

Disable the Advanced Search

Dashboard reports filter on Record Owner = User

One daily report which shows all the records but there is no View or Edit ability.

Hide all tables from the Users disabling the ability to run or create custom reports.

You are creating a very tightly controlled experience for the Users.

Sign up

Login to the community