CF8 - Save form in DB

How to save form data to a database in ChronoForms v8.

Overview

The issue occurs due to incorrect configuration of the Save Data action settings, specifically the Data Source and Primary Key fields.
Set the Data Source to {data:} and specify the correct Primary Key, such as 'id', in the Save Data action settings. Ensure the form's Debug mode is enabled to verify the data flow if issues persist.

Answered
ChronoForms v8
Hello everyone,
I have a problem when I have to save form data in a database.

This is my load section in form:
CF8 - Save form in DB image 1

in this submit section I have entered this structure:
CF8 - Save form in DB image 2

This is my db:
CF8 - Save form in DB image 3

Email sending works perfectly.
Instead for saving on database I think I'm wrong to set the settings; i insert "read data" to control if the email is already present in the database.
if it is present, a warning message appears that the registration for that email is already present, otherwise "save data".
These are the settings:
CF8 - Save form in DB image 4

what settings should I enter to save the data on the database?
I haven't found a tutorial for saving data in chronoforms v8.

Thanks to everyone who will try to help me
Max_admin Max_admin 08 Sep, 2023
Hi,

you need to enter {data:} in the "Data Source", you may also need to set the "Primary key" behavior, both in the "Save Data" settings
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Thanks Max but I still have problems.
this is the db:
CF8 - Save form in DB image 5

so i have changed the settings:
CF8 - Save form in DB image 6

this is the error:
CF8 - Save form in DB image 7

is it possible to create a tutorial like that of sending mail?
Max_admin Max_admin 08 Sep, 2023
1 Likes
the "Data source" should be:
{data:}

The Primary key should be:
id


it's possible to create a tutorial, but for now it should work for you with the settings here
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
I put the mail module before the read module:
CF8 - Save form in DB image 8

these are settings in "save data":
CF8 - Save form in DB image 9

Now no error appears and the mail was sent but the saving to the db does not occur
Max_admin Max_admin 11 Sep, 2023
are you saving a new record or updating ? do you have the form "Debug" enabled ? what does it show ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
if this form is only for registered user, how can i insert NAME and email directly reading data from table user of db?
Max_admin Max_admin 11 Sep, 2023
use {user:name} and {user:email}
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.