I have a dropdown in my form that pulls from another list, and if you choose any item other than "Headset" from the dropdown, I want another field to be hidden. So if you do choose "Headset", the other field should appear.
Sounds easy, right? I can't get it to work. I'm using Nintex for O365 and have no other forms in place on my form, so it's not an issue of conflicting rules.
I've tried using not(inArray(Item, "Headset")), as well as Item!="Headset"
Both rules hide the field all the time, never showing it when "Headset" is selected as the option.
I can't figure out what I'm doing wrong, though I'm sure it's something simple I'm overlooking. Any help would be appreciated!!
Solved! Go to Solution.
Great question and yes it should be working. Here is the formula you want to use and the steps to get this functional in your form.
I hit preview and it worked... Hope that helps
It may help if you put the lookup control name inside a parseLookup() function which will strip out the lookup control's #mark and ID No from the lookup list. Then your comparisons functions should start to work:
I have used the not(contains(namedcontrol, 'Support Worker')) but to no avail. Can this be used on a control within a repeating field.
I have 4 potential contact lists to come into view based on a person's role/title selection in the field above. So on each of the contact lists I am setting the above rule.
e.g. on the SW contacts choice control that I want to appear based on 'Support Worker' role selection, I am adding the following; not(contains(contacts_role, 'Support Worker')) , then Hide.
I have followed this through for each list and each role but when I preview, all the lists are there all the time without even making a selection in the role field.
I am confused because I have used this same rule on other controls and it worked.
When I use the formula on my panel that you demonstrated and preview my form the panel is hidden. However, when I select the choice that I want the panel to display nothing is happening.
Choice field - Type of RFI: RFI
Multiple lines of text field (should be hidden unless OSINT RFI is selected).
Rule Formula applied to the panel that contains the text field: not(contains(Type of RFI, "OSINT RFI"))
This is set as a required field and does not have a choice default selected in order to force the user to make a specific option.
Am I missing something that would cause my text field to not display when OSINT RFI is selected?
You need to make sure you select the field you want from the "Named Controls" drop down and not the "Item Properties" Drop down. Selecting a field form the Item Properties list will give you the exact results you are seeing.