Data Records of a New Form

Q

How many data records are inserted in Form Tools database, when a new form is added?

✍: FYIcenter.com

A

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:

select * from ft_forms where form_id = 6;

2. The following child data records are also stored to support the new form:

-- ft_form_fields defines what fields are used in the form
select * from ft_form_fields where form_id = 6;

-- ft_views defines what views are used for the form
select * from ft_views where form_id = 6;

3. For each form field, the following child data records are stored:

-- ft_field_settings defines settings for each field
select * from ft_field_settings where field_id in (
   select field_id from ft_form_fields where form_id = 6
);

-- ft_field_validation defines validations for each field
select * from ft_field_validation where field_id in (
   select field_id from ft_form_fields where form_id = 6
);

4. For each form view, the following child data records are stored:

-- ft_view_columns defines columns for the view result list
select * from ft_view_columns where view_id in (
   select view_id from ft_views where form_id = 6
);

-- ft_view_fields defines fields for the view detail
select * from ft_view_fields where view_id in (
   select view_id from ft_views where form_id = 6
);

-- ft_view_tabs defines tabs for the view detail
select * from ft_view_tabs where view_id in (
   select view_id from ft_views where form_id = 6
);

4. The following child data records are used to control access permissions:

-- ft_client_forms defines form access per client
select * from ft_client_forms where form_id = 6;

-- ft_client_views defines view access per client
select * from ft_client_views where view_id in (
   select view_id from ft_views where form_id = 6
);

5. Actual form data records are stored in a standalone table for the new form:

select * from ft_form_6;

 

Load CSV Data as New Form

Understanding Form Tools Database

Understanding Form Tools Database

⇑⇑ Form Tools - Frequently Asked Questions

2019-11-08, 128👍, 0💬