I am attempting to hide a column in a view based on a user’s roles in the access control list.
As I understand it, per the help database, @UserRoles will not work in a column hide when formula:
“This function does not work in column, selection, mail agent, or scheduled agent formulas.”
So I was wondering if there is an alternative way to hide the column? I would also like to avoid making duplicate views with one being displayed for a particular role and another for all others.
Subject: it should work in column’s hide-when formula
the documentation refers to the formula for displaying the data in the column, not for the column’s hide formula. try it.
Subject: Has been tried
I have tried it, though. That’s what prompted my investigation into this.
This is what I placed into the hide formula:
!(@IsMember(“[Private]” ; @UserRoles))
(Edit) I’ve also tried:
@IsNotMember(“[Private]” ; @UserRoles)
However, it is hiding it even if I am assigned to the Private role.
Subject: works OK for me
just tried it, this works for me. If I have the role the column is hidden.
@IsMember(“[Private]” ; @UserRoles)
Likewise, if I don’t have the role and change the formula to this then I also do not see the column
!@IsMember(“[Private]” ; @UserRoles)
Subject: Strange
That’s very strange… Well I just ended up making a new role and it works properly now. It wouldn’t have had anything to do with the server it was being viewed on having the Private role, would it?
Regardless, thanks for the help.