Successive form submissions by the same user overwrite eachother

[rrymrrsn]

Hi Joe,

Thanks a lot for your reply. I have had a look through documentation again and found this, which refers to resetting form sessions to allow for resubmission:
http://docs.formtools.org/api/?page=ft_a...m_sessions

I already had this PHP in my 'Thank you' page:

PHP Code:

<?php
$curr_folder = dirname(__FILE__);
require_once("$curr_folder/includes/library.php");
$fields = ft_api_init_form_page($pp["form_id"]);
ft_api_clear_form_sessions();
?>

So that seems to be OK.

The submission ID gets sent to PayPal in the 'custom' variable to uniquely identify the transaction at that end:

PHP Code:

$fields["custom"] = $fields["form_tools_submission_id"]; 


Once the PayPal IPN script has finalised the form submission:

PHP Code:

// successful payment! finalize the submission in the database
if (eregi("VERIFIED", $result)) 
{
  ft_finalize_submission($pp["form_id"], $_POST['custom']);
} 


the submission ID just gets sent out in the FT triggered email labelled 'Entry number'.

If anyone has any further ideas on this that would be great.

Thanks
Rry

Hi Rry,

There are definitely some nuances when using Paypal (especially when you're using Paypal IPN).

Have you reviewed the documentation for Paypal yet: http://docs.formtools.org/tutorials/paypal/?page=index

It sounds like you're using the email (since the users continues to receive other emails with the same ID) to uniquely identify the submissoin, so if the user uses the same email for each entry the record is overwritten. You may need some additional information to uniquely identify the record or simply query the email to see if its in the database to prevent the same email from submitting more than once.

Hope this helps.

Cheers,

Joe