Cross-Site Lookup Column
Type: On-Premises
Edition:
Standard
Use Cross-Site Lookup Column for getting data from any site within site collection. Component includes a powerful function of searching over lookup list. This function provides substring matching in selected column which is very useful for large lists (over 50-100 items).
Want to get a 5% discount on your next purchase? Write us the history of using the purchased item.
Cross-Site Lookup Column Online Version
Have questions? Write us
$250.00
Description
Lookup data from SharePoint lists in all sites across site-collections
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.
Picker Dialog for searching items in large lookup lists
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.
Adding lookup items via inline entering on the fly
You can enable adding of lookup items on the fly by choosing Item is added using separate list New Form or Item is added on fly directly on current page option.
There are two ways how to do that: via new item form or inline entering.
Multiple additional features
1. Easy conversion from default SharePoint Lookup Column and back
For easy and fast editing Cross-Site Lookup columns content in Datasheet view you may need to convert the column.
2. JSLink and REST API support
JSLink provides a possibility to quickly and easily change rendering of the list views and forms.
3. 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 |
|---|
| Supported lookup data from SharePoint lists in all sites within site collection |
| Powerful function of searching over lookup list by using a Picker Dialog |
| Supported lookup data from subfolders |
| Filtering retrieved data using existing list views |
| Single and multiple lookup for standard mode and using Picker Dialog |
| Ability to add and edit lookup items on the fly |
| Supported default values |
| Supported Datasheet view, including edit mode |
| Supported JSLink |
| 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 2016 | SP 2013 | SP 2010 | SP 2007 |
|---|---|---|---|
Release Notes
| Version |
|---|
| v2.32 (June 15, 2017) |
| v2.31 (May 15, 2017) |
| v2.2 (April 1, 2016) |
| v2.0 (April 29, 2013) |
| v1.83 (April 27, 2012) |
| v1.82 (February 2, 2012) |
| v1.81 (December 2, 2011) |
| v1.8 (June 03, 2011) |
| v1.7 (November 16, 2010) |
| v1.6 (September 02, 2010) |
| v1.5 (August 3, 2010) |
| v1.43 (July 08, 2010) |
| v1.42 (June 23, 2010) |
| v1.41 (June 11, 2010) |
| v1.4 (May 28, 2010) |
| v1.3 (May 13, 2010) |
| v1.2 (April 22, 2010) |
| v1.1 (February 01, 2010) |
| v1.1 (January 12, 2010) |
| v1.0 (November 02, 2009) |
| Notes |
|---|
Bugs Fixed:
|
Improvements:
Bugs Fixed:
|
New Features:
|
New Features:
|
Improvements:
|
Bugs Fixed:
|
Bugs Fixed:
|
New Features:
Improvements:
|
New Features:
Bugs Fixed:
|
New Features:
|
New Features:
|
Bugs Fixed:
|
Bugs Fixed:
|
Improvements:
Bugs Fixed:
|
New Features:
|
New Features:
Improvements:
|
New Features:
Bugs Fixed:
|
Bugs Fixed:
|
New Features:
Improvements:
|
| Initial Release |
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.
cross-site lookup userguide 693 KB
User guide.
cross-site lookup installguide 977 KB
Install guide.
artfulbits_cross-site_lookup_v2.32_SP2016.zip Version 2.32 (2 MB)
Zip file contains Cross-Site Lookup Column install files for SharePoint 2016, user guide and install guide documents. For more details about installation process select Installation tab.
artfulbits_cross-site_lookup_v2.32_fullpack_SP2016.zip Version 2.32 (4 MB)
Zip file contains Cross-Site 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_cross-site_lookup_v2.32_SP2013.zip Version 2.32 (2 MB)
Zip file contains Cross-Site Lookup Column install files for SharePoint 2013, user guide and install guide documents. For more details about installation process select Installation tab.
artfulbits_cross-site_lookup_v2.32_fullpack_SP2013.zip Version 2.32 (4 MB)
Zip file contains Cross-Site 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_cross-site_lookup_v2.2_SP2010.zip Version 2.32 (2 MB)
Zip file contains Cross-Site Lookup Column install files for SharePoint 2010, user guide and install guide documents. For more details about installation process select Installation tab.
artfulbits_cross-site_lookup_v2.2_fullpack_SP2010.zip Version 2.32 (3 MB)
Zip file contains Cross-Site 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_cross-site_lookup_v2.0_SP2007.zip Version 2.32 (2 MB)
Zip file contains Cross-Site Lookup Column install files for SharePoint 2007, user guide and install guide documents. For more details about installation process select Installation tab.
artfulbits_cross-site_lookup_v2.0_fullpack_SP2007.zip Version 2.32 (3 MB)
Zip file contains Cross-Site 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.
