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

Question

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?

QuickBaseCoachD · Answer

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.

Sign up

Login to the community