You may be trying to access this site from a secured browser on the server. Please enable scripts and reload this page.
Turn on more accessible mode
Turn off more accessible mode
Skip Ribbon Commands
Skip to main content
Turn off Animations
Turn on Animations
Sign In
Release Notes
M365
Find & Replace
Version v1.1b05
Online Apps Foundation
Version v1.0b100
Version v1.0b99
Version v1.0b98
Version v1.0b97
Version v1.0b96
Version v1.0b95
Online Apps
Build 1025
Build 1024
Build 1023
Build 1022
Build 1021
Build 1020
Build 1019
Build 1018
Build 1017
Client Agent
Scan v1.4b04
Agent v1.10b38
Agent v1.1b36 & Scan v1.4b03
Scan v1.4b02
Agent v1.1b34
On Premises
Find & Replace
Version v1.1b05
Addons (legacy on premises)
Forms v15.6b09
Signature v11.1b03
Copy/Move v15.0b39
Calendar v15.5b93
Forms v15.6b07
Datasheet v15.2b02
Scan v15.2b09
Print v15.2b09
Online Apps Foundation
Version v1.0b100
Version v1.0b99
Version v1.0b98
Version v1.0b97
Version v1.0b96
Version v1.0b95
Online Apps
Build 1025
Build 1024
Build 1023
Build 1022
Build 1021
Build 1020
Build 1019
Build 1018
Build 1017
Client Agent
Scan v1.4b04
Agent v1.10b38
Agent v1.1b36 & Scan v1.4b03
Scan v1.4b02
Agent v1.1b34
Desktop
Find & Replace
Version v1.1b05
Client Agent
Scan v1.4b04
Agent v1.10b38
Agent v1.1b36 & Scan v1.4b03
Scan v1.4b02
Agent v1.1b34
Documentation
apps (classic lists)
Classic Apps Installation
Installing the KWizCom apps on SharePoint Online
Installing the KWizCom apps on SharePoint 2019
Knowledgebase
KWizCom Forms app
Overview
Key Features
KWizCom Forms app administration
Column Permissions
Product Overview
Key Features
Configuring Column Permissions
Default Values
Product Overview
Key Features
Configuring default values
Field Constraints
Product Overview
Key Features
Configuring field constraints
Setting-up a field constraint
Using custom patterns
Creating a new custom pattern
View Permissions
Product Overview
Configuring view permissions
Form Quick Navigation
Product Overview
Configuring form quick navigation
Form Layout
Product Overview
Key Features
Customizing the list form layout
General display settings
Groups (Tabs/Sections)
Custom Actions
Product Overview
Custom Actions and Activities
Managing Activities
Create/Edit Activity
Using dynamic tokens and variables in activities
Managing custom actions
Create/Edit Custom Action
binding variables in custom actions
Custom Action History
Knowledgebase
Cascading LookApp
Overview
Key Features
Cascading Lookapp Configuration
Settings page properties
Usage examples
Example 1: Converting the “Account” Lookup to a Cascading LookApp
Example 2: Converting the “Account Contacts” Lookup to a Cascading LookApp
Knowledgebase
Conditional Formatting app
Overview
Key Features
CF Column Configuration
Settings page properties
Knowledgebase
Countdown app
Overview
Countdown column configuration
Knowledgebase
KPI app
Overview
Key Features
KPI Column Configuration
Settings page properties
Knowledgebase
Repeating Rows app
Overview
Key Features
Repeating Rows Configuration
Configuring a multi-row form
STEP 1: PREPARE YOUR LISTS
STEP 2: CREATE THE REPEATING ROWS COLUMN
STEP 3: CONFIGURE THE REPEATING ROWS COLUMN
STEP 4: CHECK YOUR REPEATING ROWS COLUMN IN RUN-TIME
Configuring connected documents
Repeating Rows column - A look behind the scenes
REPEATING ROWS COLUMN = LOOKUP COLUMN
SUMMARY FIELD = NUMBER-TYPE COLUMN
WHAT HAPPENS WHEN YOU DELETE AN ITEM?
Knowledgebase
Paste+ app (classic)
Paste Plus Overview
Key Features
Paste Plus Configuration
Using Paste Plus
What happens when you paste?
What can I copy from my desktop to SharePoint rich-text field?
Knowledgebase
Print app (classic)
Client Installation
Client Software Requirements
Overview
Key Features
Print app Configuration
Page Layout Settings
Header/Footer Settings
Watermarks Settings
Knowledgebase
Scan app (classic)
Overview
Key Features
Scan app Configuration
Using Scan app
Scanning Documents
KWizCom Scan Client
Knowledgebase
Knowledgebase
List types not supported by KWizCom Apps
Hide Data View Plus from web part Toolbox
KWizCom Environment Picker For Chrome
How to enable custom scripting in SharePoint Online
Summary
Resolution
How to enable custom scripting on a group/communication site
Question
Answer
KWizCom SharePoint (Add-ins) Apps Architecture
Modern Apps
Overview
Modern Apps Installation
KWizCom Forms add-on to app migration
Export:
Installing KWizCom modern apps in your tenant
Installing Modern apps only in specific sites
Installing KWizCom modern apps on SharePoint 2019
Switching from Classic Apps to Modern Apps
Installing KWizCom modern apps in your site
Installing KWizCom modern apps on SharePoint 2019 site
Activating the KWizCom modern apps in your list
Modern Forms
Overview
KWizCom Forms Display Mode
Key Features
Dynamic Column Permissions
Feature Overview
Key Features
Configuring Column Permissions
Configuring multiple rules for a column
Default Values
Key Features
Configuring default values
Configuring multiple rules for a column
Field Constraints
Feature Overview
Key Features
Configuring field constraints
Using custom patterns
Edit patterns
Configuring multiple rules for a column
Form Layout
Feature Overview
Key Features
Customizing the list forms layout
Creating a multi-tab form
Creating Collapsible groups layout
View Permissions
Feature Overview
Configuring view permissions
Form Quick Navigation
Feature Overview
Configuring quick navigation
Cascading LookApp
Feature Overview
Configuring Cascading LookApp column
Repeating Rows
Feature Overview
Configuring a multi-row form
Step 1: Prepare your lists
Step 2: Create the Repeating Rows column
Configuring a form with connected documents
External Data Lookup
Feature Overview
Creating External Data Lookup Column
External Data Lookup Implementation Details
Signature Pad
Feature Overview
Capture user signature
Draw & sign use-case
Signature Pad Configuration
Signing items - advanced scenarios
Url File Picker
Feature Overview
Countdown column
Feature Overview
Configuring the Countdown column
Custom Actions
Feature Overview
Managing Activities
Create/Edit Activity
Using dynamic tokens in activities
Managing Custom Actions
Create/Edit Custom Action
Settings tab
Activities tab
Conditions tab
Binding variables in custom actions
Default Actions
Custom Action History
Customizing form styles
Advanced customizations using custom scripts
Feature Overview
Implementing common requirements using code samples
Get additional columns from lookup item
"Live" calculated fields
"Live" calculated fields in Repeating Rows column
Get user profile properties
Knowledgebase
How to change button captions
Datasheet view app
Overview
Installing the Datasheet View app
Installation prerequsites
Client software requirements
Installation steps
Knowledgebase
How to display the Datasheet view by default
Does Datasheet view app work in Google Chrome
Print app
Overview
Key Features
Client Installation
Client Software Requirements
Configuring print settings
Page Layout Settings
Header/Footer Settings
Watermarks Settings
Scan app
Client Installation
Client Software Requirements
Post installation - configure scan profiles
Overview
Scan app configuration
Scan app site-level settings
Scan app library-level settings
Using Scan app
Scanning Documents
KWizCom Scan Client
Property mapping with Zonal OCR
Creating a Zonal OCR template
Using existing property-mapping template
Document Separator
Adding a document separator to a Zonal OCR template
Using document separators
Using Zonal OCR and document separator in Quick scan (silent) mode
External Data
Overview
Creating external data sources
External Data Source Settings
Info Tab
Parameters tab
Connection tab
Web REST API connection properties
Excel or CSV file properties
Custom code data source
Display columns tab
Using external data sources
Knowledgebase
KWizCom Forms add-on to app migration
Export:
How to enable custom scripting in SharePoint Online
Summary
Resolution
How to enable custom scripting on a group/communication site
Question
Answer
Uninstalling KWizCom modern apps in your tenant
KWizCom SharePoint (Add-ins) Apps Architecture
Data View Toolset (SPFx)
Overview
Installing Data View Plus app only in specific sites
Installing the Data View Tools package
Add Data View web parts to MS Teams
Web Part Configuration
Add a web part to a page
Configuring data-source & display-groups
Configure data source
Configure display-group
Configuring the web part display
Data sources
SharePoint List data source
SharePoint List Aggregator data source
SharePoint Search data source
Excel File data source
GRAPH API data source
Connect to Microsoft Graph settings page
Configure column info settings page
SharePoint User Profiles data source
'External Data' data source
Display controls
Info & Headers control
Menu bar control
Adding menu actions using the script editor
Paging control
Tabs control
Groups control
Table control
List control
Filter control
Filter control run-time features
Filter control configuration
Add/remove filters
Save a default filter for all users
Filter control properties
Conditional Formatting control
CF configuration
CF control properties
List View Plus app
Overview
Key Features
List View Plus web part configuration
Knowledgebase
List Aggregator app
Overview
Key Features
List Aggregator web part configuration
Knowledgebase
Calendar Plus app
Overview
Key Features
Calendar Plus web part configuration
Calendar Plus Data source Configuration
Color coding
Column mapping
Column display settings
Calendar Plus display configuration
Calendar control configuration
Knowledgebase
Org. Chart app
Overview
Key Features
Org. Chart run-time behavior
Org. Chart web part configuration
Org. Chart data source configuration
Color coding
Column mapping
Org. Chart display configuration
Org. Chart control configuration
Org. Chart conditional formatting
Apply colors to employee boxes according to various conditions
Render selected employee boxes as "Assistant" nodes
Hide selected employee boxes according to a condition
Specific employee node settings
Knowledgebase
Picture Gallery app
Overview
Key Features
Picture Gallery web part configuration
Picture Gallery Data source Configuration
Mapping Picture Gallery's displayed properties
Picture Gallery display configuration
Picture Gallery controls configuration
Camera Slideshow control's properties
Photopile control's properties
Picture Gallery control's properties
Knowledgebase
Data View Plus app
Overview
Data View Plus Configuration
Data View Plus Filter Provider configuration
Data View Plus display configuration
Custom control configuration
Knowledgebase
Shared Filter app
Overview
Shared Filter web part configuration
Configure mapped columns
Create filter section/s
Add filters and connect each to mapped columns
Connect the Data View web parts to the Shared Filter web part
Map shared filters to web part datasource columns
Additional Shared Filter web part settings
Knowledgebase
Hide Data View Plus from web part Toolbox
KWizCom Environment Picker For Chrome
Adding Javascript file to modern page
How to only show sub-folder contents in Data View Plus
How to grant calendar permissions for Graph API
On-prem Add-ons
Installation and Activation
Upgrading KWizCom products from older version of SharePoint to newer version of SharePoint
1 Upgrade your KWizCom products on old SharePoint environment
1.1 Verify that all products work correctly
2 Install your KWizCom products on new SharePoint environment
3 Update product license
KWizCom product installation/upgrade tutorial
Web Installer
PowerShell installation
KWizCom Add-ons product activation tutorial
Knowledgebase
WSP files stuck in deploying/retracting status
Question
Answer
Cascading Lookup Migration tool
Solution is still listed as 'deployed to: none' after manually solution deployment
Question
Answer
Set Timer job status Online in Multiserver Farm
Timer job restart in Multiserver farm
Activation
KWizCom product activation tutorial
KWizCom Apps and Tools activation tutorial
KWizCom Add-ons product activation tutorial
Knowledgebase
Using external data sources
Using external data sources
After you have your external data source/s ready, these data sources can be used by the following KWizCom apps:
External Data Lookup column (part of KWizCom Forms)
This enables you to display a Lookup column (drop-down/grid), connected to an external data source, such as Azure SQL for example.
Data View Plus web part
This web part includes various data source types and a set of display controls, enabling the retrieval and display of data according to custom user requirements.
Created at 8/9/2022 9:21 AM by Nimrod Geva
(UTC-05:00) Eastern Time (US and Canada)
Last modified at 8/10/2022 7:55 AM by Nimrod Geva
(UTC-05:00) Eastern Time (US and Canada)
Total Views: 249
Tags
Documentation > Modern Apps > External Data
Article Type:
User-guide
Recent Discussions
There are no items to show in this view.
