demo sample http://www.benjaminkeen.com/software/rsv/standalone/demo.php?page=7

[Ben]

Hi Wout,

I don't know about the "NULL" thing - all submissions in the database will have a unique submission ID (it's an auto-increment column, so NULL isn't possible).

But yes, with multi-page forms you'll see the number erratically increase. This is because not everyone will complete the form, but *everyone* that arrives at the form will have a record created in the database. Only when they actually finish putting through the submission will the record appear in the Form Tools admin - because at that point, the submission has been finalized (i.e. told that it's now complete).

So in fact, your database table will eventually fill up with a lot of old, incompleted unfinalized submissions. To clear those out, see this function:
http://docs.formtools.org/api/?page=ft_a...ubmissions

All the best -

Ben

[wout]

Hello Ben,

Do I have to put: ft_api_delete_unfinalized_submissions($form_id, false); on each multipageform? or only at the last submit page?
Something like this:

<?php
require_once ("global/api/api.php");

$fields = ft_api_init_form_page();
$params = array(
"submit_button" => "sbmt",
"next_page" => "stap7.php",
"form_data" => $_POST,
"no_sessions_url" => "index.php",
"finalize" => true
);
ft_api_delete_unfinalized_submissions(3, false);
ft_api_process_form($params);

?>

3 is the number of the form ID.

Thanks, regards Wout

[Ben]

Hi Wout,

All the ft_api_delete_unfinalized_submissions() function does is delete old, unwanted submissions, so it really doesn't need to be called that often.

I'd just add it to your thankyou.php - that would ensure it gets called often enough!

ft_api_delete_unfinalized_submissions(3, false);

And yes, this looks good!

- Ben