Related Items Lookup on field with multiple items

rss

Posted by mac_xpert - Sep 29 ’14 at 09:23

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
    Dmitry Kozlov
    Admin
    Member for: 6 years 23 days
    #1 by Dmitry Kozlov Sep 30 ’14 at 03:07

    Hi,

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

  • AgneseB
    Member
    Member for: 4 years 10 months 16 days
    #2 by AgneseB Dec 18 ’14 at 06:44

    [#1]: Is it possible to apply some custom filter to Related Items?

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 6 years 23 days
    #3 by Dmitry Kozlov Dec 19 ’14 at 11:13

    [#2]: 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
    Member
    Member for: 4 years 10 months 16 days
    #4 by AgneseB Dec 22 ’14 at 05:21

    [#3]: 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
    Dmitry Kozlov
    Admin
    Member for: 6 years 23 days
    #5 by Dmitry Kozlov Dec 22 ’14 at 09:06

    [#4]: 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
    Member
    Member for: 4 years 10 months 16 days
    #6 by AgneseB Dec 23 ’14 at 07:15

    [#5]: 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
    Dmitry Kozlov
    Admin
    Member for: 6 years 23 days
    #7 by Dmitry Kozlov Dec 24 ’14 at 03:47

    [#6]: 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
    Member
    Member for: 5 years 25 days
    #8 by mac_xpert Jan 15 ’15 at 11:00

    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
    Member
    Member for: 5 years 25 days
    #9 by mac_xpert Jan 15 ’15 at 11:27

    [#8]: Never mind i have answered my own question and have got it working. Excellent development. Thankyou.

  • Sebastian Haugland
    Sebastian Haugland
    Member
    Member for: 4 years 6 months 21 days
    #10 by Sebastian Haugland Nov 26 ’15 at 01:49

    Hi

    (ref question above)

    I can filter related items by using the form title and a multiple lookupfield (containing titles) in the relateditems view, but not the other way around?

Displaying 1 to 10 of 11 messages
Previous12