Configuring Linked Items

<< Click to Display Table of Contents >>

Navigation:  Linked Items >

Configuring Linked Items

Configuring Linked Items

 Creating and Defining Linked Item Column

You can create Linked Items column only when you have a field from parent list as a lookup field in child list

Click on ‘New Column’ button to configure new Linked Item Column

clip0372

 

Configure New Linked Items Column Page

clip0005

clip0965

clip0966

 

General Settings

List:  Select a List to create Linked Item Column

clip0006

 

Name of new Linked Items Column:  Provide a name to Linked Item Column or select an existing column

clip0007

 

Linked List Information

Site: which Site the linked list is in. This can be a site in the current Site Collection or a site from a different Site Collection:

clip1257

List:  Select List that is related to Parent Site selected above

clip0008

There are three options for referring to the linked list: A lookup column on the linked list pointing to the parent list (selected above), Text for matching the value in a column on the parent list to a value in a column on the linked list, and Query Builder for building a query to fetch items from the linked list.

oLookup Column:  This dropdown will show those lookup fields in Linked List where Lookup List is same as Parent List selected above

clip0009

oText: Allows you to compare a column in the parent (Main) list to a column in the linked (Associated) list. If the value in both columns is the same, you'll see items from the linked list on the form of the parent list.

clip0968

oQuery Builder: Allows you to build a query to fetch items from the linked list to show in the main list. Optionally, you can connect it to a lookup column, similar to the lookup column option above. The query gives you a way to filter the view further. E.g. if you want to only see items with a status of "Open" on the parent list.

clip0969

View:  Select a view from child list so that data from selected view will get displayed in Parent List Item’s forms and views. Provides a way for filtering which items are shown on the parent list. Filtering can be done by using the view or the Query Builder option above.

clip0010

 

Advanced Settings

Auto load linked items in list forms:  This option is to load items from child list into parent list forms automatically when list item gets opened

clip0011

Form UI when Option Unchecked        

clip0012

Form UI when Option Checked

        clip0013

 

Allow New Entry:  This option is to allow you to Add new items into Child List directly from Parent List forms and link it automatically to parent list

 

                            clip0014

             New Entry in UI of List Forms (Custom Lists)

1.Click ‘New Item’ link in List form

clip0015

2.In New Item Configuration List Item ‘Title’ will gets populated automatically

clip0016

3.After Saving Configurations newly created item will get linked to parent item’s form

clip0017

 

New entry in UI of List forms (Document Library and Picture Library)

1.Upload new item into Document Library list

clip0018

2.Provide List Item Title so that newly created item will get linked to parent list’s form

clip0019

Aggregate Settings

Count, Sum, Average, or Max/Min can be shown for Date/Time, Number, Currency, and Calculated columns can be shown below the linked items grid.

clip0374

 

 List View Settings

       These settings are for when showing the Linked Items column in a NITRO List View.

 clip0971

Display settings: determines how the linked items are shown in the NITRO List View

       Inline Items:

                 clip0972

Pop-up dialog:

       clip0973

         clip0975

 

       Link Text changes what is show in the view. "Click here to see details" is the default.  

oShow aggregate value with link to see items:

       clip0976

oShow count of linked items with link to see items:

               clip0977

oShow link to see items. This option allows you to input custom text such as "Click this link to access these items". When left blank, the default text "Click here to see details" is shown:clip0978

 

Updating Existing Columns

Edit existing Linked Item Columns as shown below

clip0375

 

Delete existing Linked Item Columns as shown below

clip0376

 

In Edit Mode you can change configurations of  ‘View’ and ‘Advanced Settings’

clip0373

 

Note: If you want to modify ‘Parent List Information’ and ‘Linked List Information’ configurations, delete existing Linked Item column and recreate a new Linked Items column