Skip to main content
Question

How to have a checkbox uncheck another checkbox?

  • October 26, 2017
  • 0 replies
  • 32 views
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.
    This topic has been closed for replies.

    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
    • MCFNeil
    • Registered
    • October 26, 2017
    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.
    Terms & ConditionsAccessibility statement