topic Re: order of the labels in App Development

order of the labels

Aubry — Wed, 15 Dec 2021 12:44:52 GMT

HI everyone,

I hope you are doing well

can you tell me how i can change the display order of the labels please ?

thank you for your help
have a good day
Aubry M

Re: order of the labels

Or — Wed, 15 Dec 2021 13:02:18 GMT

You can change the sort order using the "Sort" tab and Sort by Expression, e.g.

Pick(Match(Field,'A','B','C','D','E'),2,4,1,5,3) - this will sort the values in Field in the order C, A, E, B, D

You could also load the values in the order you want them displayed (using ORDER BY or other methods) and then uncheck all the boxes which will sort by the original load order, or you could assign a second field to each text field that will determine the sort order and use that in a dual() statement such as Dual(DisplayField,SortOrderField) as Field, in which case you can sort it numerically.

Re: order of the labels

MarcoWedel — Thu, 16 Dec 2021 17:45:41 GMT

or maybe with the order directly defined in the Match() function:

Match(Field,'C','A','E','B','D')

Re: order of the labels

Or — Thu, 16 Dec 2021 18:46:40 GMT

Oops. We can do that, right!

Re: order of the labels

Aubry — Fri, 17 Dec 2021 07:30:29 GMT

Hi Marco
I will try that,
thx for the good idee

have a good day
Aubry M