Access Issues
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?
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.
