How do I specify a sort order for a dropdown field?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of OCTO

OCTO

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
If it's a simple choice multiple choice field then there are option in the field properties to sort either alpha or else "in the order shown above".  So just rearrange the sequence there.

If it's a drop down from a relationship, you can make a report of the drop down choices within he table that has the choices, in the sort you like and specify in Form properties to use that report.
Photo of Jason

Jason

  • 0 Points
Sorry, I am not following the explanation for a relationship drop down. I made a custom report in my Master to order the records the way I like (I have numbers stored as text because I need to show fractions e.g. 1/8, 1/2 as well as whole numbers 2, 4, etc.). Obviously, the ordering gets screwed up in this case... So I created another field with the numeric representation and ordered based off that. When I use the drop down in another table's form, the order is not updated. I cannot see where to specify the report in the other table's Form Properties.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
In Form Properties for the drop down field, it will let you specify which report to use for the drop down.
Photo of Jason

Jason

  • 0 Points
I'm sorry, but I'm still not following. The only things I can see in the Form Properties are the following:

Form Name: ______

[ ] Display horizontal rules between sections
[ ] Display built-in fields
[ ] Allow field labels to wrap

When new fields are created in the Take-off - Spools table: ______

Nothing about drop-down fields.

Further, when I select that the relevant element in the Form Properties and open the Properties for it, there is nothing in there either.
Photo of Jason

Jason

  • 0 Points
Also, I built a report that is grouped and sorted by the two fields I am trying make conditional dropdowns out of: Pipe Size and then Pipe Schedule. Both of these are lookup fields from two separate tables.

I have 4 tables in total:

-Pipe Sizes (one column listing all the pipe sizes)
-Pipe Schedules (one column listing all the pipe schedules)
-Unit Man-hours (three columns of unique combinations between pipe sizes and pipe schedules and a specified numeric unit man-hour)
-Take-off (which I want to have conditional dropdowns for Pipe Size first, and then Pipe Schedule, so that it will automatically give me the associated unit man-hour for that unique combination)
Photo of Jason

Jason

  • 0 Points
I am so sorry. I figured it out. Because I asked so many questions I think it's only fair that I provide an answer. Ergo:

Still the same 4 tables as mentioned above.

The relationships:

-Pipe Schedules (Master) to Unit Man-hours (Details)
-Pipe Sizes (Master) to Unit Man-hours (Details)
-Pipe Sizes (Master) to Take-off (Details)
-Unit Man-hours (Master) to Take-off (Details) - In this table I set the Pipe Schedule lookup field as the proxy for the Related Unit Man-hour field.

They key, it seems, is having the Pipe Sizes table related directly to both the Unit Man-hours Table and the Take-off table. Then, by setting the proxy for the Related Unit Man-hours as the Pipe Schedule in the Take-off table, a conditional drop-down can be created.

Phew.