Link to home
Start Free TrialLog in
Avatar of Audra Breedlove
Audra Breedlove

asked on

More than 5 conditional formats for dropdown list in Infopath 2007

Hello,

I am never to Infopaths forms and am having a bit of a challenge.  I have a drop down field called Type of DG Incident.  

The field has a list of 7 items in the dropdown list.
Agency audit notification
Carrier rejected DG shipment
Chemical Spill at Co. location
Chemtrec response
Dangerous Goods audit finding
Incompatible chemical storage
Other

Based on which selection is made, certain things will occur.
If Agency audit notification, Chemtrec response orIncompatible chemical storage is selected, nothing happens.

If one of the below is selected, I need 2 fields to appear below the selection:
Carrier rejected DG shipment
Chemical Spill at Co. location
Dangerous Goods audit finding
Other

1st field has a default value
2nd field for open text

I tried conditional formats on the section, but the system will not let you do more than 5.  I tried writing an expression, but I don't think I wrote it correctly.

I'm just not having any luck

Could someone please tell me the best way to get the desired results (i.e. should I use sections)?  If expressions or the best way to go, how do I write the expression to make this work?

Sincerely,
ablove
Multiple-Conditional-Formats.docx
SOLUTION
Avatar of Clay Fox
Clay Fox
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Audra Breedlove
Audra Breedlove

ASKER

I believe I understand.  Let me try that.  Am I writing my expressions correctly?

I'm using a key word in each phrase
Agency audit notification (Agency)
Carrier rejected DG shipment  (Carrier)
Chemical Spill at Co. location (Spill)
Chemtrec response (chemtrec)
Dangerous Goods audit finding (dangerous)
Incompatible chemical storage (storage)
Other (other)

How should I set up the sections?  Should I use contains or does not contain using a key word key word?
Example, if I only want Agency audit notification to have popup fields, what's the best way to write the expression on the other sections, so that they will not appear?
So if you wanted a section to only appear when dropdown = Agency

You would add conditional formatting dropdown not equal to Agency
action would be to hide

So then if the dropdown is not equal to Agency then the section will not appear

It gets a bit more complex if you want a combination since the ands and ors get reversed.

Typically you play with it and often I change my join (and/or) first thing since that is the most common.
Playing with it was the best solution.

My solution:  I found that my keywords were not in the exact case of the word contained in the field and that my conditional format and expressions should have been listed in the order they appeared in the section.  I also learned, from my coworker, that I could have used one conditional format with "does not contain" and this was much easier and faster than the route I went.
I've requested that this question be deleted for the following reason:

My solution: I found that my keywords were not in the exact case of the word contained in the field and that my conditional format and expressions should have been listed in the order they appeared in the section. &nbsp;I also learned, from my coworker, that I could have used one conditional format with &quot;does not contain&quot; and this was much easier and faster than the route I went.<br /><br />
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ignore