Data tables - FORMCYCLE Wiki

author	version	line-number	content
1	{{content/}}
2
3	{{warning}}
4	This function is not available the when you are using the {{formcloud/}}!
5	{{/warning}}
6
7	For each form, you can setup a custom data table to make it easier to query the value of different form input elements. You can choose which input fields should be available, and you can change the name used to access these fields.
8
9	== Configuring a custom data table ==
10
11	{{figure image="form_data_table_en.png" width="300"}}
12	User interface for modifying the custom data table
13	{{/figure}}
14
15	{{figure image="form_data_table_edit_col_en.png" width="300"}}
16	Configuration of the column name of a data table
17	{{/figure}}
18
19	In order to open the configuration dialog for data tables click the corresponding button {{ficon name="layout-table"/}} in the [[form menu>>doc:Formcycle.UserInterface.MyForms.WebHome\|\|anchor="form_menu"]].
20
21	The list on the right-hand side lists all form elements available for the current form version. From this list you can add input fields to the data table on the left-hand side or remove them from the data table by using the buttons in the middle.
22
23	The elements that have been added to the data table will be created as columns of the dynamicallly created database table.
24
25	=== Column name ===
26
27	You can change the name of the column that will be created in the database table. To modify the name, click on the edit icon to the right of the form element name.
28
29	=== Database initialization ===
30
31	If you made changes to the data table configuration, the data table will be (re-)initialized when you click the save button. The database initialization will read the current configuration again and recreate the dynamically created database table. The database table will be empties and pre-filled with the current data again.
32
33	The button //reinitialize// is only available once you have saved a custom data table at least once.

This function is not available the when you are using the {{formcloud/}}!

For each form, you can setup a custom data table to make it easier to query the value of different form input elements. You can choose which input fields should be available, and you can change the name used to access these fields.

8

9

== Configuring a custom data table ==

10

11

12

User interface for modifying the custom data table

Configuration of the column name of a data table

17

18

19

In order to open the configuration dialog for data tables click the corresponding button {{ficon name="layout-table"/}} in the [[form menu>>doc:Formcycle.UserInterface.MyForms.WebHome||anchor="form_menu"]].

20

21

The list on the right-hand side lists all form elements available for the current form version. From this list you can add input fields to the data table on the left-hand side or remove them from the data table by using the buttons in the middle.

22

23

The elements that have been added to the data table will be created as columns of the dynamicallly created database table.

=== Column name ===

You can change the name of the column that will be created in the database table. To modify the name, click on the edit icon to the right of the form element name.

28

29

=== Database initialization ===

30

31

If you made changes to the data table configuration, the data table will be (re-)initialized when you click the save button. The database initialization will read the current configuration again and recreate the dynamically created database table. The database table will be empties and pre-filled with the current data again.

32

33

The button //reinitialize// is only available once you have saved a custom data table at least once.

Wiki source code of Datentabellen

Navigation