Forums

How to save form content to a database table ?

JoCo 31 Jul, 2020
I'm acquainted with chronoforms7.
My question is how to save the content of the form to a mysql database table?
regards joco
Max_admin 01 Aug, 2020
Use the "Save data" action, select your database table and set the "data source"

you should have the latest update RC3
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
JoCo 04 Aug, 2020
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 05 Aug, 2020
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
JoCo 05 Aug, 2020
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?
Max_admin 06 Aug, 2020
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!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
JoCo 06 Aug, 2020
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.
Max_admin 08 Aug, 2020
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!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
mendlerdesign 17 Jun, 2021
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 17 Jun, 2021
Hi mendlerdesign,

If you have an Advanced form you can switch to the Actions Editor then add a Database > Save Data action.

Bob
mendlerdesign 17 Jun, 2021
Bob! Thanks for your answer! I found it!
Thanks!
Zoltan
This topic is locked and no more replies can be posted.