Populate form from DB

Hi all,
​
I have created a form where users enters his data and it correctly saves it to the DB.
Now I'm trying to do an equivalent one to first read the DB, find the record and populate the form.
​
The systems seems to read well the DB but I don't know how to populate the form.
First action of Setup is Read Data with:
Condition: email:{user:email} (is seems to find the record)
Then I have the following data settings

​
In the load section I have also this Display Form action:

​
I don't know what I am missing.
​
Thanks,
Anna.

You are missing putting {var:read_data#.model} in your "data source" field. Replace read_data# with the proper number of your read data action and model with your read data model. Your form field names will have to match.

By "data source" you mean the "data provider" field in the Display form action?
​
Is there any tutorial on this. I have searched on line but I can not find anything for Chronoform v6.
​
​
Thanks!

Yes, that's what I mean.

Hi amentator,
​
There is some info on this in the CFv6 manual - see page 10. You can get the manual here
​
Bob

Thanks,
​
I might be doing something wrong because I can't get my form to be populated. I have tried to leave it very simple.
​
In the setup I have first action ReadDB as following:

​
​
Then I have a Display Form where the Data Provider I have: {var:read_data4}

​
​
The name of the fields in the table DB are exactly the same as those from the form.
​
I don't know what I am missing...
​
Anna

Like I said, {var:read_data#.model}

I have also tried {var:read_data4.model} in Data provider but still not working.

Well replace model with the name of your model

oops, true.
​
Thanks. It works now.

Hello,
​
I am sorry to open this again. I have also this problem - I read data, it does not populate fields in the form.
​
I have CF6 Version 6.1.4.
​
I cannot find an action for Display Form, only for Display Layout, and Display Layout does not have all the form attributes such as Data Provider. So how is it done?
​
Cheers
Tim

Set form to custom, put all fields in a "form area"

Or just put the {var:readdata.model.field} in each field. Much easier

Thank you, that solves the problem. Although I have used CF for several years I have been using an API to an external DB in bespoke PHP. This was my first attempt at it using Read Data and Save Data actions.
​
I must admit I was expecting a more "out of the box" solution to what I expect is a very common use case for forms generator products. Not your problem of course, I am just making a general comment.
​
Thanks again for your help.
​
Tim

I am facing a problem when reloading date field to CF form. My form Display Date in DD/MM/YYYY format but save to database in standard YYYY-MM-DD sql format. When I read the data from table to populate in the date field it is not displyimg the date correctly. How can we reload the date in DD/MM/YYYY format in CF form?

{date:d/m/Y$(var:readdata.model.field}

Thank you healyhatman

Hi healyhatman
I tried to apply the above solution to reload date from last created record in to a date field using

{date:d/m/Y$(var:read_data24.LastRecord.duty_date}

But it ended up in an error 0
​
DateTime::__construct(): Failed to parse time string ((var:read_data24.LastRecord.duty_date) at position 0 ((): The timezone could not be found in the database
​
What could be the problem?

Hi,
​
There's a typo - the closing ) is missing from healyhatman's example.
​
Bob

I added the closing ) to the example. Now The error is not generated , instead it populates the current date instead of the date in the read_data variable. I attached the screenshot of the problem along with the debug report of the read data.
1. I have a read_data action named read_data24 to get the duty _date value from last saved record.
2. The duty_date field is formatted for DD/MM/YYYY but saved to YYYY-MM-DD format
3. Aadded {date:d/m/Y$(var:read_data24.LastRecord.duty_date)} in duty_date 'value' field
4. But when form loaded the debug report shows the read data is correct but Date field is loaded with current date !
5. Also when I try to save the data , It saves the date in DD/MM/YYYY format in database instead of YYYY-MM-DD
​