I have two fields in a form; 1 Author & 1 Readers the code is the same:
@UserName : "[CSRep]" : "[Office Manager]"
This works fine, ie it restricts anyone other than the author of the document or anyone who does not have the user role of "CSRep" or "Office Manager" from either editing it or infact reading it.
The issue i have is with the view, as everyone regardless of the above restrictions can see the totals in the view, i have played with the following selection code, but to no avail:
& @IsMember(@UserName; Authors) | @IsMember(@UserName; Readers)
What i am after is the user only seeing his/her docs and only the totals that relate to those docs and not the totals of all the fields regardless of being able to view the invisible docs that the totals relate to.
Any help would be great Thanks