Hide last authors
gru 1.1 1 {{content/}}
2
3 {{warning}}
gru 12.3 4 This function is not available the when you are using the {{formcloud/}}!
gru 1.1 5 {{/warning}}
6
gru 12.3 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.
gru 1.1 8
gru 12.3 9 == Configuring a custom data table ==
gru 1.1 10
gru 12.3 11 {{figure image="form_data_table_en.png" width="300"}}
12 User interface for modifying the custom data table
gru 1.1 13 {{/figure}}
14
gru 12.3 15 {{figure image="form_data_table_edit_col_en.png" width="300"}}
16 Configuration of the column name of a data table
nlo 10.2 17 {{/figure}}
18
gru 12.3 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"]].
nlo 10.2 20
gru 12.3 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.
gru 1.1 22
gru 12.3 23 The elements that have been added to the data table will be created as columns of the dynamicallly created database table.
gru 1.1 24
gru 12.3 25 === Column name ===
gru 1.1 26
gru 12.3 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.
gru 1.1 28
gru 12.3 29 === Database initialization ===
gru 1.1 30
gru 12.3 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.
gru 1.1 32
gru 12.3 33 The button //reinitialize// is only available once you have saved a custom data table at least once.
Copyright 2000-2024