Filtering displayed choices in Text Multiple Choice field

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
  • (Edited)
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
Photo of Dirk Ruana

Dirk Ruana

  • 174 Points 100 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,774 Points 5k badge 2x thumb
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. 
Photo of Dirk Ruana

Dirk Ruana

  • 174 Points 100 badge 2x thumb
Hi Evan:

Thank you for this good information.

I will give it a go.

Regards,

Dirk