Fix the order in a list box

[danialier]

Hello,

Two questions:

1) I have a list box with products A, B, C as follows:

A

B

C

If I select B then it turns to:

B (highlighted in green)

A

C

However what I want is to have:

A

B (highlighted in green)

C

How I can do that ?

2) The original sort of the list box by default is:

A

B

C

However, I want the list box (before doing any selection) to be ordered as:

C

A

B

How I can do that ?

thanks, dani

[#2]

Dani,

First LOAD your field as you wish, with the desired order.

LOAD all your data later

In the sort tab, choose Load Order (this one is the order of the FIRST load)

Fabrice

[#3 · Accepted solution]

Hey Dani,

Check out the attached file. Go to sort uncheck 'Sort by state' and check Load order as Original. Also check the inline table in script.

Thanks

AJ

[Christian_Lauritzen]

On the sort tab, replace sort on State with sort on expression =index(ALL 'CAB',Fieldname).

[aveeeeeee7en]

Hi Dani

Use this in your Sort Expression:

dual(FieldName,Match(FieldName,'C','A','B'))

See the Attached.

[aveeeeeee7en]

Hi Dani

See the Attached.

Regards

Aviral Nag