Forum Discussion

Cspangler's avatar
Cspangler
Qrew Member
4 days ago

How to Sort Specific Options in Drop Down List

Hey everyone, is it possible to sort 7 or 8 specific records to the top of a drop down list?

For context, there are 120 records in this drop down list, so they don't all show due to drop down list length limitations. They have to be searched for. However, I'd like to have the most commonly selected options put at the top of the list for quick selection without searching, but I can't change the naming scheme of the items for reporting purposes to do it the easy way.

The drop down list is pulled from a relationship, not manual entry of all 120 items for the list. To summarize, this is for utility poles. They all have their own class, species, and size. All of the pole info is in its own table. I used the concatenate formula to combine all 3 details (size/class/species) into one field for the delivery table, so the employees can pick the pole the delivered that day. I just want the commonly delivered poles shown at the top of this list.

Is this possible? The built-in AI says no, so I thought I'd give this a shot.

Thank you!

getting started on quickbase

3 Replies

  • John_Perkins's avatar
    John_Perkins
    Qrew Cadet
    16 hours ago

    I mentioned this in a local group chat, but if you really want the "most commonly selected" options at the top then you can add a Numeric Summary lookup field to the relationship. Then set your report that powers this list to sort that field in descending order. More relationships, the higher up it will be on the list.

    It really depends on what you want your final list to look like. Roy's suggestion is the common solution, just give yourself control over the sort order with an additional field.

  • MarkStrassel's avatar
    MarkStrassel
    Qrew Cadet
    3 days ago

    I often use just a checkbox. Then base the dropdown on a report where the report is sorted, not grouped, on the checkbox descending. Then any record where the box is checked goes to the top of the dropdown. Roy's suggestion is the answer if you want really granular control on the order of the items.

  • Roy-Wanyoike's avatar
    Roy-Wanyoike
    Qrew Assistant Captain
    4 days ago

    Try to create another field let say [Priority] and have the first 8 or 9 common used fields and then have option 99 for others.. Then create another report and use this field in the sort order. The report will sort them based on this field.