skipped ID's on PayPal enabled forms

[gediweb]

My PayPal enabled form seems to be working fine, but when you look at the submissions, the ID's are skipping numbers. 2, 6, 7, 12...

Is this because people are submitting the forms, but abandoning the PayPal cart? Is there any way to record the id when they finish paying and return to the site?

[martin_undefined]

My PayPal enabled form seems to be working fine, but when you look at the submissions, the ID's are skipping numbers. 2, 6, 7, 12...

Is this because people are submitting the forms, but abandoning the PayPal cart? Is there any way to record the id when they finish paying and return to the site?

Hi,

Just went and looked at Paypal enabled form I've been testing.

I'm seeing skips in the numbers where I've dropped out before completing the payment. Equally, when I've done two payments consecutively, the numbers are sequential as you would expect. So it does look like gaps in the submission numbers are aborted payments.

Martin

[gediweb]

Since I am using the ID's as registration numbers for a show, it's a little weird if there are 30 registered people with badge numbers into the 80's No huge deal, but hope Ben can help us out on this!

[Ben]

Hi gediweb,

Unfortunately, this is one of the side-effects of using the API. In order to make the whole process work, Form Tools needs to store all form submissions prior to submitting to PayPal, which means adding the submission to the database, which means incrementing the submission ID count. This is unavoidable, I'm afraid.

But there are always workarounds.

If you need an incrementing counter I'd look into adding a new field in your database called "registration_number" or something. The simplest solution is to just manually update that value for each successful applicant. Not great, but with a small number like 30 records, that's probably the way to go.

If you had hundreds or thousands of registrations, you could look into using the Hooks Manager - or Submission Pre-Parser modules - to automatically increment that value for all successful registrations. But quite honestly, I wouldn't bother given the situation.

Hope this helps a bit...

- Ben