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
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.