Discussions

Expand all | Collapse all

Sort a conditional dropdown - 2021

  • 1.  Sort a conditional dropdown - 2021

    Posted 26 days ago
    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
    ------------------------------


  • 2.  RE: Sort a conditional dropdown - 2021

    Posted 26 days ago
    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
    ------------------------------