Create Table doesn't update Data View

I've successfully created forms and tables and the Data view is correct and all is well. I realized I need to add one more field, so I clicked on the form name, the matching table and verified that the new field is in the Create Table and clicked Save. However, the Data View doesn't show the new fields so the info in the new field does not appear in the Record and in export csv. How do I fix that?

Hi Deafbiz,

In CFv4 you can't edit a table so presumably you have created a new one. If so then you need to make sure that your form is connected to the new table.

Bob

That's what I noticed and I spent hours trying to create one such new table. Do you have any instructions for that? Thanks.

Hi deafbiz,

If there is no important saved data then you can delete the old table and create a new one; if there is data then you can add an extra column using PHPMyAdmin or something similar.

Bob

To my surprise, I was able to create new tables for two of my form. I was not able to create new table for the third form, and that's what I was spending hours on. Kept creating new names, etc. Nothing seems to work. I deleted and it made the problem worse, to the point where I had to recreate the form by hand. Maybe this is helpful:

Check table query below:

CREATE TABLE IF NOT EXISTS `#__chronoforms_data_EmergencyFormW` ( `cf_id` INT(11) NOT NULL auto_increment, 

Everything was not null.