Tutorial

Show Topics

Getting Started

Differences Between Infowise UltimateForms for Office 365 and On-premise Versions

Vacation Report with One Approval

Expense Report with One Approval

Form Designer - Make a Basic Form

Build it Now - Approval System

Build it Now - Charts

Build it Now - Form Designer

Build it Now - Notification and Escalation System

Build it Now - Process Diagram with Workflow

Build it Now - Reservation System

Build it Now - Timesheets

Creating a site from a Business Solution Template

Revealing Associated List Information with the Modern Form Designer

Actions

Smart Actions in Infowise UltimateForms for SharePoint

AND / OR Conditions

Create List Item Action

Copy List Item Action

Send Email Action

Create a List/Library Action

Create a Site Action

Manage Permissions Action

Check if field value changed

Create user facing workflow

Create a History Section

Using Actions in Azure Logic Apps

Manage Exchange

Calculate Summary - Make a Tracking Report

Alerts

Working with Dates

Build a dynamic Today field

Today field date comparisons

Triggering an email alert at deadline

Time and Date Functions (1/2)

Date comparisons with Infowise Indicator

Time and Date Functions (2/2)

Form Designer

Creating a New Form

The Form Designer Toolbar

Moving, Adding and Removing Fields

Form Builder Controls

Form Builder - Basic Styling

Form Builder - Advanced Styling and CSS

Form Builder - Conditional Styling

Rules to Control Form Element Behavior – Form State

Tabs and Tab Permissions

General Settings

Create a Tabbed Interface

Tab / Field Permissions (1/3)

Tab / Field Permissions (2/3)

Tab / Field Permissions (3/3)

Creating a Dynamic Header (1/2)

Multiple Columns

Creating a Dynamic Header (2/2)

Customize Form Width to 100 Percent

Fragments - Inserting Custom Diagrams in Forms

Enabling the Display All Columns Tab

Using Collapsible Groups Instead of Tabs

Use SharePoint Group Permissions

Manual Form Layout

Views and View Customization

Color Choice as a status indicator

Load a custom icon library

Use indicator to track spending

Creating View Permissions

Validation

Validate field length

Validate a signature field

Validate numeric / date values

Validate compound conditions

Validate Empty Columns

Advanced Column Permissions

Field Permissions Basics

Hide fields to simplify the Add form

Field Permissions Example

Signature Field

Adding a Signature Approval for List Changes

Item IDs

Create Item IDs using a seed value

Associated Items

Creating an Associated Item field

Child List Content Types

Associated Items Example - Products

Changing Parent/Child Relationships

Passing Data Between Lists

Simple First Time Associated Items Step by Step

Print Formatting

Calendar Print Template

Advanced print formatting

Adding Parameters to Print Template

Basic print formatting

Add QR Code to Print Template

Charts, Filters and Other Web Parts

Creating a Rollup (O365)

Rollups (On Premise)

Charting in Office 365

Range Column Chart

Create Charts with a Dynamic Filter

Event Calendar

Basic Event Calendar Office 365

Events Calendar Plus Filter by Category

Basic Events Calendar On-Premise

Show Additional Columns on Hover

Email Approvals

Setup Sharepoint List

Create Email Alert

Setup Email Import

Smart Import

Setup the Database (1/4)

Build the SharePoint list for import (2/4)

Setup the Smart Import (3/4)

Test the import and synchronization (4/4)

Import from Excel Workbook

Connected Fields

Creating Master-Detail Cascading Lookup Column

Filter By View in Connected Fields

Creating a Master- Detail Lookup Column with On-Premise Infowise

List Search

List Search Setup

List Search Filter by View

Voting Fields

Creating a Voting Column

Setting an Owner Column

Test the import and synchronization (4/4)

Print

In the previous section we setup our Smart Import to synchronize with Microsoft Azure MSSQL. We should now be importing data every 15 minutes from Microsoft Azure or your preferred database. In this section I will cover how to ensure that you are receiving data.

Instructions

You will find the Import History in the Smart Import Profile that you created.

Click on the Import History and you will see the records have been imported successfully.

You can also click on the Load More button if you want to see more records:

Some other notes:

Microsoft Azure requires you to enter IP address into the firewall settings. These can be obtained by contacting support@infowisesolutions.com

If you need polling that’s faster than every 15 minutes, please contact sales@infowisesolutions.com and they can provide polling up to every 2 minutes.

For more information on setting up and connecting to Azure you may find the following liks helpful:

Microsoft Azure https://azure.microsoft.com/

Azure Database getting Started

https://azure.microsoft.com/en-us/documentation/articles/sql-database-get-started/

Azure Database Connect through Sql Server Management Studio

http://docs.telerik.com/data-access/deprecated/developers-guide/database-specifics/microsoft-sql-azure/getting-started-root-quickstart-azure-connect-through-ssms

For More Information on Smart Import Pro:

http://www.infowisesolutions.com/documentation/?Product=SmartImportPro

Summary

Click here to go to Part 3 of 4

Last modified: 5/15/2019 8:33 PM

Loading...

Add your comment

Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to support@infowisesolutions.com to open a support ticket.