Forums

How can the fields included in a table be updated after a form is created & set to update to a table? On a form I've created, I've had to go back, after some data has been collected and populated into the table, and add a couple new fields. However I can't find where to access the table to make sure that the new fields are captured (when the updated form is being submitted the new fields are not captured). Actually I can't even find the raw table data on the webserver. I've poked around the forum to see if I can find the answer, however I'm not that technical so some of the info I found didn't make a lot of sense. Hopefully someone can give some insight into how to fix this problem. Thanks!

Ok... I've at least found the table in the SQL database, but unfortunately I don't know how to add a field there or modify the attributes of an existing field. I'm hoping there's an easier way through the ChronoForms component tools...

Ok... a little more progress... I've added add'l fields to the sql database, but nothing is populating when I submit a new form/record. How can I link the new form field created in ChronoForms with the actual field in the sql database? Also, if I need to change attributes of a field - i.e. add some validation via the wizard where it appears we are needing it - those changes don't seem to be working. Help please. Thanks.

Hi ehart,

You can connect a form to a database table using the DB Connection tab - see the Database tutorial from the link above for more info.

ChronoForms has no tools for changing the databse structure itself (adding fields, etc) except for the ability to create a new table. PHPMyAdmin or some other MySQL tool will be needed to add the new fields (it's pretty simple).

I don't fully understand the attributes question - you can re-edit the form using the Wizard edit icon or you can edit the Form HTML by hand.

Bob

Thanks so much for the reply, Bob.

I'll try & re-state what's going on so it makes more sense. I had to go back and add a field to the form, which I did through the wizard. That part was fine.

Then I figured out where to find the database using phpMyAdmin and I added the field to the database there. But then when I went back into the form, completed it with some test data, the info I entered into the new field didn't populate to the field I created in the database. I used the exact case sensitive field name from the form to create the new field in phpMyAdmin, but it seems like there's a disconnect between the field on the form and the field in the database. Maybe there's something else I need to do to make the form "talk" to the database? Make sense?

Hi ehart,

I thought that it was automatic. Try turning the DB Connection off saving the form then turning it back ona gain and re-saving - that may refresh the field lists.

Bob

Great. That worked. Form populated correctly after saving & re-saving. Thanks for the prompt follow-up & I will be posting nice comments about ChronoForms!
Ed

I followed the same procedure and got my table updated. However, the records that were submitted prior to my modifying the table are not being updated. Is there anyway to retrieve that information? Anyone figure this out?

Thanks,

Nick

Hi Nick,

Sorry, no, if the information isn't saved then it isn't saved. Just possibly you could go back and trawl through your server logs - there might be something recoverable there I've never tried.

Bob

Hmm, sounds a bit above my head. Not a big deal so I'll consider it case closed. Thanks for responding!

Nick