How to have a checkbox uncheck another checkbox?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I have 3 checkboxes - one for "submitting a record for approval", one for "updates needed" and one for approved.

I would like when the "updates needed" checkbox to be checked that it automatically unckecks "submitting a record for approval" checkbox.  I am sure there is a a formula for this, but I cannot figure it out.
Photo of Jason

Jason

  • 50 Points

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 52,826 Points 50k badge 2x thumb
If the data entry will be on forms, you can use Form Rules (assuming that you are on at least the Premier (middle) Quick Base plan and not Essentials.

Set up a rule
Condition:
When Updates needed is checked

Action:
Change the value in Submitting a record for approval to Unchecked.

(and uncheck that box at the bottom of the form for only fire when this condition becomes true)

here is some help on form rules
https://help.quickbase.com/user-assistance/form_rules.html
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Would it be more helpful to have those 'clicks' be buttons, rather than checkboxes?  So you can use them in reports, dashboards, and in view mode on a form?

If so I'd suggest creating 3 formula-url buttons that do the editing action of checking or unchecking as needed.