Forums - How to submit Form data at each page submit

earthwatch 23

March 08 2018, 10:52 #375944

Hi,

We have a form that is 4 pages and we would like to submit the data each time they press the next button to avoid the form timing out as some of the questions are pretty long.

How would I submit the data at each Next Page submit?

Thanks
Paul.

GreyHead 64

March 08 2018, 14:56 #375959

Hi Paul,

Add a Save Data action on Page 2, then add the new record ID to the form data on the following pages, and add Save Data actions on the following pages too.

Bob

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

E

earthwatch 23

March 08 2018, 15:33 #375961

Hi Bob, hope you are well.

I get the first part add the Save Data, but how do I add 'the new record ID' to the following pages? I looked at the available drag on items, but this is not one of them.

Thanks
Paul.

E

earthwatch 23

March 19 2018, 14:01 #376211

Hi Bob, hope you are well.I get the first part add the Save Data, but how do I add 'the new record ID' to the following pages? I looked at the available drag on items, but this is
not one of them.

ThanksPaul.

GreyHead 64

April 08 2018, 13:20 #376810

Hi Paul,

With a lot of trial and error I think I have this working. (There may be a better solution!)

I tested with the Demo multi_page form and added a Save Data action to the Page 2 event. That generates an 'aid' value for the new record. To get this into the form data I added a PHP action after the DB Save with this code:

$id = $this->get('save_data10.aid', '');
$this->data('aid', $id, true);

Note - data10 is the name of my Save Data action.

This adds the value of aid to the form data, but to get it carried forward to the next page the PHP Action needs to be followed by a Multi-Page action. I added a second one but I think that dragging the first one down will work as long as it remains before any actions that use data from a previous page.

Once the aid value is in the form data following pages should use that to update the existing record without requiring anything extra to be done.

Bob

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

E

earthwatch 23

April 09 2018, 08:35 #376818

Hi Bob, thanks for your reply. I tried adding the PHP code as you explained on page 2 after the save data, but get this error:

Parse error: syntax error, unexpected '' (T_STRING) in /******/extensions/chronofc/functions/php/php_output.php(6)
: eval()'d code on line 2

I added the code you explained:
$id = $this->get('save_data25.aid', '');
$this->data('aid', $id, true);

Screenshot:

Any ideas?

Thanks
Paul.

Attachments

(26.39 KiB)

641 Downloads/Views

GreyHead 64

April 09 2018, 09:05 #376820

Hi Paul,

Did you copy and paste the code from my post here - if so, please try re-typing from scratch. Forum copies seem to contain some odd invisible characters - I got JavaScript errors when trying that.

If that isn't it you could try re-placing the single quotes with double quotes - though single quotes are working fine on my test form.

Bob

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

E

earthwatch 23

April 09 2018, 09:57 #376825

Hi Bob, I retyped the text and now no error, but still saves to separate lines in the db. See below my screenshot of the order of code / save data, is this correct? Also I have tried the Save Data > Write Action to be Auto Detect and Insert Duplicate Key Insert but neither work.

Attachments

(32.59 KiB)

648 Downloads/Views

GreyHead 64

April 09 2018, 12:29 #376834

Hi Paul,

Is the ID column in your table named 'aid'? If not you need to replace aid in the code with the correct column name.

What do you see if you add a Debugger action - down at the bottom you should see the value of aid and the DB query that is being created.

Bob

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

E

earthwatch 23

April 10 2018, 16:38 #376919

Hi Bob, yes I am using 'aid' as the column, I have added the debugger as the end action on page 2, please see below for results, it does seem to bring through the aid:

Array
(
    [chronoform] => teach-earth
    [event] => page2
    [title] => Mrs
    [first_name] => Paul
    [last_name] => Spyker
    [email_address] => pspyker@earthwatch.org
    [confirm_email] => pspyker@earthwatch.org
    [school_name] => ds
    [street_1] => sd
    [street_2] => sd
    [town_city] => dsdsds
    [county] => ds
    [post_code] => ds
    [find_out] => News
    [newsletter] => 
    [payee] => 
    [disadvantagedarea] => 
    [Next_Step] => 
    [34228dc26f0d52f519647e7f1d44f173] => 15e4979f63a2a9f8c416a632bff219cb
    [142cb0b06bce91f2690f0ae42cdceaf3] => c360a5865b91060f75caa08e2144cb12
    [Itemid] => 399
    [option] => com_content
    [view] => article
    [id] => 1
    [teach-earth] => 
    [aid] => 43
)

GreyHead 64

April 11 2018, 08:43 #376931

Hi Paul,

There is something odd here - you are showing aid = 43 in the form data - yet the Save Data action is showing the same aid = 43 after an INSERT request. The logic does not make sense. Please can you check the sequence of actions to check the logic.

Bob

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

admin 28

April 13 2018, 03:01 #376996

Hi,

What data provider is used in the "Save data" action ?

Best regards

Max
If your main question got answered then please mark the answer using the button!
Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!

E

earthwatch 23

April 16 2018, 08:26 #377018

Hi Max, the data provider field is blank. Should it contain something and if so what?

Bob, can I send you access to the form, it may be easier than me trying to explain what is what? I will email you the information.

Thanks
Paul.

GreyHead 64

April 17 2018, 09:40 #377053

Hi Paul,

I'm not sure but I think that the problem - or a part of it - is that you need to have the Multi-Page action(or a second Multi-Page action) in the Page 2 event (the first time you save data) *after* the Save Data action otherwise the value of aid is not saved and carried forward with the rest of the data. The php29 code you have at the start of the Page 3 action is almost certainly doing nothing useful.

Bob

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

E

earthwatch 23

April 17 2018, 10:32 #377064

Hi Bob, I don't fully understand your note above, but from what I can tell you are asking me to add another Multi-page action after the save data event. I did this, see below but still it saves each page as a separate line in the database. Am I missing something from you message above?

Attachments

(25.18 KiB)

573 Downloads/Views

GreyHead 64

April 17 2018, 12:13 #377066

Hi Paul,

Please move it down below the PHP action where you are adding the aid value to the form data.

Bob

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

E

earthwatch 23

April 17 2018, 12:48 #377069

Hi Bob, tried that but still no luck.

GreyHead 64

April 17 2018, 14:55 #377071

Hi Paul,

OK :-(

Please add a Debugger in the Page 3 Event as the last action so we can see what data is there.

Bob

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

E

earthwatch 23

April 17 2018, 15:49 #377073

Hi Bob, please see below:

Array
(
    [chronoform] => teach-earth
    [event] => page3
    [attend_training] => 1
    [experiment] => 1
    [sdgs] => 1
    [outside_activities] => 1
    [camp_tents] => 1
    [group_discussions] => 1
    [action_plan] => 1
    [evaluation_process] => 1
    [button5] => 
    [34228dc26f0d52f519647e7f1d44f173] => dd793d2c51ffde0863d1b1ff48046373
    [142cb0b06bce91f2690f0ae42cdceaf3] => c1875a7e9de37850d1b5fb8caf0be417
    [Itemid] => 399
    [option] => com_content
    [view] => article
    [id] => 1
    [teach-earth] => 
    [aid] => 
)