Discussions

 View Only
  • 1.  How to have a checkbox uncheck another checkbox?

    Posted 10-26-2017 12:38
    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.


  • 2.  RE: How to have a checkbox uncheck another checkbox?

    Posted 10-26-2017 12:48
    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


  • 3.  RE: How to have a checkbox uncheck another checkbox?

    Posted 10-26-2017 19:18
    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.