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
Configure New Linked Items Column Page
•List: Select a List to create Linked Item Column
•Name of new Linked Items Column: Provide a name to Linked Item Column or select an existing column
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:
•List: Select List that is related to Parent Site selected above
•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
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.
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.
•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.
•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
Form UI when Option Unchecked
Form UI when Option Checked
•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
New Entry in UI of List Forms (Custom Lists)
1.Click ‘New Item’ link in List form
2.In New Item Configuration List Item ‘Title’ will gets populated automatically
3.After Saving Configurations newly created item will get linked to parent item’s form
New entry in UI of List forms (Document Library and Picture Library)
1.Upload new item into Document Library list
2.Provide List Item Title so that newly created item will get linked to parent list’s form
•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.
List View Settings
• These settings are for when showing the Linked Items column in a NITRO List View.
•Display settings: determines how the linked items are shown in the NITRO List View
▪ Inline Items:
• 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:
oShow count of linked items with link to see items:
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:
Updating Existing Columns
Edit existing Linked Item Columns as shown below
Delete existing Linked Item Columns as shown below
In Edit Mode you can change configurations of ‘View’ and ‘Advanced Settings’
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