Hide panel formula for drop down field for multiple choices

  • 13 April 2017
  • 4 replies
  • 14 views
C
Badge +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

B
Badge +6

Hi Cheri,

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

Thanks

Bashya Rajan A

C
Badge +1

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>

A
Userlevel 7
Badge +17

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

C
Badge +1

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

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings