Cascaded Lookup Feature List
Product Features |
Create parent-child, cascading relationships between columns so data entered in one field filters the options present in another |
Unlimited number of cascading levels |
Filter and sort retrieved data by selected view |
Filter retrieved data by one or multiple columns from the target list |
Support filtering by multiple values in cascading function |
Supports cross-site lookup to reference list from any site within a site collection |
Supports autocomplete, find-as-you-type functionality to easily search retrieved data |
Automatically create a reverse lookup field in the target list |
Allows users to create a reverse lookup field using an existing Cascaded Lookup column in the target list |
Supports four display styles: dropdown list, left <-> right box, table (grid) view and item picker |
Display relevant columns from the target list alongside lookup values in table view on Item View/Edit form; allows paging, filtering, sorting (for multiple values) |
Display relevant columns from the target list alongside lookup values delimited by semicolons in ”left <-> right box” on Item View/Edit form; tooltips supported (for multiple values) |
Display relevant columns from the target list alongside lookup values delimited by semicolons in dropdown list on Item View/Edit form; tooltips supported (for single value) |
Cascaded Lookup column is usable for calculation when creating a Calculated column |
Add new items to the target list via “Create new item…” link; supports access control over this link |
Supported column types: Single line of text, Number, Date and Time, Calculated (output is single line of text), system reserved fields ( such as ID, Created, Modified and Version) |
Supports referencing values from document “Name” column; ability to download a copy directly by clicking the file name on Item View form |
Display Cascaded Lookup columns with icons |
Add additional or secondary fields from the target list to display in the view of the source list |
Allows users to change the order of the additional fields on the Change Column Ordering page |
Set a default value for lookup column; supports custom value as default value |
Option to display empty field when no items match the filter criteria |
Automatic duplicate removal (display only one instance when duplicate items exist) |
Option to remove the link of Cascaded Lookup columns in list view and View item form |
Auto adjust the width of the Cascaded Lookup control according to value length |
Supports Cascaded Lookup column as a site column |
Convert an existing SharePoint lookup column to Cascaded Lookup column |
Convert Cascaded Lookup column to SharePoint lookup column |
Export Cascaded Lookup column data to Microsoft Excel |
Export Cascaded Lookup column data to Microsoft Access database |
Manage Cascaded Lookup column data in Microsoft Word |
Sync Cascaded Lookup column data to SharePoint Workspace |
Supported Environments |
Microsoft SharePoint Server Subscription Edition |
Microsoft SharePoint Server 2019 |
Microsoft SharePoint Server 2016 |
Microsoft SharePoint Foundation 2013 |
Microsoft SharePoint Server 2013 |
Supported Browsers |
Microsoft Internet Explorer 8/9/10/11 |
Microsoft Edge |
Mozilla Firefox |
Google Chrome |
Supported Languages |
English |
Japanese |
German |
French |
Simplified Chinese |