Forums

I've created a multipage form with 4 child forms. Everything is working perfect, email and writing to the database. I would like to add extra fields to the table view, currently there is only Record #n (once you click I can see all the data). How do I add for example the 'name' field to this as well?

Does it have anything to do with the fact that all the fields are not actually in the mother form, can this only be done if you have one single form?

Hi antoneimuller,

You can add a list of column names in the "Extra dataview columns fields names" on the DB Connection tab.

Bob

Thank for the reply. I've added it in example: Extra dataview columns fields names: quote_id,name,email,tel,cell

I've even tried to add into the "main view record:", but only display is record#n

antonei,

I apologize for barging in on this thread with a side question. Please don't let this stop your dialog with Bob.

But since you stated that you're getting the 4 child forms to add to the database correctly, may I ask what code you're using to do this? I've found various posts with different types of code throughout the forum, but most are for older versions and none seem to work. I'm getting each page posting to the database, but they're all posting their own entries - not all in one single entry. If you could let me know what you're using to make that happen, I would be most appreciative.

Hi antoniemuller,

That works for me. Do those columns actually exist in the table?

Bob

Morning,

Hope all is great. Yes, the fields do exist in the table. Is there any other settings? Are you using it for a multipage form (on mother form)?
I must be missing something, think I've been staring to it for too long :-P

Hi everyone,

Does anyone have a solution for this problem? I see there is a lot of views on this topic. Can this maybe be because it is a multipage form and none of the fields gets really submitted by the mother form (meaning the fields are in all the different child forms)?

The multipage form (mother form) is linked to the database though and everything is working 100% except for the table view fields. Any feedback will be appreciated.

Thank!

Hi antoneimuller,

Not a part of ChronoForms that I know much about. I've dug in the code and it's not easy to see exactly what is happening.

I suspect that the problem is that the DB Conenction is on the mother form but none of the input fields are present there (Max wrote the dataviewer code long before the multi-page plugin was invented).

As an experiment try putting a dummy input in the Mother Form | Form HTML box and see if this gets the data view version to show.

A dummy input looks like

<!-- <input name='some_name' type='text' >-->

This should be enough to fool ChronoForms into thinking that the input exists without displaying it.

Bob