The Sparqube Lookup Column is a third-party SharePoint component suite that significantly extends the standard SharePoint lookup field’s capabilities by enabling cross-site collection lookups, cascading fields, and advanced filtering. It consists of three primary components—Classic, Extra, and Tracker—each designed for specific data-linking scenarios like auto-complete textboxes or large-list management. Core Features & Capabilities
Cross-Site Lookups: Unlike standard SharePoint columns that are limited to the same site, Sparqube allows referencing list data from any site within a site collection or even across different site collections.
Cascaded (Parent-Child) Lookups: You can create dependencies where selecting a value in one column (e.g., Country) filters the available options in another (e.g., City).
Advanced Controls: To handle large lists effectively, it provides a Picker Dialog and Auto-complete textboxes, which prevent the performance lag often seen with standard dropdowns in large environments.
Flexible Filtering: Users can apply custom list view filters or specify specific criteria to limit the data shown to end-users, ensuring more accurate data selection. The Component Suite
The suite provides three distinct column types to match different functional needs:
Sparqube Lookup Classic: Primarily for extending standard capabilities and enabling cross-site data referencing.
Sparqube Lookup Extra: Offers more advanced UI controls like the auto-complete feature and custom CSS styling for columns.
Sparqube Lookup Tracker: Specialized for tracking data changes and maintaining relationships between complex datasets. Quick Setup for Cascading Columns
To master the cascading feature (e.g., Country > Region > City), follow these general steps in the Sparqube settings:
Add the Parent Column: Create a new column, select Sparqube Lookup, and choose your source list and target display column.
Add the Dependent Column: Create a second lookup column and check the “Make this a dependent column” option.
Define the Relationship: Select the previously created column as the Parent Column and specify the Filter Column in the source list to link them.
For detailed technical documentation or to download the latest version (
), you can visit the Sparqube Download Page or refer to their official User Guide.
If you’d like, I can provide a step-by-step for a specific setup, like connecting lists across different site collections or configuring the auto-complete picker. Which Sparqube Lookup Column for SharePoint Manual
Leave a Reply