Set Up SQL Datasources and Form Data Files - Session Length: 30 min

Set Up SQL Datasources and Form Data Files - Session Length: 30 min

Overview

A SQL Datasource Region allows you to pull data from external Form Data Files (Excel or Access files) for  drop-down regions in your Forms. This training session is intended for Mobile Forms Administrators, Forms Publishers, and/or Form Data Uploaders who will be creating and maintaining the Form Data Files for your Company.

Please contact your Account Manager or sales@field2base.com to request a training session.

Objectives

After completing this training, you should be able to:
  1. Create and edit a Form Data File
  2. Create a SQL Datasource Region
    1. Define the Database for the Region
    2. Create Basic SQL Queries
    3. Manage Queries
  1. Test SQL a Datasource Region in Preview Mode
  2. Create a SQL Datasource Region using Parameters from another Region
    1. Defining Parameters
    2. Referencing Parameters in a Query

Resources

  1. SQL Datasource Regions
  2. Form Data Files