[Fixed] Multipage Form - Not writing to DB

Hi,
I have a problem with my multipage form.
As far as I can tell everything is setup correct. The form works from page to page.
The database table is shown as being linked to the mother form, it just wont write data to the table.
Am I supposed to make any redirects or anything else? I just can't find any complete howto.
I have created 4 forms, set the 4 form names in the multipage plugin against the mother form.
I haven't changed any other html or settings in any of the forms?

Thanks
Gary

Hi Gary,

I assume that this is ChronoForms v3? There are some long threads here about saving from Multi-page forms.

From memory it should work OK if you have the DB Connection enabled on the Mother Form???

Bob

Yes it's ver3. I definitely see the connect to the database table on the mother form.
The forms itself works from page to page.
Is the data supposed to be written to the table after each form or once at the end?
And is there anything to be done at the end in terms of code?

Here's debug from each form:

Form1
Form passed first SPAM check OK
Form passed the submissions limit (if enabled) OK
Form passed the Image verification (if enabled) OK
Form passed the server side validation (if enabled) OK
$_POST Array: Array ( [child_nursery] => sdfas [child_surname] => sdfsdf [child_firstname] => sdfsdf [child_nickname] => asdfasdf [child_add1] => sdf [child_add2] => asdfasdf [child_town] => sdfs [child_county] => sfd [child_postcode] => sdf [child_phone] => sdf [button_11] => Next [a9f474ebd4f89cd227b1e15076a9dc4b] => 1 [1cf1] => 72be1aa7f73d34c6fa2d12854ae4a417 [chronoformname] => Application )
$_FILES Array: Array ( )
Form passed the plugins step (if enabled) OK

Form 2
Form passed first SPAM check OK
Form passed the submissions limit (if enabled) OK
Form passed the Image verification (if enabled) OK
Form passed the server side validation (if enabled) OK
$_POST Array: Array ( [parent1_name] => qweqwe [parent1_emp] => qweq [parent1_pow] => qweq [parent1_dept] => weqw [parent1_mob] => qweq [parent1_worktel] => qweq [parent1_hometel] => qweq [parent1_email] => [email]mail@email.com[/email] [button_9] => Next [cfformstep] => 1 [a9f474ebd4f89cd227b1e15076a9dc4b] => 1 [1cf1] => 72be1aa7f73d34c6fa2d12854ae4a417 [chronoformname] => Application )
$_FILES Array: Array ( )
Form passed the plugins step (if enabled) OK

Form 3 Bypassed i.e. nothing entered

Form 4
Form passed first SPAM check OK
Form passed the submissions limit (if enabled) OK
Form passed the Image verification (if enabled) OK
Form passed the server side validation (if enabled) OK
$_POST Array: Array ( [radio0] => Yes [misc_medicaldetails] => asdasd [misc_placedate] => 10/08/2011 [radio1] => radio 1 [misc_source] => asdasd [check2] => Array ( [0] => Parent 1 ) [chrono_verification] => 5MfxQ [button_31] => Submit [cfformstep] => 3 [a9f474ebd4f89cd227b1e15076a9dc4b] => 1 [1cf1] => 72be1aa7f73d34c6fa2d12854ae4a417 [chronoformname] => Application )
$_FILES Array: Array ( )
Form passed the plugins step (if enabled) OK
Debug End

I'm not seeing any database stuff in the debug but I don't know if I'm supposed to?
Cheers
Gary

Cracked it.
Turned off emailing in the child forms.
Set mother form to email and setup email.
Set database connection to write before sending email.

That did it.

Cheers
Gary

Hi BodgeIT,

That makes sense, well fixed.

You can enable saving on each child form (except the last) if you want to save the intermediate data. I think you then have to pick up the record cf_id and carry that forward so that the same record is updated rather than a new one created at each step.

Bob