Forum Discussion

DirkRuana's avatar
DirkRuana
Qrew Captain
7 years ago

Filtering displayed choices in Text Multiple Choice field

Greetings!.... one more question from a beginner:

Can the displayed options in a Text Multiple Choice field be filtered based on the specific form the it resides (the Tasks Home Form)?

I have two fields in the Related Table:

1.) Supplier
2.) Supplier Type

I only want to display [Supplier] for [Supplier Type] = "Sub Contactor"

I hope that makes sense.

Any insight would be greatly appreciated.

Dirk
  • Hi Dirk,

    The functionality you are looking for is possible in Quick Base but it requires a little bit of building to get it set up. In Quick Base help documentation it is referred to as a Conditional Dropdown and you can build one making use of Quick Base tables and relationships. What you would do is create a table of Supplier Types with a record for each Supplier Type and then a table for Suppliers. Then you would relate each Supplier to the Supplier Type. Then in your current table you would have a relationship between Supplier Type and your current table and then Supplier and your current table. Then you can set them up so that once you have picked a Supplier Type you only see Suppliers who have the same Supplier Type. You can find the help documentation on Conditional Dropdowns that go into more details on the process here.

    They take a little building to get set up but can be very helpful for your end users to simplify data entry. I hope this information is helpful. 
    • DirkRuana's avatar
      DirkRuana
      Qrew Captain
      Hi Evan:

      Thank you for this good information.

      I will give it a go.

      Regards,

      Dirk