SharePoint Integration

Re: Dropdown list with more than one displayvalue

xaszy — Tue, 28 Aug 2012 07:14:22 GMT

I now fixed it with a workflow, which "calculated" the value in a new column. This column i use for the Dropdown.

Re: Dropdown list with more than one displayvalue

xaszy — Fri, 24 Aug 2012 11:50:19 GMT

In the Meantime that way my idea , too.

But i can't do a calculated colums based on a reference field:

I created a new colum in the Product table as calculated:

But i could just do this: =ID+NAME

But not = NAME+REFERENCEtoProducerID

Is this normal ?

Re: Dropdown list with more than one displayvalue

ErnestoM — Fri, 24 Aug 2012 11:28:56 GMT

Hi-

Modify the SharePoint list to add a calculated column that concatenates the two values, then use that column in your dropdown, as the displayName.

Basically, you have to handle for this in SharePoint, and not in InfoPath. InfoPath can't concatenate the values itself. InfoPath needs to receive the data already concatenated.

Good luck!

Dropdown list with more than one displayvalue

xaszy — Fri, 24 Aug 2012 09:06:42 GMT

Hi,

i have a problem and absolutly no solution.

The scenario:

Table 1: Producer(ID,Name)

Table 2 Product: (ID,Name,REFERENCEtoProducerID)

Now i have a Infopath 2010 Sharepoint Form and wanted to create a Dropdown where the displayvalues are all names of product but with the producername.

e.g.:

#Dropdown#

Producer1 Product 1
Producer1 Product 2
Producer1 Product 3
Producer2 Product 1
Producer3 Product 1
Producer3 Producet2
etc...

The Problem when i open the settings of the Infopath 2010 Dropdownlist, then there is a Textfield Value and Displayname. and i can't type in ther a formular like "concat(d:Producer,d:Prodct)".
Is there any solution to this ?

Thank you guys =D