Updating Table for Backing Up Forms Completed When Form is Changed

Hello,

Sorry to be a pain. I was watching Greyhead (Bob)'s youtube video about how to create a table to back up completed forms in case they go astray. It was a brilliant video. If I change some of the fields in my form, is there a smart and easy way to update the table, otherwise I would lose old records or end up with multiple tables to check dependent on when a form was completed?

For others, here is a link to Bob's video - https://www.youtube.com/watch?v=l4Nd-3FIO6Q

Thanks for your help!

Kind Regards,

Beanie.

Hi Beanie,

There's nothing built in to ChronoForms to edit a table, you can do it easily with PHPMyAdmin (usually available from your hosting control panel). After you change either the columns or elements please click the Delete Cache icon in the Forms Manager toolbar to update CF's table records.

Bob

Bob, thank you ever so much as usual. Bless you Sir! So If I understand correctly, all as I do is add the rows in the table, delete cache in chronoforms and edit the table in the same way as on your video (above)?

Hi Beanie,

You *can* edit a table using MijoSQL (or AceSQL) but you have to know - or find the correct MySQL statements to add new columns. If you aren't familiar with them then PHPMyAdmin makes it simpler to get right.

Bob