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

    • Popular Articles

    • Mobile Forms iOS Install Via the Apple App Store

      Tutorial Video A tutorial video is also available and covers most of this material if you prefer to watch an overview of how to install the app. Accessing the Apple App Store There should be an icon for the Apple App Store on the home screen of your ...

    • Forms Designer Quick Start Guide

      Overview Field2Base Forms Designer is the proprietary software application that allows your existing paper forms to be quickly converted to a smart E-form available to your end users via our mobile and web-based Mobile Forms applications. This ...

    • Portal 11.28.2023 Release Notes

      Overview Our release notes offer brief descriptions of product enhancements and bug fixes. We include links to the current articles for any affected features. Those articles will be updated shortly after the Portal release to include new ...

    • Integration Service Configuration Guide

      How To Configure Integration Services To Allow Read/Write Access on a Network Path All of our Integration Products, including the DIM, DUU, and EDM have respective Windows Services responsible for communicating with our server. Occassionally, ...

    • Data Integration Module (DIM) Migration Guide

      Overview This article provides the information necessary to migrate the Field2Base Data Integration Module (DIM) over from one server to another. Please refer to the DIM Install Guide for the initial installation of the Field2Base DIM. Once that's ...