search

formtools / core

The Form Tools Core.
https://formtools.org
207 stars 78 forks source link

Connection Form Tools With a second Database #781

Open johnapost1 opened 3 years ago

johnapost1 commented 3 years ago

Hello, I would like your help because I'm not that experienced is there a possibility when i open the published link to have some fields already field up with variables from another database?

Thnx in advance.

ghost commented 3 years ago

Hey There!

At the moment, no there isn't any functionality like this in Form Tools.

However, you can depending on your level of comfort write a custom PHP script to populate this data into your Form Tools database. One pattern I've previously used is to write a Custom PHP script that connects to a Database and populates field values into an array, and then connects to the Form Tools database and then writes the fields back to any Option Lists. This script is then ran via CRON or some other scheduler depending on your environment. This would be a custom process however and outside of what the Form Tools platform does natively.

Hope this helps.