Cascaded Lookup Online Column - v1.0

Type: Online

License scope:

Site

Site

Site Collection

Tenant

Cascaded Lookup Column is intended to enhance standard SharePoint lookup functionality. Component allows building parent-child relationship between columns.

Cascaded Lookup Online Column - v1.0 On-Premises Version

$55.00

Description

Description

Specifications

Instruction

White papers

Download

Parent and child relationships with unlimited number of cascading levels

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

Cascaded Lookup Online Column - v1.0 description, photo 1
Cascaded Lookup Online Column - v1.0 description, photo 2

Single-single, single-multi, multi-single and multi-multi relations

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.

For multiple data entry, just select the "Allow multiple values" option, the front-end UI will allow multiple selections to be added/removed from a list.

JSLink and REST API support

JSLink provides a possibiliy to quickly and easily change rendering of the list views and forms. Particularly, how the fields in the list should be displayed.

REST calls can be made for creating genuine business scenarios.

Cascaded Lookup Online Column - v1.0 description, photo 3
Cascaded Lookup Online Column - v1.0 description, photo 4

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
Lookup data from lists cross-site within site collection
Lookup data from lists on the same site
Lookup data from the same list
Single and multiple lookup
Default displayed column types
Additional displayed column type : Currency Column
Additional displayed column type : Boolean Column
Parent-child relationships
Supported default values
Adding lookup items via New Item form on the fly
Conversion among "ArtfulBits Cascaded Lookup" column and standard SharePoint "Lookup" column
SharePoint Lookup ArtfulBits Cascaded Lookup

Release Notes

Version
v1.0
(March 01, 2018)
Notes
Initial Release
;
There are two ways to install the app in your SharePoint online:
  • Directly from the SharePoint Store
  • Manually adding the app to your internal App Catalog

1. INSTALLING THE APP FROM SHAREPOINT STORE

Click settings wheel in Office 365 and choose "Add an app" option
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 2
Click the "SharePoint Store" link in the list of your apps (Quick launch)
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 3
You will be redirected to the SharePoint Store where you can search for the app you need to install
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 4
Click App icon you want to add. You will be redirected to App Page. Click “ADD IT” button.
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 5
Install the free version by clicking “Trust it” button.
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 6
You will be redirected to Site Contents page where you can see the process of adding your app.
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 7
IMPORTANT: You will be asked to install "ArtfulBits Tenant App", if it wasn't yet installed. All ArtfulBits apps function in combination with this app. Its main goal is to take all shared functionalities out of boundaries of other ArtfulBits apps, and to empower functionalities that require higher app permissions.
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 8
Install the “Artfulbits Tenant App” app (if it is not installed). More information you can learn here.
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 9
You will be redirected to Site Contents page where you can see the process of adding your app.
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 10
If everything is ok, you will see ArtfulBits Cascaded Lookup in your site contents.
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 11

2. MANUALLY ADDING THE APP TO YOUR INTERNAL APP CATALOG

Download App installation package from ArtfulBits website, unzip archive.
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 12
Navigate to your SharePoint Admin Center.
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 13
Add app file of the product from the unzipped archive to your Apps Catalog.
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 14
Click settings wheel in Office 365 and choose "Add an app" option.
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 15
Select the App you want to add.
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 16
Click “Trust it” when prompted.
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 17
If everything is ok, you will see ArtfulBits Cascaded Lookup in your site contents.
Cascaded Lookup Online Column - v1.0 sharepoint tutorial, photo 18

artfulbits_cascaded_lookup_online_v1.0.zip Version 1.0 (814 KB)

Zip file contains Cascaded Lookup Online Column install files for SharePoint Online and user guide document. For more details about installation process select Installation tab.

artfulbits_cascaded_lookup_online_v1.0_fullpack.zip Version 1.0 (820 KB)

Zip file contains Cascaded Lookup Online Column and ArtfulBits Tenant App install files for SharePoint Online and user guides documents for both products. For more details about installation process select Installation tab.

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.