Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You are right , you must use a parameter for the function, here it is:
getfieldselections (FieldName [, ValueSep [, MaxValues]])
so in MaxValues set 50 and it will work ...
Hi Rajat,
Unable to view the image. can you explain the Scenario in detail.
Regards,
Krishnapriya.
try this:
=SubField(Concat(Country_Name,';'),';',1),
=SubField(Concat(Country_Name,';'),';',2), ....
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
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"
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
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' "
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
It is strange because the bahaviour you are describing is related to what I asked to set in the box
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.