Mar 7th, 2010, 11:14 AM
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
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