Skip to main content
Question

Sort a conditional dropdown - 2021

  • July 7, 2021
  • 0 replies
  • 58 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • July 7, 2021
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
------------------------------