Cascading LookApp (Office 365)
Cross-site, filtered, cascaded Lookup field for SharePoint Online
The Cascading LookApp field enables non-technical business users to turn SharePoint Lookup columns into “Super Lookup” columns that include the below-mentioned additional capabilities.
Easily create lookup to lists across the SharePoint site-barrier. Now with the Cascading LookApp you can create a lookup to remote lists that are located in various sites.
Now you can easily create lookup fields that are filtered by list view, which enables displaying different lookup content to different users!
Easily filter field values by other fields in the same list.
Example: would you like to display “Region”, “Country” and “City” fields, where each one filters the next field? SharePoint Cascading LookApp empowers you to implement that with just the click of a button!
Do you have a long drop-down of values requiring users to scroll-up and down until they find what they need?
No more! With KWizCom’s Cascading LookApp you can simply type part of the text you are looking for and the matching items will appear for selection.
Do you have a lookup connected to a list including duplicate values?
Now you can filter the lookup by other columns from the lookup list, enabling you to display only unique values and make it a lot easier for users to find what they need!
| Feature | KWizCom Cascading LookApp |
|---|---|
| Cross-site Lookup fields | |
| Filter lookup values by view | |
| Filter lookup values by typed text | |
| Filter lookup values by other column values from the target list | |
| Cascaded lookup fields |
KWizCom Forms
Easily create dynamic & smart forms in minutes without any need for technical skills!
Repeating Rows Field Type
Multi-row forms in SharePoint!
Column/Field Permissions
Dynamically show, hide or disable fields in your SharePoint forms!
| Version | 2.0.29 |
| Base version | 2.0.24 |
| Release date | Oct-24-2019 |
| 6285 | Fixed: Cascading lookapp fields will not show values if the source is a document library and any view is used to filter values |
| 5906 | Fixed: filtering items in the Cascading LookApp column is not populating any values |
| 5674 | Improved: Performance improvements in IE/Firefox |
| 5000A | Fixed: When additional filters from the lookup list displayed + kwizcom forms used - the lookup field stretches |
| 5561 | Fixed: cascading lookAPP sometimes unable to detect document libraries that it is launched in |
| Important: For apps to work on your O365 tenant, you need to allow custom script. Click to view detailed instructions. |
Adding this app to your site is done by following these steps:
- Add the required solution packages – organization level
- Add the app package to your organization’s App Catalog.
- Add the app to your site
Add the required solution packages – organization level
The required solution packages include shared utilities which are used by all KWizCom apps. These packages must be installed by your SharePoint Admin at the organization level.
This step is different between SharePoint Online and SharePoint 2016/2019 Server. Please follow the guidelines according to your SharePoint version
SharePoint Online
As a Tenant Admin:
| 1. | Download this zip file. |
| 2. | Go to the “Apps for SharePoint” library in your App Catalog site:
|
| (To learn more about how to manage your company’s App Catalog, please refer to the relevant Microsoft documentation for SharePoint On-Premises and for SharePoint Online) | |
| 3. | Upload the KWizComAppsFoundation.app package from the extracted zip file. |
| 4. | Upload the kwizcom-modern-apps-upgrade.sppkg package from the extracted zip file. After the package is uploaded you will see the following popup: |
 |
|
| Click “Deploy” button to properly deploy it. | |
| 5. | On the top-level site go to Site Contents and click “add app”
Add the “KWizCom Apps Foundation” app from your organization. |
SharePoint 2016/2019 Server
As a SharePoint Farm Admin:
| 1. | Download this zip file. |
| 2. | Install and deploy the KWizCom Apps Foundation Full Trust.wsp package using the PoSH script from the extracted zip file
or by using the standard SharePoint Add-SPSolution and Install-SPSolution commands. |
Add the app package to your organization’s App Catalog
Note: It is possible to install the app directly from the Microsoft app store but it is not recommended.
As a Tenant Admin:
| 1. | Download this zip file. |
| 1. | Go to the “Apps for SharePoint” library in your App Catalog site:
|
| 2. | Upload the package to your App Catalog. |
Add the app to your site
After the required solution packages are installed, site owners can now add the app to their sites.
Adding an app to a site is done by following these steps:
| 1. | Go to the site where you want to add the app. |
| 2. | Click on the gear icon at the top-right corner to open site actions menu |
| 3. | Click on “Add an app”
|
| 4. | If the app package was added to your organization’s App Catalog (see previous step) then select “From Your Organization” option in the quick launch:
|
|
Otherwise, select “SharePoint Store”: Note: Adding the app from the Microsoft store is not recommended because this service is not as reliable as adding the app from the organization app catalog.
|
|
| 5. | To find your KWizCom app, enter the app name in the search field in the upper right corner of the page and then click enter. |
| 6. | Click the app that you wish to add to your site, and then click “Trust It” button in the popup page that will appear. The app will then be added to your site, this might take a few moments. |
Update your installed app with a new version
When a new app build is released there is no need to re-install the solution package.
All you need to do is:
- Clean your browser’s cache and close all browser windows.
- Visit the app’s settings page – this will update your installed app with the new version’s javascript files.
| DESCRIPTION | VERSION | DATE | |
|---|---|---|---|
| DESCRIPTION: User Guide | VERSION: 2.0.29 | DATE: Oct-24-19 | DOWNLOAD |
| #Users | SKU | Price (USD) | Payment Type | |
|---|---|---|---|---|
| #Users: Up to 100 | SKU: ASCAL-100 | Price (USD): $650 | Payment Type: Annual | Get a Quote |
| #Users: 101 to 1000 | SKU: ASCAL-1000 | Price (USD): $650+$1.4/user | Payment Type: Annual | Get a Quote |
|
Subscription includes:
✓ Unlimited site collections |
|
Top