Buy Now
Sign in

How to save form content to a database table ?

JoCo , July 31 2020, 13:28
J
JoCo 114
July 31 2020, 13:28 #393495
I'm acquainted with chronoforms7.
My question is how to save the content of the form to a mysql database table?
regards joco
admin 33
August 01 2020, 03:22 #393500
Use the "Save data" action, select your database table and set the "data source"
you should have the latest update RC3
J
JoCo 114
August 04 2020, 16:09 #393531
Thx Max for your answer but till now i do not succeed with any saving to the db-table.
I use a table that i already used in chronoform6. In the debugging info i don't see anything that points to that table.
I put the save data action at the top of the form and the end of that page i placed the submit button.
Do you have any idea what i can do?
GreyHead 65
August 05 2020, 09:07 #393537
Hi JoCo,
The Save Data action needs to run after the form submits so it should not be on the same page as the submit button.
Bob
If you'd like to buy me a coffee or two, thank you very much
J
JoCo 114
August 05 2020, 10:58 #393541
Thx Bob, I placed the submit button on the end_page and in the action part i placed the Save data action. In the action part of that page i do also some php-calculations. That works fine. But now appears the next challenge, how do i make that end_page visable in the admin and frontend view?
I also notice that the formload into the editor takes longer and longer. Is there something that ik can do about that?
admin 33
August 06 2020, 00:31 #393562
 Answer
Hi JoCo,
For form load times, try to enable the "Safe Mode" setting in the ChronoForms7 settings area!
How many pages do you have in your form ? the form will move from page to the next according to the pages order in the admin area!
J
JoCo 114
August 06 2020, 15:37 #393578
Thanks to everyone who gave me the answers.
@Bob, i placed the save-data action on the end page and the button on the start page and then it works. So the button must always be in front of the Save Data action. You deserve the cup of coffee.
@admin, yes the safe mode is the solution. What is the different between safe mode enabled and disabled. Will the option of creating tables added yet?
What i also noticed that by saving the form data in the table, i created in cf6, the creation data not get adjusted.
@Max, I used the new cf7. I had built a form in cf6 and rebuild that form in cf7.
The great advantage compared to cf6 is that i now for populating 16 dropdowns with the same content i used only one procedure while in cf6 i used 16 procedures.
Till now i used it with pleasure.
admin 33
August 08 2020, 15:30 #393590
 Answer
Hi JoCo,
In v7 you can easily enable the "DB Log" and that will log the form data to the log table, that's enough to keep the data unless you need a separate table, in that case you will need to choose a database table in the "Save data", the next update has a "Connected tables" behavior which you can use to view database tables through the form parameters icon in the forms manager!
M
mendlerdesign 8
June 17 2021, 18:06 #396708
Hi!
in v7 i have a problem.
I not see the "connected tables". - Okay, we have a DB Log, but if I have a contact form or advanced form, how can I tell to form to save the submitted datas to an another table?
Thanks!

Z

ps: I know we have "chronoconnectivity", but when I change it (form mode), all my fields in a v7 ChronoForm view lost... :/
GreyHead 65
June 17 2021, 21:44 #396712
Hi mendlerdesign,
If you have an Advanced form you can switch to the Actions Editor then add a Database > Save Data action.
Bob
If you'd like to buy me a coffee or two, thank you very much
M
mendlerdesign 8
June 17 2021, 22:38 #396714
Bob! Thanks for your answer! I found it!
Thanks!
Zoltan