Hello all.
I have a rather large work request form I have created with rules that hide/unhide fields based on what the user has selected (at least 30 rules), so I already have a basic understanding of how to hide fields. However, I'm having trouble with the following scenario on a dropdown.
I have a free text field called "Cost Code", that I only want to display to the user when they select "Furniture Request / Repair", " Janitorial Services", "Nameplate Request", and "Office Moves / Reconfiguration" on a dropdown, but keep the field hidden if the user selects something else (at least 20 selections available in this dropdown). I have no problems displaying the cost code field when the user selects one option. For example: (RequestTypeDropdown!='Furniture Request / Repair') works just fine for one selection.
If I add a second option in the condition using an Or statement or adding a single rule for each of the four selections (for example, four rules with the following syntax: RequestTypeDropdown != "Option"), it doesn't display the cost code field at all. I have tried the following to no avail:
RequestTypeDropdown != "Janitorial Services" || RequestTypeDropdown != "Nameplate Request" || RequestTypeDropdown != "Nameplate Request" || RequestTypeDropdown != "Nameplate Request"
I have also tried the following:
or(RequestTypeDropdown !="Janitorial Services", RequestTypeDropdown !="Nameplate Request")
Is there a simpler way to do this? Its likely I'm overthinking this and the solution is right in front of me. Working in SharePoint 2013.
Thanks for any help you can provide.