Is there anybody out there? - So many questions PLEASE HELP!

map form fields to an external database in ChronoForms.

Overview

The form submission data was not saving because the field names did not match the database column names.
Ensure the names of your CF form fields exactly match the corresponding column names in your external database table.

Answered
ChronoForms v7
Sw SwingeyP 18 Jan, 2021
I have a form of mainly text fields and a calendar entry.

I want to spit this data into an 'EXTERNAL' database.

I have a database 'Data' with some tables 'SiteDetails'

I have managed to get a database connection working and can see the tables in 'Database Connection 1'

I have put the 'Save Data' action in the actions area for the field.
Now comes my questions:

How does the 'Save Data' know what fields map to what database field?

If I run the form and sbmit it all seems to go OK but the table fields in the database aren't being populated. They're just blank.


Can someone PLEASE help me get this working?
Gr GreyHead 18 Jan, 2021
Answer
Hi SwingeyP,

Basically the names of the CF data entries need to be the same as the corresponding columns in the database table.

Bob
Sw SwingeyP 18 Jan, 2021
Thanks Bob. I shold have seen that one - doh!
This topic is locked and no more replies can be posted.