cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide a Panel using a Lookup Function in Rules

Hi,

 

I am trying to hide a panel using a rule with the formula below:

 

not(userEquals(Current
User
,SourcingMgrLANID))||not(userEquals(Current
User
,lookup("Approvers","ID",4,"Director LAN")))

 

The formula above is comparing the Current User to the LAN ID of two other fields, one for Sourcing Manager and one for Director. If either one of those are false (current user is not equal to field) the panel should not display. These formulas both work individually, however if I add an or() or ||, they both don't work. Does anyone know how I could resolve this? Thanks!

Labels: (1)
0 Kudos
Reply
2 Replies
Community Manager Community Manager
Community Manager

Re: Hide a Panel using a Lookup Function in Rules

Nick,

You mentioned that both formulas worth by themselves, but have you tested whether the values render true or false when added together.  Essentially ensure that your value will actually render a true value for the formula.

0 Kudos
Accept as Solution Reply
Not applicable

Re: Hide a Panel using a Lookup Function in Rules

Hi Eric,

I tested both of the formulas and their results. They both return the

correct values, however they both don't seem to work when they are joined

together using or. Is there something I am missing or maybe another method

that may do the trick?

This e-mail, including any attachments, is intended solely for the person

or entity to which it is addressed and may contain confidential,

proprietary and/or non-public material. Except as stated above, any

review, re-transmission, dissemination or other use of, or taking of any

action in reliance upon this information by persons or entities other than

an intended recipient is prohibited. If you receive this in error, please

so notify the sender and delete the material from any media and destroy

any printouts or copies.

0 Kudos
Accept as Solution Reply