How to allow a user to view most fields in a table but to restrict certain fields unless they are the record's 'resource'
Hi there,
I have a resource table for all of our project staff. It includes non-private fields (like phone number and title) as well as private fields (like accrued vacation balance).
I would like all users to see reports that use non-private fields (so we can use it as a phone list), but I don't want users to see the private fields unless they are the user that the resource applies to (or are in a management role).
I can see how to restrict access to records by role (and by custom things like 'user is listed in field X) but this doesn't allow me to restrict by fields, just the records.
I can also see how to restrict fields based on roles, but that interface does not allow me to set up conditions like 'user is listed in field X'.
What do you think would work for this?
Thanks - Cam
I have a resource table for all of our project staff. It includes non-private fields (like phone number and title) as well as private fields (like accrued vacation balance).
I would like all users to see reports that use non-private fields (so we can use it as a phone list), but I don't want users to see the private fields unless they are the user that the resource applies to (or are in a management role).
I can see how to restrict access to records by role (and by custom things like 'user is listed in field X) but this doesn't allow me to restrict by fields, just the records.
I can also see how to restrict fields based on roles, but that interface does not allow me to set up conditions like 'user is listed in field X'.
What do you think would work for this?
Thanks - Cam
