Related Items Lookup on field with multiple items

[mac_xpert]

Hi

I'm trying to create a 'related items' section in a form, based on a lookup field that allows multiple items. How do i do this?

It works fine if the lookup field does not allow multiple items, but if it does i'm unable to select it under 'filter by lookup field' in forms designer.


Thanks,


Matt

[Dmitry Kozlov]

Hi,

Unfortunately, the related items control doesn't support filtering by multi-lookup columns.

[AgneseB]

Is it possible to apply some custom filter to Related Items?

[Dmitry Kozlov]

Yes, if the list is rendered in the Client mode, you can pass filter values in the hash part of the URL as I did in our charting demo:

http://www.spchart.com/demo/link-chart-to-list

Switch to the Configuration page to find the instructions and code samples. If you use the related items in the server side mode, it may take about 100 support minutes to prepare the scripts.

[AgneseB]

I have a multi lookup field "contractors" in my Agreements list. What I would need is to display contractor details (e.g. address, reg.no.) when user selects contractors (they can be several). What would be the best way to achieve that?

[Dmitry Kozlov]

You can use additional columns of the lookup field. Also you can copy extra information via a workflow or our Cross-site Lookup that allows you to retrieve additional columns from the source list when a user goes through the result set on a form.

[AgneseB]

I was able to retrieve additional colums but can't find how to display them in a table (each contractor details in a separate row, like a repeating table in InfoPath).

[Dmitry Kozlov]

Hi,

You could store the additional information as a JSON object in a separate hidden field and display it as a table in a form via JavaScript. Our support team can help you with it. It will take about 200 support minutes. If you're interested, please, drop us the detailed requirements to get more precise estimation.

[mac_xpert]

With the new release of the related items field in SharePoint Forms Designer 2.9.1 is it now possible to do a lookup on a lookup field with multiple items?

[mac_xpert]

Never mind i have answered my own question and have got it working. Excellent development. Thankyou.