auto time stamp when form is submitted to data-table

In Chronoforms 7 the created data/time stamp was automatic in myPHP.

In creating the data-table for Chronoforms 8, I don't know how to get the date/time stamp to automatically list when a form is submitted.  Do I have to write it in the form and data-table or just the data-table?  I'm lost and have tried several different methods, none of which works.  I'm not a programmer and know enough to be dangerous but I am trying to learn on my own.

Anybody able to help?

Thanks very much,

Donna

Hi Max,

Thank you so much for the speedy reply.  However, I cannot get it working and I believe after also researching is that my PHP is too old and before I can update that I need to get our hosting company to update the MariaDB updated as it is too old and won't allow me to update my version of PHP.

I added the created_at field to the data-table structure as a timestamp and defined it as 0000-00-00 00:00;00

I get the following error: 

Incorrect datetime value: '{"option":"com_chronoforms8","action":"view","chronoform":"contact","date":"12-09-2025","first_nm":"FirstName","last_nm":"Las...' for column `pgrnyn5_joomla4`.`slh81_chronoforms8_data_contact`.`created_at` at row 1

I have the modified fields as:

created_at={data:}

date={data:date}

first_nm={data:first_nm}

last_nm={data:last_nm}

email_address={data:email_address}

phone={data:phone}

subject={data:subject}

comment={data:comment}

Is the problem with PHP version 8.13 and the old version of MariaDB???

Thank you again,

Donna

Hi Donna

The created_at value should be {date:} but not {data:}

Please pay attention to the character in bold

Max,

I am so sorry, I should have checked more closely.  I'll go back and try again.

Many thanks,

Donna

OMG, worked like a charm.

Thank you so much.  I so appreciate your support!

Donna 😊

Hi Donna

Great, no problem 😊