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: 8 years 1 month 6 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: 4 years 8 months 25 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: 8 years 1 month 6 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: 4 years 8 months 25 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: 8 years 1 month 6 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: 4 years 8 months 25 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: 8 years 1 month 6 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: 4 years 8 months 25 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: 8 years 1 month 6 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.

  • hazelmark760
    Member
    Member for: 1 year 4 months 18 days
    #10 by hazelmark760 Jun 12 ’20 at 04:18

    Your problem is sorted out? if not then I suggest you to go and check on Ritecoupons.com here you will get many suggestions then how to display products, because they display their products very beaustifully, hopefully you will get many ideas from there.

     

     

     

     

     

     

Displaying 1 to 10 of 17 messages
Previous12