Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any way to list values from a field - line by line in a Current Selections box instead of values appearing as one continuous string separated by commas?
Nope, not really.
If it's something that you'd like to invest a bit of time in you could create this using a Text Object and GetFieldSelections() and concat() the selections with a carriage return chr() as the separator.. but it sounds like overkill.
Hi dalejames,
You can use the below function in the text object.
=GetCurrentSelections()
Regards,
Nilesh Gangude
Hi,
This option is not available for Current selection box, but you can do this by using GetFieldSelections() and formatting the result as required, using a Text object you can display the selections.
Hope this helps you.
Regards,
Jagan.
Many thanks each of you for your quick responses. I’m trying to show the values that I have de-selected from a List Box containing [Diagnosis 1]. I’ve created a Text Object and tried concatenating with:
=concat(GetFieldSelections([Diagnosis 1])&chr(13))
I’d like to see:
NOT
T39.1 Poisoning by 4-Aminophenol derivatives
N39.0 Urinary tract infection, site not specified
F20.0 Paranoid schizophrenia
But I get the following result:
NOT T39.1 Poisoning by 4-Aminophenol derivatives, N39.0 Urinary tract infection, site not specified, F20.0 Paranoid schizophrenia
Which still appears as one string. As this may contain several values, I need to break up the values to make them more readable, one diagnosis per line. Have I got the syntax correct in my concat?Any further ideas?
Thanks again
Hi
Try like this
=GetFieldSelections([Diagnosis 1],chr(13))
And you can minimize the text object. As per value..