Cascaded Lookup Column
Type: On-Premises
Edition:
Standard
Cascaded Lookup Column is intended to enhance standard SharePoint lookup functionality. Component allows building parent-child relationship between columns.
Want to get a 5% discount on your next purchase? Write us the history of using the purchased item.
Cascaded Lookup Column Online Version
Have questions? Write us
$300.00
Description
Parent and child relationships with unlimited number of cascading levels
Cascaded Lookup Column enhances standard SharePoint lookup functionality. Component allows building relationship between parent and child columns, the data selected in one field will determine the options presented in another.
You can build as many cascading levels as you need by looking up for data from SharePoint lists in all sites within site collection
Single-single, single-multi, multi-single and multi-multi relations
If you're using a series of parent-child Cascaded Lookups, each subsequent field will immediately update as you add or remove each selection from the prior one.
For multiple data entry, just select the "Allow multiple values" option, the front-end UI will allow multiple selections to be added/removed from a list.
JSLink and REST API support
JSLink provides a possibility to quickly and easily change rendering of the list views and forms. Particularly, how the fields in the list should be displayed.
REST calls can be made for creating genuine business scenarios.
Support of Datasheet view
Custom lookup fields are not easily edited in SharePoint Datasheet mode. However, ArtfulBits Lookup fields can be edited in Datasheet mode.
| Feature |
|---|
| Build parent-child relationships |
| Ajax support enabled |
| JSLink support enabled |
| Unlimited number of cascading levels |
| Supported single-single, single-multi, multi-single and multi-multi relations |
| Supported lookup data from SharePoint lists in all sites within site collection |
| Supported lookup data from subfolders |
| Filtering retrieved data using existing list views |
| Supported default values |
| Ability to add and edit lookup items on the fly |
| Supported Datasheet view |
| Conversion among "ArtfulBits Cascaded Lookup", "ArtfulBits Cross-Site Lookup", "ArtfulBits Parent Selector" columns and standard SharePoint "Lookup" column |
| Language pack support (desired localization could be added by request) |
| SP 2019 | SP 2016 | SP 2013 | SP 2010 | SP 2007 |
|---|---|---|---|---|
Release Notes
| Version |
|---|
| v2.5 (December 10, 2018) |
| v2.45 (September 14, 2018) |
| v2.44 (June 15, 2017) |
| v2.43 (May 15, 2017) |
| v2.4 (March 28, 2016) |
| v2.3 (February 29, 2016) |
| v2.1 (December 02, 2014) |
| v2.0 (April 29, 2013) |
| v1.48 (April 27, 2012) |
| v1.47 (March 26, 2012) |
| v1.46 (February 2, 2012) |
| v1.45 (January 26, 2012) |
| v1.44 (October 14, 2011) |
| v1.43 (September 07, 2011) |
| v1.42 (August 29, 2011) |
| v1.41 (August 08, 2011) |
| v1.4 (June 03, 2011) |
| v1.37 (March 24, 2011) |
| v1.36 (March 19, 2011) |
| v1.35 (March 12, 2011) |
| v1.34 (January 05, 2011) |
| v1.33 (December 23, 2010) |
| v1.32 (December 11, 2010) |
| v1.31 (November 26, 2010) |
| v1.3 (November 16, 2010) |
| v1.2 (September 02, 2010) |
| v1.1 (August 3, 2010) |
| v1.0 (July 01, 2010) |
| Notes |
|---|
New Features:
|
Bugs Fixed:
|
Bugs Fixed:
|
New Features:
Improvements:
Bugs Fixed:
|
New Features:
|
New Features:
|
New Features:
|
New Features:
|
Improvements:
|
Improvements:
|
Bugs Fixed:
|
Improvements:
|
Bugs Fixed:
|
Improvements:
|
Bugs Fixed:
|
Bugs Fixed:
|
New Features:
Improvements:
|
Improvements:
|
Bugs Fixed:
|
Bugs Fixed:
|
Bugs Fixed:
|
Bugs Fixed:
|
Improvements:
Bugs Fixed:
|
Bugs Fixed:
|
New Features:
Bugs Fixed:
|
New Features:
Bugs Fixed:
|
New Features:
Bugs Fixed:
|
| Initial Release |
Operating Systems:
Windows Server 2016 Standard or Datacenter, 64 bit
Windows Server 2019 Standard or Datacenter, 64 bit
Server:
SharePoint Release:
- SharePoint Server 2019
- Microsoft .NET Framework 4.5+
Browser:
Microsoft Edge
Internet Explorer 11
Google Chrome (latest released version)
Mozilla Firefox (latest released version plus immediate previous version)
Apple Safari (latest released version)
Operating Systems:
Windows Server 2012 R2 Standard or Datacenter, 64 bit
Windows Server (2016)
Server:
SharePoint Release:
- SharePoint Server 2016
- Microsoft .NET Framework 4.5+
Browser:
Microsoft Edge
Internet Explorer 10+
Google Chrome (latest released version)
Mozilla Firefox (latest released version plus immediate previous version)
Apple Safari (latest released version)
Operating Systems:
Windows Server 2008 R2 SP1
Windows Server 2012
Server:
SharePoint Release:
- SharePoint Foundation 2013 or SharePoint Server 2013
- Microsoft .NET Framework 4.0
Browser:
Internet Explorer 8+
Mozilla Firefox
Apple Safari
Google Chrome
Operating Systems:
Windows Server 2008 x64 SP2
Windows Server 2008 R2
Windows 7 x64
Server:
SharePoint Release:
- SharePoint Foundation 2010 or SharePoint Server 2010
- Microsoft .NET Framework 2.5
Browser:
Internet Explorer 8+
Mozilla Firefox
Apple Safari
Google Chrome
Operating Systems:
Windows Server 2003 x86/x64
Windows Server 2008 x86/x64
Windows Small Business Server (SBS) 2003/2008
Server:
SharePoint Release:
- Windows SharePoint Services v3 or SharePoint Server 2007
- Microsoft .NET Framework 2.0 or 3.0
Browser:
Internet Explorer 7+
Mozilla Firefox
Apple Safari
Google Chrome
Before installation, please, check that your target server meets System Requirements.
IMPORTANT!!! ArtfulBits License Manager must be installed before you install the component. If it is already installed, you can proceed with the installation of your product. If ArtfulBits License Manager is not installed, you can do it by one of the following methods:
-
Open ArtfulBits License Manager page, download its installer on your server, run it and install
-
Download Full Package of the product, find License Manager in ArtfulBits License Manager folder and run its installer
You must be a SharePoint Farm Administrator for successful installation. Also, "Windows SharePoint Administration" and "Windows SharePoint Timer" should be running on the server:
Download Product installation package from ArtfulBits website, unpack the file, and run Setup.exe:
After system check is finished, click "Next".
After reading License Agreement, click "Accept" and go to next step.
Select one or more web applications and click "Next".
Wait for install to succeed, click "Next" for deployment status details.
Close an installer after successful installation
All ArtfulBits SharePoint on-premise products use Per-Farm License Model (each license is bound to single SharePoint Farm ID). For more details about licensing models please visit License Agreement.
Product works in unlicensed mode for three days from the moment of installation. In this mode all the product features are unlocked same way as with trial license. After these three days either trial license, development license or full license should be entered for product to function.
To get Trial license click here.
After ArtfulBits License Manager is installed, go to the SharePoint Central Administration page:
This page shows all ArtfulBits installed products and their license statuses.
Click on product name to view license details.
If product is not licensed you can click "Enter License" link and enter license key (trial, development or full) into textbox. For upgrading product edition click "Convert License" and enter new license of target product edition.
Pressing "Activate" button will verify the key and in case of verification success license status will be updated.
Note: in trial or unlicensed mode all product features are available for evaluation. This way you will be able to try each and every feature available in the product line which will give you good understanding of what feature set will be necessary for you and it will be easier to come up with the decision which product edition should be purchased. After trial period expiration full license should be purchased which will determine product edition and available (unlocked) feature set.
Special link informing about product expiration is shown in SharePoint pages, where ArtfulBits component is used if product is using trial license or such license is "Expired" or no license is provided at all. Clicking on this link will redirect to product license status details page.
Click "Site Actions" menu in the root site of one site collection, then click "Site Settings":
Click "Site collection features" link in Site Settings page:
In SharePoint Site collection feature list, activate ArtfulBits product feature (if deactivated):
Process of updating is pretty straightforward - just download latest installation package and execute Setup.exe from it. After system check completes, select an "Upgrade" option and then follow setup wizard instructions.
Execute Setup.exe from your installation package. On the Repair and Remove section, select Remove radio button and click "Next", the program will be uninstalled. Or select "Repair" - to repair the program.
cascaded lookup userguide 938 KB
User guide.
cascaded lookup installguide 989 KB
Install guide.
artfulbits_cascaded_lookup_v2.5_SP2019.zip Version 2.5 (1 MB)
Zip file contains Cascaded Lookup Column install files for SharePoint 2019, user guide and install guide documents. For more details about installation process select Installation tab.
artfulbits_cascaded_lookup_v2.5_fullpack_SP2019.zip Version 2.5 (3 MB)
Zip file contains Cascaded Lookup Column and License Manager install files for SharePoint 2019, user guides and install guides documents for both products. For more details about installation process select Installation tab.
artfulbits_cascaded_lookup_v2.5_SP2016.zip Version 2.5 (1 MB)
Zip file contains Cascaded Lookup Column install files for SharePoint 2016, user guide and install guide documents. For more details about installation process select Installation tab.
artfulbits_cascaded_lookup_v2.5_fullpack_SP2016.zip Version 2.5 (3 MB)
Zip file contains Cascaded Lookup Column and License Manager install files for SharePoint 2016, user guides and install guides documents for both products. For more details about installation process select Installation tab.
artfulbits_cascaded_lookup_v2.5_SP2013.zip Version 2.5 (1 MB)
Zip file contains Cascaded Lookup Column install files for SharePoint 2013, user guide and install guide documents. For more details about installation process select Installation tab.
artfulbits_cascaded_lookup_v2.5_fullpack_SP2013.zip Version 2.5 (3 MB)
Zip file contains Cascaded Lookup Column and License Manager install files for SharePoint 2013, user guides and install guides documents for both products. For more details about installation process select Installation tab.
artfulbits_cascaded_lookup_v2.4_SP2010.zip Version 2.5 (2 MB)
Zip file contains Cascaded Lookup Column install files for SharePoint 2010, user guide and install guide documents. For more details about installation process select Installation tab.
artfulbits_cascaded_lookup_v2.4_fullpack_SP2010.zip Version 2.5 (3 MB)
Zip file contains Cascaded Lookup Column and License Manager install files for SharePoint 2010, user guides and install guides documents for both products. For more details about installation process select Installation tab.
artfulbits_cascaded_lookup_v2.0_SP2007.zip Version 2.5 (2 MB)
Zip file contains Cascaded Lookup Column install files for SharePoint 2007, user guide and install guide documents. For more details about installation process select Installation tab.
artfulbits_cascaded_lookup_v2.0_fullpack_SP2007.zip Version 2.5 (3 MB)
Zip file contains Cascaded Lookup Column and License Manager install files for SharePoint 2007, user guides and install guides documents for both products. For more details about installation process select Installation tab.
