Search a Dropdown Field

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • In Progress
Hello, I have a dropdown field that has hundreds of options, any way to add a search field for this instead of endless scrolling to find the option i need?

Thx
Photo of GH

GH

  • 576 Points 500 badge 2x thumb

Posted 8 months ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
In the properties for the drop down field, you can select "Use record picker instead of a drop down menu". This will give you a search box.
Photo of GH

GH

  • 556 Points 500 badge 2x thumb
sorry i forgot to mention that the dropdown is a related field dropdown.

Eg. related products to a category (supplier)
Photo of GH

GH

  • 576 Points 500 badge 2x thumb
sorry i forgot to mention that the dropdown is a related field dropdown.
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
So... Go into the field options for the related field. There is a section in the properties call Reference Field Options. You'll see the check box I'm talking about there.
Photo of GH

GH

  • 556 Points 500 badge 2x thumb
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
Okay, then what I'm suggesting must come with a different plan. The interface does not have all the options in the properties.
Photo of GH

GH

  • 576 Points 500 badge 2x thumb
Weird, right.  This is an administrators view for the Platform plan.  did they take the option away?
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
I have the platform plan as well. I'll show you my screen shot.
(Edited)
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
Checking the above high lighted check box would give you the desired searchable dialog box.
Photo of GH

GH

  • 576 Points 500 badge 2x thumb
maybe because it is a text(lookup)

Thanks for your help, might be a custom script thing I will need to do
(Edited)
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

I would ask QB Support. Take my screen shot and ask them why you don't see the same thing. Any drop down list for a related lookup field ought to give you the record picker option.