Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a List box with the 9 values. Is there a way to Custom Sort them? So the I can get the list to display specific values before the others??
You can use something like the following in sort by expression:
match(YourListBoxField, 'ValueYouWantSortedFirst', 'ValueYouWantSortedSecond')
and just adapt that to your data (just add more values to the list until you get 9).
PFA
You can Load inline your values in a specific order and then sort by load order.
Regards,
Ivan
another one
9 8 7
then the others (1 2 3 4 5 6) in numeric sort order
Why is it when I have a value selected, the custom sort order is no longer applied?
So based on your example above, if I have '8' selected, I want the numbers to then be ordered '9 7 1 2 3 4 5 6'
You have to wrap a bit of Set Analysis around it to ignore the selections.
=only({1}WildMatch(Num,'9','8','7','*'))
-Rob
Similar problem, but solved using match() function. Check the blog link