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

  • 1
  • 1
  • Question
  • Updated 7 months ago
  • Answered
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?
Photo of Jordan

Jordan

  • 1,574 Points 1k badge 2x thumb

Posted 1 year ago

  • 1
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
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"
Photo of Jordan

Jordan

  • 1,574 Points 1k badge 2x thumb
"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!
Photo of Devin

Devin

  • 362 Points 250 badge 2x thumb
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?
Photo of Devin

Devin

  • 362 Points 250 badge 2x thumb
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?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 47,544 Points 20k badge 2x thumb
Are you looking at the field called something like Related Parent. For this setting?
Photo of Brian Cafferelli

Brian Cafferelli, Quick Base Technical Marketing Manager

  • 1,324 Points 1k badge 2x thumb
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.
Photo of Devin

Devin

  • 362 Points 250 badge 2x thumb
Success, figured it out. Thank you Brian!
Photo of George

George

  • 70 Points
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?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
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.
Photo of George

George

  • 70 Points
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.
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
If they all start with P, then have the user first select from 0-9 (or P), P1, P2  etcc) and then  only show those ones, so only 10 th of the total records will be less than 1,000 records.
Photo of George

George

  • 70 Points
I understand what you are saying about adding an extra filter field ... but people have been using this the same way for years - they are acting like I broke the app :-(
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
the alternative is to filter off the report for part numbers which are inactive.