make group in listbox

[arulsettu]

Hi,

     i am having country lsitbox like this

     india

     us

     uk

     aus

what i need is

     india

     us

     uk

     aus

     group

if i select grouop it should select all countries

can anyone tell me how to do it?

Thanks

[PrashantSangle]

Hi,

Create Inline table or maintain mapping in Excel sheet

Like Load * INLINE[

Country, CountryGroup

india,India

us,US

uk,UK

aus,AUS

india,Group

us,Group

uk,Group

aus,Group

];

and link Country field with your Country Field and use CountryGroup as new Listbox

or You can also go with applymap()

Regards

[arulsettu]

Max

     can you tell how to it with applymap

[PrashantSangle]

Hi,

In applymap case also you required inline table which maintain your country and mapField.

So better if you go with first suggestion.

For applymap I will get back to you with example.

Regards,

[arulsettu]

ok

[Siva_Sankar · Accepted solution]

Arul,

find the attached qv application. you need to create a trigger under document properties. Let me know if you need help in locating it.

[Siva_Sankar]

There is other way to achieve the same without trigger. find the attachment.

[#8]

Your solution works perfect fine.Thanks Siva.

[arulsettu]

i will check siva

thanks

[arulsettu]

both solutions work fine.

thanks everyone.