Forums

I have a form that is supposed to save the data to a table in the database. It is creating a record, and also apparently saving the data in the form, but when I go to view the records through the Data listing panel it looks like this:



But if I go look in the table itself through a different component I see that they are populated with data:



What do I need to do to be able to see the data in the back end of Chronoforms?

Hi MaestroC,

I've never quite worked this out - usually I install MijoSQL or AceSQL on sites I work on as these give me much easier database access.

Please try setting the columns you want to view in the form DB Viewer tab. I think that will add the columns into the Viewer for you.

Bob

I believe I've worked this out. Open your form in edit mode, go to DB Viewer. Create a list of field name/label pairs. Like this:

fname=First Name
lname=Last Name
address1=Address
address2=Address2

The field name must match the field names on your form. The labels can be whatever you want to call them - they will serve as the column headers when you view the form data. I've made mine to match my form labels. Click Save and Close, then, in the Forms Manager, click the drop down under Connected Tables and chose the table you want to view (the one you saved your form data to). Your data listing should now appear with data saved from your form. You can also sort the data here.

Thanks.