I have a form that has 4 sections, that I want to hide or show, based on the selections from two dropdowns.
Conditions:
If dropdown 1 = "Approval" & dropdown 2 = "A" OR "B" then hide sections 2,3
If dropdown 1 = "Approval" & dropdown 2 = "C" then hide sections 2,3 and show section 4
If dropdown 1 <> "Approval" & regardless of the value in dropdown 2, I would like it to hide sections 2, 3, 4
How can I do this? by the time it gets to the third rule, it shows all the sections.
Qrew LegendJust like in the movie "Cool Hand Luke", you need to get your mind right, and create a rule per field and not per situation.
Follow this link back to a post that fully explains what I mean.
https://community.quickbase.com/discussions/quickbase-discussions/dynamic-rule---or-statement/89604
Have you tried mapping out the logic in reverse?
Instead of focusing on the field values, the 1st thing is consider is what needs to show. List all of the possible form configurations, starting with the most "restrictive" to the most "permissive".
These are probably not all valid options for your form, but I'm just working with the example you gave us. You probably don't need all of these. Anyway, now that all the form configurations are defined, under what circumstances are each of these supposed to happen?
Pay attention to overlapping logic, such as using [Field 2] <> "C" instead of "equals A or B" for clarity and to be more concise.
Building with this mindset should help you get to your desired results.
