Connections

Connections are used to define a connection string to connect to an external database. Once a connection is defined, any number of data source definitions (which define what data is loaded) can use it to access the configured database.

The point of defining the connection string separately from the rest of the data source definition is to be able to update it without having to change it individually in every data source definition which uses the same connection.

Updating a connection automatically causes that any data source definitions using it (the view with Connection usage button) will use the new settings.

If necessary, in the configuration of a form field it is possible to select a connection as its data source (without actually using a data source definition). This will allow you to query the database directly via an SQL query.