Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am not getting how to display selected two countries in same Listbox as concatenated string.
i.e. for example..
Country listbox consisting following contry names..
India
UnitedStates
United Kingdome
Canada
France
I have been selected two countries (e.g : India , UnitedStates) in above Listbox then It will display like "IndiaUnitedStaes".
how can I get that result.
Please help me .
Thanks & regards :
seshukumar bandaru.
this is not ideal but it works
=REPLACE(REPLACE(REPLACE(GetCurrentSelections(Country),',',''),' ',''),'Country:','')
this is not ideal but it works
=REPLACE(REPLACE(REPLACE(GetCurrentSelections(Country),',',''),' ',''),'Country:','')
Thank you Alan Farrell I have solved my issue..
Great, but you should use Gysbert's solution
It's a much better solution
I am still learning, so I may do things the hard way, but as long as the result is correct
This seems to work somewhat and isn't bothered by selections in other fields:
1. Create a variable vC as =concat(DISTINCT Country).
2. Use as expression for the listbox =if(GetSelectedCount(Country),vC,Country).
Unselecting isn't very nice though, requiring two clicks.
great Gysbert Wassenaar & thanQ.. its working ..