Understanding Form Tools Database

Q

Where to find answers to frequently asked questions on understanding Form Tools Database design? I want to learn how to manage forms in the database.

✍: FYIcenter.com

A

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team on understanding Form Tools Database design:

Data Records of a New Form

Load CSV Data as New Form

Add Form to Database Directly

Summary:

Form Tools saves a new form into 4 main data entities: form properties, form fields, form views, and form submissions.
You can load form data from a CSV file with field names updated to the database directly with a PHP script.
You can also create a new form in database with a PHP script. But it's not recommended.

Â

â‡’ Data Records of a New Form

â‡ Add New Export Group and Type

â‡‘â‡‘ Form Tools - Frequently Asked Questions

2019-11-08, ∼2215🔥, 0💬

Add New Export Group and Type
How to Add New Export Group and Type? If you want to control how form submissions are exported to print or download for reporting purpose, you can add a new export group and a new export type as shown in this tutorial. 1. Click "Module" in the menu and select "Export Manager". You should see a list ... 2019-11-08, ∼2327🔥, 0💬

Load CSV Data as New Form
How to load data file in CSV format with given field names in the file? I don't want to create a new form and define its fields to match the file manually. If you want to load a data file to Form Tools as a new form, you can create an empty form with generic fields first. Then you can update those f... 2019-11-08, ∼2234🔥, 0💬

Understanding Form Tools Database
Where to find answers to frequently asked questions on understanding Form Tools Database design? I want to learn how to manage forms in the database. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team on understanding Form Tools Database design: Data Record... 2019-11-08, ∼2216🔥, 0💬

Using Export Manager Module
Where to find answers to frequently asked questions on how to create your own exprot groups and export types? I want to generate nice looking reports. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team on how to create your own exprot groups and export type... 2019-11-21, ∼2200🔥, 0💬

Data Records of a New Form
How many data records are inserted in Form Tools database, when a new form is added? When a new form is added, you should see the following data records in Form Tools database: 1. The primary data record for a new form is stored in the "ft_forms" table. You can get the data base back by the form_id:... 2019-11-08, ∼2148🔥, 0💬

Use Smarty to Control Value Display
How to Use Smarty to Control Value Display? If you want to use a single field to a complex data element, like a comma separated list, you can use smarty template to control how the value will be processed before sending it to display or download. 1. Create a new field type called "CSL". 2. Click "Di... 2019-11-21, ∼2004🔥, 0💬

Clone Phone Number Field Type
How to Clone Phone Number Field Type? If you want to clone the Phone Number field type, you can follow this tutorial. 1. Login as Admin to Form Tools and go to "Modules > Custom Fields". You should see a list of existing field types. 2. Click "Add Field Type" in the "Special Fields" group. Yo... 2019-11-21, ∼1949🔥, 0💬

Add Form to Database Directly
How to add a new form to Form Tools database directly? Adding a new form to Form Tools database directly is not recommended. But if you want to automate the form creation process, you can still do it by follow this tutorial. 1. You should create a Form Tools test database called "ft" to try this pro... 2019-11-08, ∼1935🔥, 0💬

What is Export Manager Module
What is Export Manager Module? Export Manager module is a very useful module that lets you control the various ways in which your form submissions can be viewed and downloaded. Export Manager module provides 6 built-in export types: HTML single table - All submissions are exported as a single HTML t... 2019-11-21, ∼1856🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.