Forums

Hi All,

Here is my problem and solutions from Greyhead. Thankyou for your help.

First PM:
Hi Greyhead. I am new to Chrono forms Please help me. I need to get the form data to be entered into the database after the form has been been submitted.
I read through all posts on the topic, and all my settings are where they should be. PLease help I need to get this ready asap.

Reply by GreyHead
Hi chaps,

Please read the DB Tutorial from the Tutorials link above.

Second PM
First my plead for help, after hours of reading through the forums and tutorials (5 Saving data to the database.pdf), but still no luck.
I have recreated the forms and tables numerous times, up to the point where I uninstall and reinstalled the Chronoforms component.Please help when you do get some time. Goodnight. Thanks in advance.

Reply by GreyHead
Hi chaps,

Your form is saving to the database OK. I just added a fifth record successfully.

THe problem is that you haven't included any of your form fields in the database table.

PS I installed EasySQL, a free Joomla extension, to let me see the database tables from the admin area.

Third PM
Hi Greyhead,

Many Thanks, for your help.

Jsut for future reference:
THe problem is that you haven't included any of your form fields in the database table. (HOW DO I DO THIS)

PS I installed EasySQL, a free Joomla extension, to let me see the database tables from the admin area. (HOW DO I SEE THE INFORMATION SENT BY THE USER IN THE DATABASE)

Sorry I'm new to Chrono forms. Thanks again for your speedy replys.

Reply by GreyHead
Hi chaps,

Please post in the forum.

Bob

SOMEONE PLEASE HELP!

Hi Chaps,

You need to delete the existing table (or set up a new one with a different name). To create a table select the form in the Forms Manager and click the Create Table icon.

*** Then choose the fields that you want to have included. Selected fields show a green bar with a red cross icon. By default NO FIELDS are selected.***

Bob

Solved, once again thankyou for your help.

I'm not seeing database info. Why did you ask him to delete the current table (or setup a new one with a new name)? If you don't see the data, do you need to start over from scratch? Please tell me that's not the case as that's a bit of work.

Since I didn't see the data, I started over working instead with the basicDemo form. I connected a table. Added one field, email, but I don't see anything depositing into there either.

The e-mails seem to work just fine though. All the data is coming through correctly. There's just nothing appearing in the DB.

Thoughts?

Hi jodybossert,

I asked chaps to delete and recreate the table because it had been created without any of the columns needed to stor the form data (it had just the standard ChronoForms columns like cf_id, cf_user_id, uid, recordtime, ipaddress).

The column names in your table must match the input names in your form. Otherewise no data will be saved. Please check the Database Tutorial from the Tutorials link above.

Bob