Buy Now
Sign in

CF5 - show date last modified from database in form

thewelt , December 15 2017
t
thewelt

Hi,

I already have a form in CF5 that shows te last submitted data by a registred user of my website.
Now I would like to add the date on wich the last data (and time) was submitted.

For the name, e-mail and phonenumber I use the following "custom code", but this does not work for the field "modified" in my DB:

<?php
$user =& JFactory::getUser();
$form->data['naam'] = $user->name;
?>

Can you help me please?

Cheers,

Bart Weltens
Belgium

GreyHead

Hi Bart,

I am not clear what you are trying to do here. Is this the 'last modified' date from a table of saved form data?

Bob

ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much

t
thewelt

Hi Bob,

I try to explane:
A registred user can give via the form a status update (such as workstatus, available on ..., looking for work, not looking for work, etc). This data is saved in a DB.
On the next visit this user can see what he/she gave in the last status update and alter the data.

Now I want to ad a field in the form wich shows the date (and time) of the last time he/she entered the update.

In the databasetable the date/time of the last update is saved in the field "modified".

Hope you know what I mean.

Tnx,

Bart Weltens

GreyHead

Hi Bart,

A DB Read action should be able to load that column for you - presumably you already have one to load the other data from the record?

Bob

ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much

t
thewelt

Hi Bob,

I found the mistake ... I spelled the fieldname in de DB read action wrong.
But now I have another question related to the same topic.

Since I'm showing a date/time it shows "2017-12-15 08:10:54".
I already altered the "mask" in the text field tot dd/mm/YYYY but then I get "20/01/2012"

Can I fix that in one way or the other?

Cheers Bart Weltens