This function is not available the when you are using the Formcloud!

The form-specific data table is used to create a separate table in the database that only contains the data of the selected elements. This can then be accessed by another form or external applications, for example. The data table is used to conveniently perform queries on incoming form data.

The column name can also be changed separately for each form field.

Contents

Configuring a custom data table

You can access the configuration dialogue for data tables via the corresponding button in the form menu.

All elements of the current form version are listed in the right-hand list. The elements can be moved from this list to the left-hand list using the buttons between the lists. Alternatively, an element can also be moved between available and displayed in the data table by double-clicking.

After saving, the elements in the left-hand list are created as columns in the dynamically created database table.

Column name

In the left-hand list displayed in the data table, a column name can be assigned using the pencil icon to the right of the field name. This column name is then defined instead of the element name in the data table.

Database initialization

If you have made changes to the configuration of the data table, the data table is (re)initialised. During initialisation, changes to the configuration are read in again and the dynamically created database table is recreated. In this process, the dynamically created database table is emptied and filled again with the data from the system table.

This also makes it possible to completely recreate the data table for the corresponding form.

Access to data table

One way of accessing a data table is to create a DB query. It is first necessary to establish a connection to the formcycle database, under DB connections.

The database connection parameters can be found under System settings > Database via the admin user. The database type and the JDBC connection URL are relevant here. Instead of the sa user, you should create a user with fewer rights.

You then create a user in the respective database, e.g. a user who is only authorised to perform SELECTs on the database.

Then create a new entry in the client under Data > DB connections.

You can now create a DB query. In the settings on the right, specify the previously created DB connection. If the query is triggered from the client, public access must also be permitted.

The data can then be read via the database statement action or via the JavaScript API function $.xutil.getDataQuery().