cancel
Showing results for 
Search instead for 
Did you mean: 
cheridbell
Nintex Newbie

Hide panel formula for drop down field for multiple choices

Jump to solution

I have a form that uses a Report Type field to hide a part of the form based on the selection.

Compliance

Walkthrough, Testing and Assessment

Walkthrough, Testing and Assessment with Compliance

Testing

Compliance is the Default.  The form should be hidden if either Walkthrough type is selected.

I have gotten the formula to work with 1 selection, but not if either is selected.

 

Report Type!='Walkthrough, Testing and Assessment'

works as expected, but I have not been able to get the "or" formula to work.  I tried:

 

Report Type!='Walkthrough, Testing and Assessment'||

Report Type!='Walkthrough, Testing and Assessment with Compliance'

this doesn't work.  I also tried:

Report Type!='Walkthrough, Testing and Assessment'||'Walkthrough, Testing and Assessment with Compliance'

I thought about using the Contains function, but I'm not sure how to create the formula.

Any suggestions?

Thanks

Cheri

0 Kudos
Reply
4 Replies
bashyarajan
Nintex Newbie

Re: Hide panel formula for drop down field for multiple choices

Jump to solution

Hi Cheri,

         Please have  a look into this   ... This might help  you.

Thanks

Bashya Rajan A

0 Kudos
Reply
Highlighted
cheridbell
Nintex Newbie

Re: Hide panel formula for drop down field for multiple choices

Jump to solution

Thank you for your reply.

I figured it out by using

Thanks again,

C

Cheri Bell

SharePoint Developer | ProSource Solutions, LLC

773-822-6137 cell | cbell@prosource-corp.com<mailto:cbell@prosource-corp.com>

0 Kudos
Reply
andrewg
Nintex Newbie

Re: Hide panel formula for drop down field for multiple choices

Jump to solution

Cheri, I didn't see the image you posted, what was your solution again? Thanks for responding back

Reply
cheridbell
Nintex Newbie

Re: Hide panel formula for drop down field for multiple choices

Jump to solution

Sorry, i could not add an image.

I used the formula builder to create this formula:

!contains(Report Type,"Report Name")

where I typed "!", chose "Contains" from Runtime Functions and "Report Type" is a "Named Controls" and "Report Name" is the name of the report in double quotes.

Hope that helps.

Cheri

0 Kudos
Reply