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
------------------------------
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
------------------------------
