Currently, I am setting up alternate relationships between tables for filtered drop down tables. I join the two tables on record ID, then use a proxy field that is a text look up and use a report I generated instead of the standard record picker. I am getting all the entities I am looking for but they are displayed in the pop up record picker for selection, is there any way they can be in a drop down selection instead?

Once your list gets too big QB automatically makes it a 'Record Picker', but if its still small, you can change the field properties for your 'Related XXXXX' field. There is a checkbox, to 'use a record picker' rather than the standard dropdown. Just make sure that is unchecked.

The system will force the pop up record picker if there are more than 1,000 choices being offered to the user. You can also intentionally (or perhaps unintentionally) force the pop up record picker by a setting on the field for Related Parent called "Use a record picker instead of a drop down menu

Use a record picker instead of a drop down menu" was check off, and good to know about the over 1,000 choices forcing you to use a record picker. Thanks for the help guys!

I am not able to find the "Use a record picker instead of a drop down menu" for the field in my app. In my case, I have a child table that has a form to select the a parent record to relate to. In the child table's field properties, this option does not appear. Am I missing something?

As it turns out, the field in question is setup as a 'lookup' field type. I assume this restricts it from being used as a record picker? If so, is there a way to convert the field type without wrecking the relationships which have already been created?

Use a drop down menu instead of pop-out record picker

18 Replies

MCFNeil
Qrew Captain
8 years ago
Once your list gets too big QB automatically makes it a 'Record Picker', but if its still small, you can change the field properties for your 'Related XXXXX' field.

There is a checkbox, to 'use a record picker' rather than the standard dropdown. Just make sure that is unchecked.
QuickBaseCoachD
Qrew Captain
8 years ago
The system will force the pop up record picker if there are more than 1,000 choices being offered to the user. You can also intentionally (or perhaps unintentionally) force the pop up record picker by a setting on the field for Related Parent called

"Use a record picker instead of a drop down menu
JordanBeatty1
Qrew Captain
8 years ago
Use a record picker instead of a drop down menu" was check off, and good to know about the over 1,000 choices forcing you to use a record picker. Thanks for the help guys!
DevinDevin
Qrew Cadet
7 years ago
I am not able to find the "Use a record picker instead of a drop down menu" for the field in my app. In my case, I have a child table that has a form to select the a parent record to relate to. In the child table's field properties, this option does not appear. Am I missing something?
- DevinDevin
  Qrew Cadet
  7 years ago
  As it turns out, the field in question is setup as a 'lookup' field type. I assume this restricts it from being used as a record picker? If so, is there a way to convert the field type without wrecking the relationships which have already been created?
- QuickBaseCoachD
  Qrew Captain
  7 years ago
  Are you looking at the field called something like Related Parent. For this setting?
- BrianCafferelli
  Qrew Captain
  7 years ago
  Hi Devin, the reference field is what controls the record picker behavior. So, to find "Use a record picker instead of a drop down menu" you can go to the field properties for the reference field within whichever relationship you're working with. On that page, you'll see it under the "Reference field options" heading.
GeorgeFong
Qrew Trainee
7 years ago
I have more than 1,000 choices (grow over time). The drop down is much faster for me. How to I force the drop down?
QuickBaseCoachD
Qrew Captain
7 years ago
Look for the field typically called Related Parent. (Whatever your Parent is called). Then edit the field properties for that fiel then there is an option to force the Record Picker.
- GeorgeFong
  Qrew Trainee
  7 years ago
  No. I don't want the record picker.. I want the drop down.
  
  Thanks.
- QuickBaseCoachD
  Qrew Captain
  7 years ago
  A solution is this is to set up a Conditional Drop down and have the user first select a letter of the alphabet or a range of letters like A-K and L-Z.
  
  Then he dropdown for the choices will be less than 1,000.
  
  So you would have a multiple choice filter, say 26 choices form a to Z.
  
  The make a calculated field on the main data field to calculate that same value, ie the first letter.
  
  Then make the drop down be conditional on having first selected the letter of the alphabet.
- GeorgeFong
  Qrew Trainee
  7 years ago
  Yes but this is field for entering part numbers. All values start with a 'P'. So it is a lot faster to type 'p1001' than the name of the product.