Text field using "From another field", but filtered

  • 0
  • 1
  • Question
  • Updated 3 years ago
We have a text field that uses the input type of "from another field" (in our case company name).  We'd like to be able to filter this to show certain companies (based on the type of company).  Is this possible?  I found a similar question below, but there wasn't an answer.  Hopefully I'm overlooking something with this.

https://quickbase-community.intuit.com/questions/1368713-can-i-filter-multi-select-field-values-pulled-from-another-field

Thanks in advance,
Dave
Photo of David

David

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
If you want to be able to filter then you will need to have a Relationship where 1Company has Many records. Then on the form properties for that drop down field you can use a filtered report of say just Active Companies instead of he default Record Picker.