Announcements
cancel
Showing results for
Did you mean:
Not applicable

## Avoid sorting of listbox after selection

Hi,

I have a list box which contains the month names. I sorted it based on Month code using Expression sort. The values come sorted the first time, but after a selection is made, the values are sorted randomly. Is there a way to avoid sorting after a selection is made? Please let me know.

1 Solution

Accepted Solutions
Specialist II

I thinkn u may be busy ,

wite the expression in sort tab and arrange it as ascending,

=only({1}if(Month='Apr',1,

if(Month='May',2,

if(Month='Jun',3,

if(Month='Jul',4,

if(Month='Aug',5,

if(Month='Sep',6,

if(Month='Oct',7,

if(Month='Nov',8,

if(Month='Dec',9,

if(Month='Jan',10,

if(Month='Feb',11,

if(Month='Mar',12)))))))))))))

Regards

Premhas

7 Replies
Specialist II

can i know expression which is used in sort tab ?

Specialist II

I thinkn u may be busy ,

wite the expression in sort tab and arrange it as ascending,

=only({1}if(Month='Apr',1,

if(Month='May',2,

if(Month='Jun',3,

if(Month='Jul',4,

if(Month='Aug',5,

if(Month='Sep',6,

if(Month='Oct',7,

if(Month='Nov',8,

if(Month='Dec',9,

if(Month='Jan',10,

if(Month='Feb',11,

if(Month='Mar',12)))))))))))))

Regards

Premhas

MVP

Go to general tab, enable 'Show as TreeView'

Or,

In the sort tab, uncheck sort by 'State' .

Not applicable
Author

Hi,

See the attachment.

Specialist II

Hi

as tresesco said,

'Show as TreeView'  sure will work, try it..

Partner - Champion

Uncheck the Sort by State option in Sort tab.

Not applicable
Author

Guys,

Extremely sorry for not replying. Was out of town. This worked perfectly just that I used only {1} MonthCode, where MonthCode is a column in my month table. Before this I tried un-checking all options (except Expression) but it didn't work. Also, Show as Tree View actually disables Sort by State and seems to be working as well. Thanks everyone who had replied to my question

Community Browser