SharePoint Cascaded Lookup - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

SharePoint Cascaded Lookup by SharePointBoost

URLs: sharepoint-cascaded-lookup, sharepoint cascaded lookup, sharepointcascadedlookup, sharepointboost

Improvements to SharePoint's standard reference functions. SharePoint Cascaded Lookup is a powerful look-up tool that greatly enhances the lookup functionality already native to SharePoint. It quickly cross-references existing data from a list or site within the same site collection and then applies a combination of filters to reduce the number of options presented in the dropdown menu of your lookup field. To use it, you set a combination of filters available in both the source list (the list you are looking up from) and the target list (the list where you want to add looked-up information) to ensure that only applicable values are displayed as choices in the dropdown list.

SharePoint Cascaded Lookup

Look up and cross-reference information from any SharePoint site in a site collection;

Build parent-child relationships between columns in the same list so that data entered in one field filters the options presented in another;

Use a combination of filter parameters from the source list and the target list to filter the items presented in a lookup field ;

Automatically synchronize data and update items in the target list when changes are made in the source list;

Add multiple selections from the source list to list items in the target list;

Convert between the default SharePoint Lookup column, Cross-Site Lookup column, and Cascaded Lookup column;

Integrated memory function saves Cascaded Lookup settings when converting between different Lookup column types;

SharePoint Cascaded Lookup is a powerful look-up tool that greatly enhances the lookup functionality already native to SharePoint. It quickly cross-references existing data from a list or site within the same site collection and then applies a combination of filters to reduce the number of options presented in the dropdown menu of your lookup field. To use it, you set a combination of filters available in both the source list (the list you are looking up from) and the target list (the list where you want to add looked-up information) to ensure that only applicable values are displayed as choices in the dropdown list.

SharePoint Cascaded Lookup creates relationships between columns in the same list: you build a parent-child relationship between a set of columns so that the value you choose in the parent column determines the options presented in the child column. Above, a cascading series of parent-child columns filter the options presented in the drop-down menu. Here, the Continent column is a parent to the Country column, so choosing North America filters the options presented in the Country column so that only countries in North America are presented as options. The Country column is a parent to the State column, so the value chosen in the Country column filters the State column, which in turn filters the options available in the City column.

How Does It Work?

In order to take full advantage of the functionality of Cascaded Lookup, you need to establish several things:

The Source List, which is the list from which Cascaded Lookup will look up information. The Source list can be in any site.

The Source Column, located in the Source List, that contains all of the possible values for your drop-down menu.

The Filter Column, also located in the Source List, which is used to filter out irrelevant data from the Source Column so that only values that fit your filter criteria will be possible as choices.

The Parent Column, located in the target list (the list where you want to add looked up information).

Once you have set up your filter columns, Cascaded Lookup will automatically filter according to your parameters:

You select a value from the Parent column.

SharePoint takes this value and compares it to the values located in the Filter Column (in the Source List).

SharePoint instantly builds a list of possible choices by listing the Source Column values for rows with Filter Columns that match the value of the Parent Column. These results are then listed in the drop-down menu - all non-matching values have been filtered out, so they do not appear as possible choices.

SharePoint Cascaded Lookup is an invaluable lookup tool, saving you time by reducing the options presented in the drop-down list, and eliminating the possibility for error as a result of incompatible values.

What's new in v3

Build multiple parent-child relationship, No limitation on number of cascading levels

Support multiple filters

Support look up information from "Date and Time" and "Number" columns

Support Multiple Choice, Multiple SharePoint Lookup, Multiple Cross-Site Lookup, Multiple Cascaded Lookup columns as parent column

Support displaying additional columns from lookup list

Support adding new items in the source lookup list by the "Create new item..." link

Support Cascaded lookup as site column

Improved lookup performance

Support Japanese, German and Chinese

Improvements to SharePoint's standard reference functions.

Pricing: SharePoint Cascaded Lookup V3.1.210 Server License 1 Server License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 50 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 100 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 200 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 300 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 400 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 500 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 600 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 700 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 800 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 900 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 1000 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 1250 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 1500 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 1750 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 2000 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 3000 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 4000 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 5000 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 8000 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 10000 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Site Collection License 20000 End Users Site Collection License, SharePoint Cascaded Lookup V3.1.210 Farm License 50 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 100 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 200 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 300 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 400 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 500 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 600 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 700 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 800 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 900 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 1000 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 1250 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 1500 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 1750 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 2000 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 3000 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 4000 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 5000 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 8000 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 10000 End Users Farm License, SharePoint Cascaded Lookup V3.1.210 Farm License 20000 End Users Farm License

Evals & Downloads: Read the SharePointBoos Software End User License Agreement, Download the SharePointBoost End User Viewer Tool - Free version, SharePointBoost License Management Center - Free version, Download the SharePoint Cascaded Lookup V3.1.210 evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows 7, Windows Server 2008, Windows Vista, Windows XP, Windows Server 2003

Architecture of Product: 32Bit, 64Bit

Product Type: Component, Application

Component Type: ASP.NET WebForms, ASP.NET AJAX (ATLAS), Web Part

Application Type: Server Application

Compatible Containers: Microsoft Visual Studio 2010, Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual C# 2010, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft SQL Server 2010, Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SharePoint 2010, Microsoft SharePoint 2007, Microsoft Office SharePoint Server (MOSS), Microsoft Windows SharePoint Services, Microsoft Internet Explorer 8.0, Microsoft Internet Explorer 7.0, Microsoft Internet Explorer 6.0, Mozilla Firefox 3.6, Mozilla Firefox 3.5, .NET Framework 4.0, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0

Keywords: SharePoint permission, SharePoint view permission, SharePoint column permission, SharePoint permission web part, SharePoint field level permission.

SharePointBoost SharePoint Boost Share Point Boost

System Administration Systemadmin admin administrate sysadmin sys

Part numbers: PC-540738-443075 540738-443075 PC-540738-443076 540738-443076 PC-540738-443077 540738-443077 PC-540738-443078 540738-443078 PC-540738-443079 540738-443079 PC-540738-443080 540738-443080 PC-540738-443081 540738-443081 PC-540738-443082 540738-443082 PC-540738-443083 540738-443083 PC-540738-443084 540738-443084 PC-540738-443085 540738-443085 PC-540738-443086 540738-443086 PC-540738-443087 540738-443087 PC-540738-443088 540738-443088 PC-540738-443089 540738-443089 PC-540738-443090 540738-443090 PC-540738-443091 540738-443091 PC-540738-443092 540738-443092 PC-540738-443093 540738-443093 PC-540738-443094 540738-443094 PC-540738-443095 540738-443095 PC-540738-443096 540738-443096 PC-540738-443097 540738-443097 PC-540738-443098 540738-443098 PC-540738-443099 540738-443099 PC-540738-443100 540738-443100 PC-540738-443101 540738-443101 PC-540738-443102 540738-443102 PC-540738-443103 540738-443103 PC-540738-443104 540738-443104 PC-540738-443105 540738-443105 PC-540738-443106 540738-443106 PC-540738-443107 540738-443107 PC-540738-443108 540738-443108 PC-540738-443109 540738-443109 PC-540738-443110 540738-443110 PC-540738-443111 540738-443111 PC-540738-443112 540738-443112 PC-540738-443113 540738-443113 PC-540738-443114 540738-443114 PC-540738-443115 540738-443115 PC-540738-443116 540738-443116 PC-540738-443117 540738-443117