CF8 - Possibility to use global variables as external database credentials

How to use global variables for external database credentials in ChronoForms 8.

Overview

The issue was that database credentials had to be manually updated in every query when moving forms between development and production sites, as CF8 initially lacked a way to centralize these settings.
Update to CF8 v8.0.30 or later, then define your global variables in the CF8 global settings. In the External Database behavior, you can now reference these credentials using the {globals:var-name} placeholder.

Answered
tu tuomaskiviluoto 01 Dec, 2024

Hi!

In CF7 there's an option in form settings to create a connection to the external database. Since I have some complicated forms including multiple SQL queries it's been helpful to keep credentials in only one place.

Could there be a possibility to add support for global variables in CF8 external db settings? Currently crendentials has to be changed in every queries while moving forms from develompent site to production site.

- Tuomas

Max_admin Max_admin 01 Dec, 2024
Answer
1 Likes

Hi Tuomas

I have updated the latest v8.0.30 installer to support this, please download it again now if you have already applied it earlier then add your global variables in the Chronoforms8 global settings, then in the External Database behavior you may use {globals:var-name}

Let me know how it works for you!

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.