Form Data Files

Form Data Files


When you have a Datasource (drop-down) Region on your form, the data can be populated in several ways. One of the most common ways is to use the Form Data File functionality native to the Field2Base application.
Form Data Files are the MS Excel™ or MS Access™ CSV files linked to your digital forms. The data in these files are used to populate the Datasource regions on your forms. For more information on creating SQL Datasource regions that can pull data from these files into your forms, see the SQL Datasource Regions article. You can change the data in these files and the new data will be available in the Datasource regions on your forms.
The Form Data Files page in the Portal allows you to manage the Form Data Files for your company's digital Forms. You can view, upload new, update, or delete Form Data Files from this page.
Note: Saved Form Drafts will not load the new data from an updated Data File. Form drafts are meant to be a "snapshot in time" with data remaining constant from when the Form was initially started. Data from Data Files is maintained from the time when the form was started by design so that the original data cannot be changed or possibly deleted if the Data File is updated after a Form has been filled out initially.

Tutorial Video

A tutorial video is also available and covers most of this material if you prefer to watch how to manage your Form Data Files.

Viewing Your Form Data Files

To view the Form Data Files for your company, log in to the Portal and go to Admin > Form Data Files.  From the Form Data Files page, you can view all of the Form Data Files that have been uploaded to your company. You can click on any of the hyperlinked (white) column headings to sort your data files or use the Show/Hide Filters button to filter your Data Files by File Name, Associated Folder, Date and/or Submitted By.

File Name:  The name of the Form Data File.
Associated Folder: The name of the folder that the Form Data File is associated with. Assigning a Form Data File to a Folder is optional and means that the Form Data File will only be available to Forms in that specified Folder and will only be downloaded to devices for Users with access to that Folder. If you need Forms across different Folders to have access to a Data File, you should not associate the Data File with a Folder. 
Last Modified Date:  The Date/Time the Form Data File was last uploaded to the Portal.
Version:  Each time a Form Data File is uploaded, it increments the version number by 1. For example, if a Form Data File was published 21 times, the version number would be 21.
Submitted By:  The last Field2Base User to upload the Form Data File.

Select an Action Dropdown

Additional actions are available when selecting from the Select an Action dropdown.

Change Folder:  Move the Form Data File to a new Folder.
Download:  You can download a Form Data File to your PC  in order to review or update it.
Note: We recommend always downloading any Form Data File that you need to update from this page to ensure that you are working with the current version.
Traffic:  This shows every device in the field that has downloaded the most recent version of the Form Data File. This feature is useful for ensuring that all of your users are using the most current version.

Uploading a Form Data File

If you have updated an existing Form Data File or you have created a new Form Data File, you will need to upload the most current version to the Portal so that your forms can pull the latest data.
Note: When updating and re-uploading an existing Form Data File, the File Name needs to be an exact match in order to overwrite the existing Data File and to update the data available in the Form(s).
1. Log in to the Portal and go to Admin > Form Data Files.
2. Click on the Upload File button. 

3. If you want to limit access of the Form Data File to Users and Forms associated with a specific folder, select a Folder. Otherwise, use the default of Company Wide so that all Forms can access the Data File.

4. Click on Choose File and select the file you would like to upload from your local files.
5. Click on Upload to upload your new Data File or on Close to cancel.

Deleting a Form Data File

Form Data Files can be deleted from the Portal if they are no longer being used in any of your Forms. Deleting a Data File means the data will no longer be accessible to any of your Forms and any Datasource (drop-downs) Regions in your Forms using this data will no longer work.
1. Click on the checkbox next to the form(s) to be deleted.
2. Click on the Delete button. 

3. A Dialog box will pop up asking you to confirm that you want to delete. Click Yes to finish deleting the file. 

    • Related Articles

    • Portal Quick Start Guide

      Overview The Field2Base Portal allows your company's Admin(s) to manage the Field2Base application for your Company and allows your Users to access the features available to them as set up by your Admin. This is the heart of the Field2Base ...
    • Managing Forms

      Overview This article describes the options for managing your forms library. The Forms page in the Portal allows you to manage your Company's Forms. To access your Forms navigate to Admin > Form Templates. Tutorial Video A tutorial video is also ...
    • Sent Forms

      Overview The Sent Forms page of the Portal allows a User (with Mobile Forms Administrator or Online Docs User Role) to view and take several actions on Forms (in Folders they have access to) submitted for a Company.  Navigate to Sent Forms on the ...
    • Shared Forms

      Overview The Shared Forms feature allows you to share any of your published Forms through links (URLs) that can be posted on your website or e-mailed to individuals. This link opens a web-based version of your Form which can be filled out by external ...
    • How to Replace a Live Version of a Form with a Test Version

      Overview When making updates to an existing Form, we recommend cloning your live Form to create a new "test" version of the Form so that you can make changes and test your changes without affecting the Users who are using the live Form. See the ...