Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to custom order for a field "Country" .
I did a mapping with the field "Country" and " Country Order" like below:
Country Country Order
USA 1
Canada 2
Brazil 3
After loading, i use sort by expression in the listbox:
But the problem is : when i select a value in the listbox, the value selected goes to the end of the list. (i had some similar problem with the value selected goes to the top of the list ), as result, impossible to sort by expression.
I unchecked the box "State", but it does not work.
Any tips for this?
Thanks in advance!
Try these settings in your Sort tab of Listbox.
Hi,
PFA
Rgds,
Tharindu
Hope you are looking for this
In sort properties of list object try
=Only({1} [Country Order])
Thanks a lot guys!
YOu did not find the answer what you looking for?
Create the country field as a dual value with the text and numeric sort order.
The list box will display the text in numeric order without the need to change the sort sequence.