I cannot seem to make a double argument work in a hide when formula.
Here is what I am attempting:
@UserName = Contact | @IsNotMember(“[Leads]” ; @UserRoles)
I am trying to let those in the “Leads” group and those whose name matches the name in the Contact field see the text.
With the formula above, the “Leads” group is able to see, but those in the Contact field cannot.
If anyone has an idea on how to make it work, please let me know.
Subject: Double arguments in the Hide When formula
The left side of the or says to hide it from people listed in the Contact field, so that’s what it’s doing. Try:
!(@UserName = Contact) | @IsNotMember(“[Leads]” ; @UserRoles)
Subject: You need an & between the conditions not |
Subject: RE: Double arguments in the Hide When formula
Additionally, make sure that the names in the Contact field are canonicalized. If they are common names, without the OUs and Os , or you should make this:
!(@Name([CN]; @UserName) = Contact) | @IsNotMember(“[Leads]” ; @UserRoles)
Subject: RE: Double arguments in the Hide When formula
Using my own past statements against me, Ben?
And yes, Bill’s right about the “&”.
Subject: I always find it easier to write a “Show” formula, then ! it.
i.e.Show := @UserName = Contact | @IsMember(“[Leads]” ; @UserRoles);
!Show
To use your original syntax:
@UserName != Contact & @IsNotMember(“[Leads]” ; @UserRoles)
hide if user is not contact and user is not [Leads]
Subject: I always find myself thinking in NAND gates – old hardware habit.