Related Items dose not work with Plumsail Lookup-Column as DatasourceLookup

rss

Posted by gaj - Feb 1 ’17 at 06:56

If I try to insert a "Related Items" Object with Data Source - Filtered by form field and a Lookup-Filed as "Form field" I get the following Filter!! -->

<a onclick="OpenPoppPage('https://..........

and no data is shown !!

 

I also tryed it with a standard Sharepoint Lookup-Column with the same bad result.

Somebody can help me?

I´m using the latest version of Designer and lookup with O365-SPO

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 8 years 2 months 20 days
    #1 by Dmitry Kozlov Feb 2 ’17 at 04:58

    Hi,

    There're additional actions required if you want to filter the realted items by a lookup field of the parent item. Please, read the threads:

    http://forum.spform.com/forms-designer-for-sharepoint-20/related-item-lookup-field-36765/

    http://forum.spform.com/forms-designer/related-items-fliter-by-lookup-32351/

  • gaj
    Member
    Member for: 4 years 10 months 6 days
    #2 by gaj Feb 2 ’17 at 09:10

    [#1]: thx this solution is working, but I´m wondering why this standard functionality dosen´t work without coding.
    This was actually my reason to buy your tool for not coding SPO.

    - I just use your Lookup to display more then one column for selection! Why it´s not possible to set "required" as you can do it with standard Lookup-Column in SP?

    - If I have a "Related Item"-List on a Form with a "Edit"-Column the "Edit-Form" is opening as a Dialog!! How to open this Detail-Form not in Dialog-Mode?

     

    thx. for helping

     

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 8 years 2 months 20 days
    #3 by Dmitry Kozlov Feb 3 ’17 at 10:32

    [#2]: Hi,

    It's not a common case to filter the related items by a lookup field of the parent list. More often, users filter the related items by a lookup field pointing to a general field of the parent item. That's why particular this case requires a bit of coding.

    Answering your other questions:

    1. You can make a lookup column mandatory: just go to the list settings, pick the column in under list of columns and turn on 'Require that this column contains information'. Then re-add the field onto your form in Forms Designer (remove and add it again).

    2. Here, you can use JavaScript to remove 'onclick' attribute of the link. Our support team can assist you with the script. Drop a screenshot of your form to [email protected] and we will estimate the task.

  • gaj
    Member
    Member for: 4 years 10 months 6 days
    #4 by gaj Feb 27 ’17 at 05:06

    [#3]: Sory it´s not possible to set the "required" field to true with an "Plumsail"-Lookup!

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 8 years 2 months 20 days
    #5 by Dmitry Kozlov Feb 27 ’17 at 05:14

    [#4]: Hi,

    Go to the List Settings -> Columns -> pick the lookup column and make it required as any other column of the list. Then re-add it to the form in Forms Designer.

Displaying 1 to 5 of 5 messages