Does anyone have any rules logic that for show/hiding a field based on two different columns? The scenario I am trying to accomplish is in my form I have a field called Category. If the user selects "Capital" from that dropdown it will display another field in the form called "Capital Type" using the rule Category !="Capital" which works.
However, I also have a requirement that on another column named "SubCategory" that includes 3 choices and if one of those are selected then I'll need to display the "Capital Type" field as well.
Does anyone have any suggestions for logic to have the "Capital Type" field displayed based on rules from two columns? If I append my current formula rule to include checking against the second column the rule stops working.
Does NOT work Category != "Capital" || SubCategory !="Capital IT Project"
Solved! Go to Solution.
rule action (hide) is taken when your formula evaluates to true.
if I understood your requirement correctly, you want to show capital type if category == 'Capital' OR SubCategory == 'Capital IT Project'
so to turn it to hide rule it should look like category != 'Capital' AND SubCategory != 'Capital IT Project', isn't it?
Marian is right. If you switch your Formula to Category != "Capital" && SubCategory != "Capital IT Project" it will work.
In your formula the field will still be hidden even if SubCategory contains the value you need because Category is still not Capital and thus the first part of your Formula will hide the control.
Hi Marian and Enrico,
Thanks for responding to my post so quickly. How do I get the field to show if Category is not capital, but the SubCategory choice is "Capital IT Project?"
Thank you Marian. I used this without the not logic and it worked. The only issue I am running into now, is when I add the SubCategory statement, it's not recognizing one of the choices in the category field.
In the category field, I have the following choices: capital, commercial, IT, TT, and Site. The rules are only to run if the user selects "Capital" or if they select "IT, TT or Site." Selecting IT, TT or Site gives them the "SubCategory" field.
Selecting "Commercial" should not display any of the other fields, but when that choice is selected, the rules that I applied stop working. Any ideas?