Hi all, realy hoping you can help me with this one :)
I have a Form with a field from where you can choose different regions. The field is a "Multiple Selection list box" and is based on data from a SharePoint list. The list has several columns: TitleA, TitleB, ID. In the field I have set Display name to "TitleA" and value to ID. This is because I need the ID as a parameter to be sent to a PerformancePoint web part in SharePoint.
The issue for me is that I want some sort of calculated field that tell the user, what fields they have chosen. Since the ID's won't make much sense I need to query the "TitleB" and show the users. So my setup is as follows:
FORM FIELDS:
Choose Region:
Multiple Selection list box -> Display "TITLEA". Actual value "ID"
Hidden field to be sent to PerformancePoint
Text Box -> Displays chosen values from Region as comma separated string: "ID_1, ID_2, ID_3"
based on formula: substring(eval(eval(Region[. != ""]; 'concat(", ", .)'); ".."); 2)
You have chosen
Needs to display the same as the hidden field, only it should contain titleB as in "TitleB_1, TitleB_2, TitleB_3"
Is this possible, with or without coding? No matter what I try I either end up with the ID's or only the first value when converting to TitleB
This is for a browser enabled form in 2010, so performance is important.
/Hanne