Lookup Columns Bundle
Bundle of 3 products in one pack, сomplimenting and enhancing the default SharePoint lookup column function. These three enhancements offer a bundle of features that effectively enhancing your SharePoint lookup functionality. Cross-site Lookup gets an information from another site within site collection, while Cascaded Lookup builds more relationships between parent and child columns. And finally, Parent Selector summarizes information related to an item in a list to display hierarchical data.
Want to get a 5% discount on your next purchase? Write us the history of using the purchased item.
Have questions? Write us
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.
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.
Default SharePoint Lookup supports only lookup within the same site, so if you need to lookup data from another site, you cannot use it. ArtfulBits Cross-Site Lookup allows users to refer to a list from any site in site collection and across site-collections, applying list view filtering to retrieved data.
If list contains large amounts of data, it is not very efficient to search for some data using standard SharePoint lookup. ArtfulBits Cross-Site Lookup with Picker Dialog helps to resolve this issue. You can search/filter data in picker dialog, which helps to find the required item quickly.
Parent Selector Column
If you have hierarchical data in a list and you need to lookup data in own list (containing list), using ArtfulBits Parent Selector column is the best choice.
Parent Selector Column is intended to lookup to self (containing list) in order to display hierarchical data. Main difference with standard SharePoint Lookup is absence of own item (standard SharePoint Lookup contains own item).
You can choose multiple columns from the list for looking up information. It is also possible to allow multiple values to be chosen from these columns for your new item.
You can easily convert existing standard Lookup column to "ArtfulBits Parent Selector" column and use data filtering, picker dialog, and other features for your list.
Lookup Columns Bundle significantly enhancing its functionalities in different scenarios versus Standard lookup functionality which provides minimum options for the user. By using our 3 components pack user can extend lookup functionality to its full potential. Cross-Site Lookup Column gets information from any site within site collection, applying list view filtering to retrieved data. Cascaded Lookup Column allows building relationship between parent and child columns, while Parent Selector Column is intended to lookup to self (containing list) in order to display hierarchical data.
|What you get|
|Cascaded Lookup Column|
|Cross-Site Lookup Column|
|Parent Selector Column|
|List Price||20% Discount||Discounted price|
|$700.00||You save $140.00||$560.00|
Windows Server 2012 R2 Standard or Datacenter, 64 bit
Windows Server (2016)
- SharePoint Server 2016
- Microsoft .NET Framework 4.5+
Internet Explorer 10+
Google Chrome (latest released version)
Mozilla Firefox (latest released version plus immediate previous version)
Apple Safari (latest released version)
Windows Server 2008 R2 SP1
Windows Server 2012
- SharePoint Foundation 2013 or SharePoint Server 2013
- Microsoft .NET Framework 4.0
Internet Explorer 8+
Windows Server 2008 x64 SP2
Windows Server 2008 R2
Windows 7 x64
- SharePoint Foundation 2010 or SharePoint Server 2010
- Microsoft .NET Framework 2.5
Internet Explorer 8+
Windows Server 2003 x86/x64
Windows Server 2008 x86/x64
Windows Small Business Server (SBS) 2003/2008
- Windows SharePoint Services v3 or SharePoint Server 2007
- Microsoft .NET Framework 2.0 or 3.0
Internet Explorer 7+
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.
ArtfulBits_Lookup_Columns_Pack_v3.0_SP2016.zip Version 3.0 (7 MB)
Zip file contains Lookup Columns Bundle install files for SharePoint 2016, user guide and install guide documents. For more details about installation process select Installation tab.
ArtfulBits_Lookup_Columns_Pack_v3.0_SP2013.zip Version 3.0 (7 MB)
Zip file contains Lookup Columns Bundle install files for SharePoint 2013, user guide and install guide documents. For more details about installation process select Installation tab.
ArtfulBits_Lookup_Columns_Pack_v3.0_SP2010.zip Version 3.0 (7 MB)
Zip file contains Lookup Columns Bundle install files for SharePoint 2010, user guide and install guide documents. For more details about installation process select Installation tab.
ArtfulBits_Lookup_Columns_Pack_v2.0_SP2007.zip Version 3.0 (7 MB)
Zip file contains Lookup Columns Bundle install files for SharePoint 2007, user guide and install guide documents. For more details about installation process select Installation tab.