Parent Selector Column

Type: On-Premises




Parent Selector Column is used for organizing hierarchical relations in SharePoint list. Picker dialog allows choosing data from large lists. Standard Lookup column can be easily converted to Parent Selector column and vice versa.

Want to get a 5% discount on your next purchase? Write us the history of using the purchased item.

Have questions? Write us







White papers


Convenient organization of large list hierarchical data

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).

Parent Selector Column description, photo 1
Parent Selector Column description, photo 2

Picker dialog and filtering for multiple columns and values

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.

Various target column types

Parent Selector column supports such target column types:

  • Single Line of Text
  • Number
  • Date and Time
  • Calculated (output is single line of text)
  • Counter type (ID field)

To use Parent Selector column you must select appropriate option in the list of available columns at the Create Column page. In the Parent Selector Special Settings section you can change default settings in order to adjust column mode to your needs.

Parent Selector Column description, photo 3
Exclude own item from lookup list
Supported lookup data from subfolders
Powerful function of searching inside lookup list by using a Picker Dialog
Filtering retrieved data using existing list views
Single and multiple lookup for standard mode and using Picker Dialog
Validating Hierarchical Integrity (checking whether hierarchical data is non-cyclic)
Supported default values
Supported Datasheet view
Conversion between "ArtfulBits Parent Selector" column 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

(June 15, 2017)
(May 15, 2016)
(April 1, 2016)
(April 29, 2013)
(December 2, 2011)
(June 03, 2011)
(December 11, 2010)
(November 16, 2010)
(August 11, 2010)
(August 03, 2010)
(July 08, 2010)
(June 23, 2010)
(June 11, 2010)
(May 28, 2010)
(May 13, 2010)
(April 22, 2010)
(February 01, 2010)
(January 14, 2010)
(January 12, 2010)
(November 02, 2009)
Bugs Fixed:
  • Correct display of different column values' types
  • Document library with lookup column error is fixed
  • Lookup column default value can be provided now
  • Default value changed from textbox to drop down

Bugs Fixed:
  • Fixed minor issues
New Features:
  • Added SharePoint 2016 support
New Features:
  • Added SharePoint 2013 support
  • Added possibility of setting maximum item count for picker dialog search
  • Added Russian and German localization
Bugs Fixed:
  • Fixed column value editing using Picker Dialog
  • Fixed minor issues
New Features:
  • Added default values support

  • Added support for new licensing model (ArtfulBits License Manager v1.4)
  • Added "Save site as template" support
  • Added Content Type support

Bugs Fixed:
  • Fixed minor issues
New Features:
  • Added Russian and German localization

Bugs Fixed:
  • Fixed minor issues
  • Allowed assembly partially trusted callers

Bugs Fixed:
  • Fixed problem with adding new Parent Selector column to list (SharePoint 2010 only)
New Features:
  • Added Datasheet view support
Bugs Fixed:
  • Fixed lookup to sub folder (column settings page issue)
Bugs Fixed:
  • Fixed "Allow multiple values" property changing issue (from False to True)
  • Fixed error with 6622 Event ID in Event Viewer (Field type DummyField has duplicated definition)
  • Improved Setup Wizard

Bugs Fixed:
  • Disabled ability of choosing DateTime and Number column as lookup target column for SharePoint 2007
New Features:
  • Added ability to lookup data from subfolder
New Features:
  • Added ability to show additional fields (SharePoint 2010 only)
  • Added relationships behavior: restrict or cascaded deleting (SharePoint 2010 only)

  • Added support DateTime and Number columns as target columns (SharePoint 2010 only)
  • Lookup entries sorting during item editing
New Features:
  • SharePoint 2010 support added
Bugs Fixed:
  • Problem with product version (Setup Wizard only)
Bugs Fixed:
  • Problem with some SharePoint language packs
New Features:
  • Added Validate Hierarchical Integrity (checking whether hierarchical data is non-cyclic)

  • Improved picker dialog (Lookup or Title columns are selected by default)
  • Improved column conversation (is more easy and clearly)
  • Improved Setup Wizard
Initial Release

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

parent selector userguide 823 KB

User guide.

parent selector installguide 893 KB

Install guide.

Components for Microsoft® SharePoint®

This website uses cookies to ensure the best possible use of our services. If you continue to use the website, you agree to the use of cookies.

More Information