In order to be able to use these settings optimally, advanced technical understanding and knowledge of HTML and CSS are helpful.
The data acquired using a form can be exported for further processing.
In each form, data can generally be exported in CSV and Excel formats, provided that the form has an activated database configuration. CSV and Excel exports have a fixed format that can be partially reconfigured (see below). A demo can be found here. If the configuration options are not sufficient, additional export formats can be provided on request to meet individual requirements.
The configuration settings for data export are located in the Database configuration tab of a form.
Global settings
The following global settings are available:
Export event information: If selected, information about the event (event title, date, registration deadline, etc.) will also be exported. This selection only takes effect if the form is linked to an event.
Export booking information: If this option is selected, an overview of the form data is displayed, such as the total number of forms submitted or the number of places still available for an event.
Export the active registrations only without the cancellations: If this option is selected, only active registrations without cancellations are displayed in the export table.
Always one line per registration (also for groups): If this option is enabled, only one row per group will be exported for group bookings. If it is disabled, a separate row with identical content will be generated for each booking.
System fields
System fields are data fields that are automatically filled in when a form is received or when the status of a booking changes. The following system fields can be shown during export if desired.
Cancelled: Indicates if the booking of a person interested has been canceled by the administrator.
Waitlist notification sent: Indicates if a person interested who has booked an event has received an automatic waitlist notification.
Confirmation mail sent: Indicates if a confirmation email has been sent to the sender of a form.
Dataset has changes: ndicates if a dataset currently has changes that have not yet been published.
Group Size: For group bookings, indicates the size of the booked group.
Ignore fields
Form fields that are selected in Ignore input field, Ignore dependent field or Ignore former field are not exported.
Renaming or merging fields
By default, the column names in the export table correspond to the names of the configured form fields. However, you can also rename them or merge several form fields.
Example: A form field was previously called “User” and, after a change to the form, is now called “Users.” If you change the output name for the former “User” field to “Users,” the values of the former ‘User’ field and the current “Users” field will be merged into a common table column.