Discussions

Expand all | Collapse all

The browse fucntion in a related field

  • 1.  The browse fucntion in a related field

    Posted 25 days ago
    When relating tables and making a selection from the related field - I've noticed that after a certain qty of entries (anyone know this number? 1000? 5000?), the search changes and allows for a 'Browse' option, and you get a pop up and can browse.

    Is there a way to force this behavior to always happen, or set the number of choices lower so it happens sooner?

    ------------------------------
    Mike Tamoush
    ------------------------------


  • 2.  RE: The browse fucntion in a related field

    Posted 25 days ago
    I believe at 1,000 records you are forced into Browser.  There used to be a setting to force the browse  type record picker, but I think that when they improved the way that the drop downs filter they took away that option.  It must be an unusual use case to want the Browse method.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: The browse fucntion in a related field

    Posted 25 days ago
    That's true for me - it is just one particular unusual case that it would be helpful. Normally I just filter it to a smaller amount of choices.

    My use case is that in a certain scenario, my users are in grid edit mode and need to select a certain record from a record picker dropdown. The problem is, they can't just type in the record ID number and search, like in many other places in QB. They literally have to scroll down a list of 800 items and find the one they want. The record ID is my first field, but it doesnt just say the number, the report automatically lists the field name then a hyphen, then the record ID. I believe when you type to search it is only looking at the first character, so its always pointing and searching the field name.

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 4.  RE: The browse fucntion in a related field

    Posted 25 days ago
    Sorry, I did not realize you were in Grid Edit.  Go to the field properties for [Related Parent] and check the box for

    Use a record picker instead of a drop down menu for grid edit

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------