Related Items Lookup on field with multiple items
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
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
- Site Admin
- Posts: 1524
- Joined: Thu Jun 07, 2012
Hi,
Unfortunately, the related items control doesn't support filtering by multi-lookup columns.
Unfortunately, the related items control doesn't support filtering by multi-lookup columns.
- Dmitry Kozlov
- Site Admin
- Posts: 1524
- Joined: Thu Jun 07, 2012
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.
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.
- Dmitry Kozlov
- Site Admin
- Posts: 1524
- Joined: Thu Jun 07, 2012
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.
- Dmitry Kozlov
- Site Admin
- Posts: 1524
- Joined: Thu Jun 07, 2012
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.
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.
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?
-
- Information
-
Who is online
Users browsing this forum: No registered users and 17 guests