Skip to main content
Question

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

  • May 17, 2017
  • 0 replies
  • 110 views
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?

      • MCFNeil
      • Quickbase Alumni
      • May 17, 2017
      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
      • JordanBeatty1
      • Author
      • Quickbase Alumni
      • May 17, 2017
      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
      • Quickbase Alumni
      • February 16, 2018
      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?
      • GeorgeFong
      • Quickbase Alumni
      • April 19, 2018
      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?
      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.
      Terms & ConditionsAccessibility statement