Sorting Listbox

[sibin_jacob]

Hai,

I want to sort  listbox in a specified order. Filed name for the list box is 'Decile_Type' and the values are High, Medium , Low.

I can' change the order in backend. I want it in the same order (High, Medium, Low).  I Can't Use load order.

Is it possible to sort the listbox in specified order ?

Is it possible to achieve this sort order using 'sort by expression' option?

Thanks,

Sibin Jacob.C

[swuehl · Accepted solution]

Try a sort by expression like

=match(Decile_Type,'High','Medium','Low')

If you say you can't change order in the backend, that means you don't have access to the script / you can't change the script?

If you do have access to the script, there are several methods to prepare your field sorting in the script, so you don't need a sort by expression in the UI, at different places.

[sibin_jacob]

Thank you Swuehl. It is working Fine.

Regards,

Sibin Jacob.C