Hi there - I am trying to hide a bunch of fields from all users except for one - I am assuming that I should highlight those rows, go into the text properties, and click on the Hide tab - but I just can’t figure out what the Hide formula should be.
Could anyone help me with writing such a hide from all users except one person formula?
Really appreciate this!
Regards - Marni
Subject: Hiding some rows from all users except one
If you are hiding fields you could use something like…
@Name([Abbreviate];@UserName) != Requstor
Where Requestor is a field containing the abbreviated name of the person you want to see the field.
HTH,
JB
Subject: Hiding some rows from all users except one
I think you’d be much better creating a role in the ACL, assigning that user to the role and then ensuring that those roles can only be seen with a user that has that role enabled-
Either,
@isnotmember(“[UserRole]”;@userroles)
Or
@userroles*=“[UserRole]”
HTH
Andrew
Subject: RE: Hiding some rows from all users except one
Okay - thanks much!