Forum Discussion

ChyanneEyde's avatar
ChyanneEyde
Qrew Trainee
3 years ago

Sort a conditional dropdown - 2021

Hello! There appears to be one thread from 2014-2017 about this topic, but the resolution wasn't clear to me. https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=0112776b-ef07-4b2b-a4a5-2ffc58855cbd&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer&reply-inline=b87f0714-720e-4931-ab8a-58bcc2c79499

I have a text field called Type that appears on a form as a conditional drop-down. I want the "other" option to appear last. I have a numeric field called Sort Order- with 1 for every record except "other". In the default table settings I made the sorting field Sort Order. My default report appears with "other" at the end, but the drop-down did not. 

I then changed my record picker settings so that Sort  Order appears in the drop down. This gives me the order that I want, with "other" last, but doesn't look great. (Screenshot below)

Is there a way to sort a conditional dropdown based on another field, without making that sorting field appear itself in the dropdown? 



------------------------------
Chyanne
------------------------------

1 Reply

  • You can make a report with any fields you like and any sort order.  The set the form property for that drop down field field to use that report.

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