I have a dynamic view set up to function as an evaluation scorecard. The view pulls from a master sheet with all employees being evaluated. Each row is tagged with a dropdown selection in the "Division" column. The view displays only one scorecard to the person being evaluated and a group of scorecards to a division's supervisor. This operates off of a filter allowing only the "current user" for two contact columns (Evaluatee Email, Division Chief Email) to view the pertinent rows.
What I would like to accomplish is having certain fields in the dynamic view rows set as read-only for the evaluatee but other fields as editable by both the evaluator and the person being evaluated. Is there a way to restrict access to fields based on the contact viewing the scorecard in Dynamic View? I'm having a hard time thinking through a solution so any ideas are more than welcome!
