First value to be always default selected in List box

[chinnu123]

Hi Team,

My list box contains Name field. The first value in the list box should be default selected.

For example My list box contains Ajay,

                                                    Bharat

                                                   Chigumbura,

                                                   Dely

                                                    Feroz

                                                    Sandhya

So as per Sorting order(A->Z) Ajay to be always selected by default. But in Future if any new names are added for example Abhi is added Then Abhi need to be default selected.

                                                  Abhi

                                                   Ajay

                                                    Bharat

                                                   Chigumbura,

                                                   Dely

                                                    Feroz

                                                    Sandhya

Can any one please suggest how to achieve this scenario.

Thanks in Advance,

Thanks,

Chinnu.

[effinty2112]

Hi Chinnu,

You could create a trigger to run when the app is opened. The action would be:

Select in field : Name

Search String : =minstring({1}Name)

Good luck

Andrew

[chinnu123]

Hi Andrew,

Thanks for your quick reply,

But unfortunately it's not working!

Thanks,

Chinnu.

[effinty2112 · Accepted solution]

Hi Chinnu,

Did you do this:

Go to Document Properties.

Tab Triggers

In Document Event Triggers select OnOpen then click button Add Action(s)

In the Actions dialog click the Add button

Action Type: Selection

Action: Select in Field

Click OK

In Actions dialog

Field : Name

Search String : =minstring({1}Name) ,include the '='

Click OK

Click OK

?

Remember to include the '=' sign in the search string.

Try it out with a button first to trigger the action if you like.

Cheers

Andrew

[chinnu123]

Hi Andrew,

I followed the above steps it get selected the first value in the list box  but when I am adding any new name its not getting selected.

For example I am having name Anand  in my list box as first value so by default it would be selected

But when I am added new name Abhi in my name field so as per sorting Abhi will be the first value compare to Anand

so Abhi should be selected by default.

Hope I was clear

Thanks,

Chinnu.

[effinty2112]

Hi chinnu,

The new example you gave, Abhi, was also the first in alphabetical order and I thought that was what you wanted. Ok. You'll need to come up with a field you can use in an expression you can sort Name by. I know nothing about your data so I don't think there's anything I can suggest.

Good luck

Andrew

[chinnu123]

Hi Andrew,

Its working fine now

[Anonymous]

Hi Andrew,

How can we do this in Cloud?

Can you please help me by sharing a qvf file?