Forums

Does the latest version of Chronoforms 7 have the ability to create a DB table like the old versions? Yes I know I can manually go into phpmyadmin and create the table myself but was wondering if it can be create like the old versions of Chronoforms. Currently the data in the log file is all in a single data field. I want to be able to access that data in fields like the old way.

Any help is much appreciated.

You should be able to do this in the form settings. In Behaviors > Admin, You will need Installer and Connected Tables from the drop-down.

Thank you very much

For some reason I was able to have the table created and connect but wasn't able to add the fields. So I removed installer and then entered the table structured manually from within myphpadmin. I then went to forms >> pages >> actions and added the save data from database drop-down menu . Selected the correct database then >> action >> insert new record.

The form works correctly and I can see data in view log but when viewing from the connected database no data is saved. Any ideas?

Any idea as to why the data is not saving to the connected database?

Did you add all the fields before saving with the installer loaded?

Since you added the columns using phpMyAdmin, you now need to make sure that all your fields/columns are listed in your [Connected Tables[/b]. If not, add them in. Make sure that the field names in your form matches the field names in your table. You don't need to cheat a form field for your id. You just need to list the fields you have form fields for in your form.

example:
https://pasteboard.co/fUHmOSSBYFFw.png

Also, in the Save Date Action, is there anything set for the Data Sets?

All of the fields and columns are now listed in the Connected Tables just like the example except matching the fields in my table.

Also, in the Save Data Action, under Data Sets Whole Form Data is listed.

I have run the test again and still not saving anything to the database. The data is saved under view log but is empty in the connected table.

Which page did you put the action on? The "end_page"?

I had the action on the start page but moved it to the end page and now everything is working. Thank you very much for all your time.

That's good. I'm happy to help. Just remember that the action needs to run AFTER the form is submitted. This is the reason why no field is really added to the "end_page".