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

  • 1
  • 1
  • Question
  • Updated 4 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,644 Points 1k badge 2x thumb

Posted 2 years ago

  • 1
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 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

  • 69,592 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,644 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

  • 67,268 Points 50k 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,518 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

  • 80 Points 75 badge 2x thumb
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

  • 69,592 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 George

George

  • 80 Points 75 badge 2x thumb
No. I don't want the record picker.. I want the drop down. 

Thanks.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,592 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

  • 80 Points 75 badge 2x thumb
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

  • 69,592 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

  • 80 Points 75 badge 2x thumb
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

  • 69,592 Points 50k badge 2x thumb
the alternative is to filter off the report for part numbers which are inactive.
Photo of Javier Martinez

Javier Martinez

  • 356 Points 250 badge 2x thumb
I have a follow up question to this.  I have a list of over 1,000 (list of EE numbers) and don't want to do categories as suggested above.  Can you have the user type in their EE number instead of having the record picker or drop down?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,592 Points 50k badge 2x thumb
One solution is to allow both methods.
You can make a data entry field called [EE number direct entry].

Then you already probably have [Related Employee number or whatever the current relationship reference field is called.

Then have a formula called [Employee # (final)] field like 

IF([EE number direct entry]>0. ,[EE number direct entry], related employee number])

Then make a 2nd relationship to the Employees table and get any lookup fields only from that 2nd relationship.