UltimateForms Connected Field

Create cascading master-detail relationships between lookup columns in SharePoint lists and document libraries. Filter city column values by country, it is as easy as it should be!
Connected Field, a component of UltimateForms, helps you take the built-in lookup columns to a new level:
  • Unlimited number of cascading levels - you can chain together as many columns are you like, each parent can have unlimited children and each child can have its own children.
  • Missing values can be added directly, without interfering with your current task
  • Support single-to-single, single-to-multiple, multiple-to-single and multiple-to-multiple relationships
  • Looks and behaves like the built-in lookup column, no user training required
  • Operates both as a cascading lookup and as a regular lookup
  • Optional auto-complete functionality
  • Filter available values interactively and according to a pre-selected SharePoint view
  • Add addtional linked lookup columns and update their values automatically
  • Convert to and from built-in lookup columns
  • Support for site columns and content types - create the master-detail relationship at the root site and reuse it throughout your site collection.
  • Editable in Datasheet view (2010) when used together with Smart List Pro
SharePoint 2013 app version of this product is available in Office Store. It can be installed both on premises and on Office 365 sites.
Connected Field makes it easier for you to enter data into your SharePoint lists and document libraries. By creating relationships between columns you limit the number of possible values, preventing input errors. With advanced features like filtering and sorting by view, additional filters, in-place value entry and more, you make your system more intuitive and easier to use.
  • Create categories and subcategories for your documents across the system
  • In the middle of create an invoice and just realized you are missing the customer? Add it directly from the invoice, without going to a different list and losing your work
  • Save time and errors typing in values
  • Run the installation file to extract and install the product. You must be a farm administrator to accomplish this task.
  • Create a new list called Product Categories, and fill it with sample data.
  • Create a second list called Products, and add a regular lookup field to Product Categories, name it Category and fill this list with sample data.
  • Create a third list called Sales
  • Add a lookup field to Product Categories, name it Category
  • Add a Master-detail lookup field and define it according to the following:
    • In the lookup section define the field as a lookup to Products.
    • In the Parent Field select the Category field you (the lookup to Product Categories).
    • In Link Column choose the Category(the field that was mapped to Product Category in Products the filtering field in the lookup list).
  • Now add a new item to the list and see that as you choose a value from Category field, the Products field will be filtered accordingly (no page refresh is needed).

Feature Image Our Product SharePoint Native
Complete replacement for the built-in lookup, with additional features   Included  
Filter lookup field according to another lookup field caption  Included  
Unlimited number of levels of cascading filtering   Included  
Allows entering new values directly from the column caption  Included  
Allows entering new values through a popup window caption  Included  
Supports site columns and content types   Included  
Supports single-single, single-multi, multi-single and multi-multi selections   Included  
Optionally filter values by view   Included  
Optionally sort values by view   Included  
Convert to and from regular lookup columns caption  Included  
Create and manage additional columns from the source list   Included  
Limit available values by one or more additional filter   Included  
Supports English, German, French, Spanish and Russian   Included  
Note: unless specifically stated otherwise, all products require only SharePoint Foundation 4.0/5.0. Microsoft SharePoint Server 2010-2016 is supported, but not required. Except for SharePoint 2013-2016 apps, all of our products must be installed as farm solutions.
Want to get notified when new versions come out? Subscribe to our RSS feed now!
Version Release Date Changes
2.16.0 21-May-2018
  • Added: ability to upload child documents by clicking new
2.15.8 30-Nov-2017
  • Fixed: selection of the first result in auto-complete mode of a required field
2.15.7 06-Sep-2017
  • Fixed: access to new field value by Smart List Pro
  • Fixed: required field validation
2.15.6 09-Jan-2017
  • Fixed: Item Copier support for copying cascaded fields
  • Fixed: handling read-only / hidden permissions on parent column
2.15.5 06-Jan-2017
  • Fixed: initialization in forms with CSR
2.15.4 15-Nov-2016
  • Added: support for the new Associated Tasks Field grid entry mode
  • Fixed: adding new item through the field breaking functionality of other fields in form
  • Fixed: client side error on multiple lookup parent field
2.15.3 12-Jul-2016
  • Fixed: loading multi lookup child column value
2.15.2 26-May-2016
  • Fixed: adding a new item when parent column is empty
Most Recent Newer  
Want to try before you buy? Just download the 30-day full-featured trial version! You can even turn it into a registered version by simply entering a license key.
License Type Price Buy Now
Server License with Annual Support 599 US$
Server License 449 US$
Developer License 139 US$
Annual Support Renewal 129 US$

Every server running Windows SharePoint Services Web Application requires a license, regardless whether or not it is accessed by users. Free licenses for application servers will be provided upon request.

License Types

  • Server License with Annual Support - entitles you to the right of installing the product on one front-end server, including the right to contact us on non-bug related issues within the period of one year, you may also upgrade to any future major/minor version.
  • Server License - entitles you to the right of installing the product on one front-end server. Front-end server is one responding to user requests (web server). This license is not time-limited, but you are not entitled to new major/minor versions, except for explicit bug fixes within the first 12 months.
  • Developer License - entitles you to the right of installing the product on one front-end server in non-production environment. Note that you must order at least one full server license to have the right to order a developer license.
  • Annual Support Renewal - extends the annual support for another year.