Is it possible to apply combined form rules the way we apply filters in reports?

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

I have a form to which I need to apply a somewhat complex rule. To put it simply, my rule would be something like this:

If [Field 1] is blank AND [Field 2] is not blank

OR

[Field 3] is blank AND [Field 4] is not blank

Then...

Make Editable [Field 5]

(otherwise Make Read-Only [Field 5])


I'm looking for the ability to combine criteria in a single form rule because the Make Editable/Make Read-only condition applies to the exact same field. If I use separate rules it creates a conflict and only the highest number of these 2 rules will take effect.

Any help is greatly appreciated.

Juan

Photo of Juan

Juan

  • 20 Points

Posted 5 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,894 Points 50k badge 2x thumb
When the rule gets too complex, you need to make a formula field to do the complexity and then your form rule can just be

when


[my complex formula checkbox field] is checked

Action .....



Be sure to put that field on your form, even if you hide it with a rule like when my input field is 999999

then hide\[my complex formula field]

as the form rules tend to ignore fields that are not on the form and the form rule just fails to do anything.
Photo of Juan

Juan

  • 20 Points
Thanks Mark, that's the route I ended up taking.  The only issue is that apparently I had already used the max # of formula and look-up fields in my form and it was not letting me use this one. I ended up doing some additional rearranging of my form rules to be able to add this one, and it worked!  Thanks again.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,894 Points 50k badge 2x thumb
That limit of 20 derived field is a hard wall - so yes, its too easy to get sloppy at the beginning and waste those fields, so its good not to needlessly use up your derived field limitation on what you think will grow to be a complex form.
Photo of Juan

Juan

  • 20 Points
Exactly... Live and learn!
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,184 Points 20k badge 2x thumb
Use script - it does not have arbitrary limitations and it can detect any condition and implement any action.
Photo of Juan

Juan

  • 20 Points
Thanks Daniel, Oh how I wish I could!  I am so ready to do this, but don't know where to begin.  I only have VB scripting experience.