Skip to main content
Question

dynamic form rules

  • Sep 3, 2025 3:20 AM UTC
  • 3 replies
  • 211 views

Forum|alt.badge.img

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.

3 replies

Maria
Forum|alt.badge.img+21
  • Community Admin
  • Sep 3, 2025 11:48 AM UTC

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". 

  • Hide sections 2, 3 & 4
  • Hide sections 2 & 3, show 4
  • Hide sections 3 & 4, show 2
  • Hide sections 2 & 4, show 3
  • Hide section 4, show 2 & 3
  • Hide section 2, show 3 & 4
  • Hide section 3, show 2 & 4
  • Show sections 2, 3 & 4

 

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? 

  • [Field 1] <> "Approved"
  • [Field 1] = "Approved",  [Field 2] <> "C"
  • [Field 1] = "Approved",  [Field 2] = "C"

 

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.


MarkShnierYou
Forum|alt.badge.img+24

Just 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

 


Top Step
Forum|alt.badge.img+12
  • Observing
  • Oct 24, 2026 8:50 PM UTC

The problem is that every form rule gets an automatic Otherwise that reverses it. With 3 rules touching the same sections, the last one to run undoes what the earlier ones did, which is why everything ends up showing.

The easiest fix is to move the logic out of the form rules. Make a formula checkbox field for each section, like Show Section 4, and put the conditions in the formula:

[Dropdown 1] = "Approval" and [Dropdown 2] = "C"

Then each section gets one simple rule: when Show Section 4 is checked, show section 4. The Otherwise hides it automatically.

Each section's logic lives in one place, the rules never fight each other, and you can drop the checkboxes on a report to test your combinations.