Form rules: Include both an 'ALL' and an 'ANY' condition within the same rule

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

I'm hoping there is an easy way to achieve this that I'm just not aware of. 

I want to include both the 'ALL' and 'ANY' condition in a rule I'm creating:


When

Multiple Conditions [are true]

When [all] of the following conditions are true:

[Checkbox 1] [is equal to] [checked]

[Checkbox 2] [is equal to] [checked]

and when [any] of the following conditions are true:

[The user] [is in the role] [administrator]

[Assigned user] [is equal to] [the current user]

Action
[Make editable] [Field 1]
Is there a way I can achieve this?
Thank you!
Photo of Barnee

Barnee

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
I don't think that you can do that in that way. You will need to make a single field called [Checkbox 1 and Checkbox 2 are checked] and use that in your Form Rule.The abbreviated  formula would be
[Checkbox 1] and [Checkbox 2]


or if you want to be wordy
IF([checkbox 1]=true and [Checkbox 2] = true, true, fasle)
Photo of Barnee

Barnee

  • 0 Points
Hi,

Sorry I forgot to thank you for your response. This is what I have ended up doing.

Thank you!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
Geat, glad it worked.  Note that if these checkboxes are going to be checked on the form in edit mode, you probably need to have that field on the form even if it's in a hidden section. Then you can be sure that the formula will dynamically update as the data entry happens in the form.
Photo of Barnee

Barnee

  • 0 Points
You are correct - I realized this after I tried it. I placed it in a section that could only be viewed by administrators
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
The other method is to put it in a section which is hidden when some field is equal to 9999999, ie a value that it will never be,