Server connect - dynamic connections

Does anyone know of a way that variables being able to be used for the connection parameters in Server Connect?

I have a database that contains the connection details for customers’ own databases where their data is kept (with matching DB schema). What I would like to do is:

  1. Make a connection to my DB
  2. Get connection details via a query
  3. Use the collected details to make a new connection (which can then be queried etc.)

I can perform 1&2 but am stuck on 3.
I have tried setting the details as a value and them manually editing the connection script (outside of Wappler) with {{valuename}} in place of the host address, username, password and DB name. The connection settings screen won’t allow values to be saved as the validation fails (hence editing outside).

Any help would be gratefully received.

Community Page
Last updated: