I copied a dynamic rule 3 times, changed one condition on each, but only whichever rule is on the bottom works. How do I get all 4 to work?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a dynamic rule that says if the area is "a," and the requester email = 1 of 7, show and check a checkbox. It worked.

I copied the rule 3 times, and changed the area to "b," "c," "d," on each rule. But now, only the lowest rule on the list will show and check the checkbox. 

I did it this way because I have one notification attached to "a" if the box is checked, and another notification if the area is b, c, or d and the box is checked. 


Photo of Tyler


  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,208 Points 4k badge 2x thumb
Your rules cannot conflict with each other.  A rule will operate one way, and in all other situations the other way.  So if multiple rules are trying to make one value/section/field operate differently under different conditions you have to combine rules so that they work together using an ANY statement or an ALL statement.  You cannot combine ANY and ALL together, however.

If you cannot achieve this, you may need to use a formula field to derive an output that works with an ANY and ALL combination; and then use this formula field in your Form Rule to control behavior.

You may, in your case, need to use a formula checkbox to derive if the Area is B OR C OR D (this would be your first rule selection); and then if "ANY" Requester Email = XXX or Requester Email = YYY etc.