Related Items

rss

Posted by gaj - Feb 24 ’17 at 04:00

Hi,

We have a simple Master-Detail situation. On the detail-edit-from I want to display fields from related Item (Master in this case 1:1) which are filtered via calc. Lookupcolumn. I do not want to show the related item grid on the form. How to do this?

thx for helping me.

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 5 years 8 months 29 days
    #1 by Dmitry Kozlov Feb 27 ’17 at 04:45

    Hi,

    A lookup column allows you to add additional fields from a parent record to a child one: list settings -> columns -> lookup column. Then just put them onto a child form with Forms Designer.

  • gaj
    Member
    Member for: 2 years 4 months 19 days
    #2 by gaj Feb 27 ’17 at 04:53

    [#1]: Sorry that is not possible. All extra columns for display who are activated for the lookupcolumn are not shown in formsdesigner!!! The lookupcolumn is a "Plumsail Lookup"

     

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 5 years 8 months 29 days
    #3 by Dmitry Kozlov Feb 27 ’17 at 04:56

    [#2]: Go to the list settings -> content types,  pick a content type you're desiging a form for, and add the extra columns to it.

  • gaj
    Member
    Member for: 2 years 4 months 19 days
    #4 by gaj Feb 27 ’17 at 05:18

    [#3]: You meen I have to add all parent-columns, i want to display on the childfrom,incl. the lookup-column to the master-contenttype?

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

    [#4]: Yes, you should include all additional field to the content type for which you design a form. Then the columns will appear in Forms Designer.

  • gaj
    Member
    Member for: 2 years 4 months 19 days
    #6 by gaj Feb 27 ’17 at 05:40

    [#5]: But then I have redundant information in the contenttype! Why it´s not possible to reference these Fileds via "Related Items" ?

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 5 years 8 months 29 days
    #7 by Dmitry Kozlov Feb 27 ’17 at 05:59

    [#6]: Not sure that I got your point. You want to display additional columns from the parent record in a child form, correct? If not, please, provide the detailed description with screenshots.

  • gaj
    Member
    Member for: 2 years 4 months 19 days
    #8 by gaj Feb 27 ’17 at 07:13

    [#7]: I have defined eg. 2 site content types(SCT): A and B with the following site colums:
    SCT-A:
    - A_Number
    - A_Name

    SCT-B:
    - B_Number
    - B_Name

    then I create 2 custom lists with the 2 SCT´s associated.

    now I want to define 1:n Rel. (one SCT-A can have more SCT-B and one SCT-B only can have one SCT-A)
    so i create a plumsail-lookup-column in SCT-B (B_A_Name) -> this is not part of the SCT-B! I also can´t set the required property to true!!

    Now I create eg. an Edit-View for SCT-B with forms designer.

    On this form Í will provide:

    - B_Number
    - B_Name
    - B_A_Name for choosing SCT-A

    and I want to show also A_Name on the form.-->this is my problem how to do.

    - I can´t add B_A_Name (lookup-col) to SCT-B because for that I need a concret List baseed on STC-B

    - I don´t want to add eg. a col.: B_A_Number, B_A_.... to STC-B tahts redundant!!!

    I hope now you understand what i want to do.
    thx again for helping me.

     

     

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 5 years 8 months 29 days
    #9 by Dmitry Kozlov Feb 28 ’17 at 02:15

    [#8]: Hi,

    I see here two options: you either add the columns from the parent list (SCT-A) as additional columns of the lookup column (B_A_Name) and add them to the child content type (SCT-B) to display in a form or retrieve the fields with JavaScript when a user picks a value in the B_A_Name. We can assist you with the script, it will take 200 support minutes.

Displaying 1 to 9 of 9 messages