How to get each selection in different text objects

[rajat2392]

Hi

I am having a problem with this scenario. I want to show the 4 selected values separately in different text objects as in the image below. Please help how to do that. Tried too many functions but didn't get. Please help.

Regards

Rajat

[krishnacbe]

Hi Rajat,

Unable to view the image. can you explain the Scenario in detail.

Regards,

Krishnapriya.

[#3]

try this:

=SubField(Concat(Country_Name,';'),';',1),

=SubField(Concat(Country_Name,';'),';',2), ....

[alexandros17]

When you select more than one value you have a string , check it in the text box writeing the function =GetFieldSelections(MyField)

Now, use the function

subfield(GetFieldSelections(MyField), ';' ,1) in the first textbox,

subfield(GetFieldSelections(MyField), ';' ,2) in the second and so on ... only pay attention to ;, if your full string has ; as separator than use it otherway use the that separator

[rajat2392]

Hi Dariusz,

This I have tired, but problem arises when I have more values in Country and more the selections.

Suppose I have around 60 values in Country, and I select 40 out of them..then it is showing "Out of Object memory"

[alexandros17]

Go in Settings -> User Preferences -> General and insert a value in the "Max values in current selection" box.

you will be able to see up to "That number" distinct values

[rajat2392]

Hi Alessandro,

Tried this already, problem comes when I have more values in Country. Suppose I have 15, and if I select 11 out of them, then it results like "NOT 'list of excluded values' "

[#8]

Rajat,

You told, that you have 4

i think, you may have some country_id field.

Then you may try:

FirstSortedValue(Country,country_id,text_object_nbr)

regards

Darek

[alexandros17]

It is strange because the bahaviour you are describing is related to what I asked to set in the box

[rajat2392]

Yaeh strange, but coming like this only. I have kept that limit to 50, and selecting 11, still the results are coming like this only.