Dropdown only showing certain options, possible?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I use several vendors, for jobs and when assigning a Vendor, I chose their name from a drop down.  After choosing the Vendor, I chose the purchase order that I will use to pay for the job from a different drop down.  

In the Purchase Order drop down, I see all vendors purchase orders.  I like to know if it's possible to only see the purchase orders related to the vendor I've chosen.
Photo of Jay (DDS)

Jay (DDS)

  • 430 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 50,850 Points 50k badge 2x thumb
On that drop down list, I assume that it is being chosen off a relationship from another table.

Look for the field on the table probably called [Related Purchase Order].  Then there will be a checkbox on that field  for 

Conditional values The values in this field depend on a selection in another field

Check that box and make the drop down choices conditional on the [Related Vendor] the POs field for [Related vendor] matching the [Related vendor] chosen on the first drop down.
Photo of Jay (DDS)

Jay (DDS)

  • 430 Points 250 badge 2x thumb
Worked like a charm!  Thanks!
Photo of Jay (DDS)

Jay (DDS)

  • 430 Points 250 badge 2x thumb
Let me ask this....Can I take it another level?  Here's the situation:  I use the process you outlined above and now see only the purchase orders for that vendor.  I have different purchase orders for different lines of service...we'll call them Directorate A, Directorate B and Directorate C.  Based on a field designating the Directorate the job is coming from, can I show only that Directorate's purchase orders?  Let me know if I need to clarify that a bit.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 50,850 Points 50k badge 2x thumb
"no problem",

So if you make a field which is a concatenated formula field called perhaps [Related Vendor - Line of Service] put it on the form

List("-", ToText(Related Vendor]),[Line of service])

 and then if your make a similar field on your purchase orders, then you can make the [Related Purchase Order] field conditional on those two fields matching.  Be sure to put the the first concatenated field on the form so that the form sees it.  Once it is working you may be able to hide it with a form rule.