How do you change the sort order for a conditional drop-down?
It's displaying them alphabetically. That doesn't work for my situation. I need to specify the sort order. Is there a way to do this?
Forum Discussion
I went back to my app which had the problem - in my case the issue was that numbers were not sorting correctly, because $5,000 was sorting after $10,000 as 5 is "higher" than 1.
I created a text field to mirror the numeric field, but I put leading spaces in front the the smaller numbers using a formula. That way my $5,000 really was (space)$5,000 and hence sorted before $10,000.
So the other method is to have a sort field to display and contrive leading spaces to control the sort - say the top of the list gets 3 leading spaces, and then next gets 2 leading spaces etc.
The actual drop down list seems to trim off the spaces for display purposes. So, its not great to need to use this work-a-round, but at least there is a way.
I will submit a ticket to support see if this is on a big fix list.
I created a text field to mirror the numeric field, but I put leading spaces in front the the smaller numbers using a formula. That way my $5,000 really was (space)$5,000 and hence sorted before $10,000.
So the other method is to have a sort field to display and contrive leading spaces to control the sort - say the top of the list gets 3 leading spaces, and then next gets 2 leading spaces etc.
The actual drop down list seems to trim off the spaces for display purposes. So, its not great to need to use this work-a-round, but at least there is a way.
I will submit a ticket to support see if this is on a big fix list.