Database connection

Enabling database connection

To connect an external database,

1. Go to Settings > Integration > Third-party services.
   
2. Scroll down to Database connection and click the toggle to open the connection dialog.
3. Fill in the connection details:
   • Database type — select MySQL or SQLite from the dropdown.
   • Host — enter the hostname or IP address of the database server.
   • Port — enter the port number used by the database server.
   • Database name — enter the name of the database where form results will be stored.
   • User — enter the database user account name.
   • Password — enter the password for the database user account.
   • Use SSL — check this option to encrypt the connection to the database server.
   
4. Click Test connection to verify that DocSpace can reach the database with the provided credentials.
5. Click the Enable button to save the settings and activate the integration.

Exporting form results to the database

Once the database connection is enabled, you can configure individual Form Filling Rooms to export their results to it automatically.

To set this up when creating a new Form Filling Room,

1. Go to the Rooms section on the left.
2. Use the New room button in the upper left corner or the Plus icon above the list of rooms.
3. Select Form Filling Room.
4. Enter the room name and configure any other options as needed.
5. Turn on the Export results to the database switcher.
   A table will be created in the connected database for each standard form in the room immediately after a copy is filled out or on a schedule.
6. Click Create.

For more details about Form Filling Rooms, read this article.