Discussions

 View Only
Expand all | Collapse all

Checkbox ""Severice"" is chosen the dropbox field {Type} is to display different values than those values for checkbox ""Contract

  • 1.  Checkbox ""Severice"" is chosen the dropbox field {Type} is to display different values than those values for checkbox ""Contract

    Posted 05-24-2019 13:50
    I have two checkbox's - If checkbox "Service Call" is selected then the next field {Type} which is a drop down box needs to display 4 different values user can choose. If the user selects  checkbox "Contract Work" then the same drop box {Type} is to display a different set of values. How can this be done?


  • 2.  RE: Checkbox ""Severice"" is chosen the dropbox field {Type} is to display different values than those values for checkbox ""Contract

    Posted 05-25-2019 01:22
    Brady, This can easily be achieved with Conditional Drop down fields.
    https://help.quickbase.com/user-assistance/conditional_dropdowns.html

    You have a simple case so I will describe a simple setup.

    Make a new table called Work Choices with all your drop down choices.  The table will have two fields.  The first will be the Type which in your use case can be a simple Multiple choice required field with the two choices of 

    Service Call
    Contract Work

    The second called Work Category will hold your 6 choices

    Then make a relationship where 1 Work Choices has Many Work Orders (or whatever your main table is called).  Look up the Work Category down to Work Orders and set the field property for the Proxy field for Related Work Type to be the Work Category lookup field.

    Put the field Work CategoryType on the Work Order Form.

    Then edit the field properties for Related Work Category to make it conditional on first selecting the Type to only show choices in Work Category which match.

    If you already have a working app with lots of data that you do not want to disturb when you do this, then before you make the relationship you will need ot set the Key field of your Work Category Choices table to be the Work Category field. Then when you make the relationship, you will need to set your current, presumably multiple choice, field as the reference field for the relationship.

    Post back if you get stuck anywhere.