Skip to main content
Nintex Community Menu Bar

Hide panel formula for drop down field for multiple choices

  • Apr 13, 2017 12:47 PM UTC
  • 4 replies
  • 48 views
  • Translate All

Forum|alt.badge.img+1

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

4 replies

Forum|alt.badge.img+6

Hi Cheri,

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

Thanks

Bashya Rajan A

Translate

Forum|alt.badge.img+1
  • Author
  • Apr 13, 2017 3:43 PM UTC

Thank you for your reply.

I figured it out by using contain(report type, report name)  It worked

Thanks again,

C

Cheri Bell

SharePoint Developer | ProSource Solutions, LLC

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

Translate

Forum|alt.badge.img+17
  • Nintex Partner
  • Apr 13, 2017 10:34 PM UTC

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

Translate

Forum|alt.badge.img+1
  • Author
  • Apr 14, 2017 12:45 PM UTC

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

Translate