Help with writing to existing database

Joomla 1.7
Chronoforms V4

Hi,

I am moving an existing site over to Joomla. I have a table in the database that I would like to add data to when a form is submitted.

I understand how to use Chronoforms to create and write to a new table but I'm unsure how I 'connect' Chronforms to an existing table.

I have added an event 'DB Save', I have selected my table in the drop down, but I don't know how to tell Chronoforms which fields to save and which ones to ignore.

Can someone point me in the right direction here?

Thanks,

Gillian

Update: CF is very clever and it is writing to my table without any problems so long as I give the give the form fields the same names as the fields in the table! Should have checked that out before posting! I just need to figure out how to get the created date into my table now. My field is called 'date_added' and it's just YYYY-MM-DD without the time. Can anyone help with this part? Would I be best just to change the field name to 'cf_created'? Thanks.

Hi Gillian,

The simplest way is to make sure that the names of your form inputs match the corresponding column names in the table.

If this can't be done directly then you can use PHP in a Custom Code action to manipulate the form data and put it in the correct entries in the $from->data array.

Bob

Ah thanks Bob, I understand now.

Have to say CF is just fantastic and I love V4, it's so easy to use.

Technical support is first class too.

Gillian

Hi Gillian,

Thank you.

Bob