Want to show filtered values in a caption...

[mikefromoke]

Hello,

i want to show the filtered values in a caption, f.e. using a textbox.

Example:

I have a field "land" with values "A,B,C,D".

In a listbox i select the value "A". When i generate a textbox with Field "land", the value "A" is shown, so every thing is OK.

but when i select the values "A,B,C" in the listbox, the textbox shows "-" instead of "A;B;C"......

How can i show the filtered values (without using the statusbox ) ?

Anyone an idea or suggestion?

thx

mike

=>

Solution is function "=GetFieldSelections()"

I found it in the Communitiy...

[#2 · Accepted solution]

Use the GetFieldselections('FieldName') in your text object expression.

[sunny_talwar]

Another one could be:

If(GetSelectedCount(Value) > 0, Concat(DISTINCT Value, ';'))

and for GetFieldSelections() you can determine what should be field seperator. and I would use a big number for third argument if you have large number of options to select from within value:

GetFieldSelections(Value, ';', 99999)

[#4]

Yes using GetFieldSelections(Land), the result should be A,B,C in textbox in case you select ABC from list box.

Do you want to display it as A;B;C instead?

[mikefromoke]

Thank you

regards

[mikefromoke]

Thank you,

regards

[mikefromoke]

thank you,

regards