Hello There, Guest! Register

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Non-consecutive IDs

I'm using Form Tools 2.2.6. I've installed Submission ID manager module to reset the ID counter after sending test submissions. I used the delete option and reset the ID to 1. Then I submit a test submission and it got the correct ID == 1. However, when people started to use the form the submissions ID were 39, 48, 57 and 65 (ever 9 units). How can I at least make that the ID increments in 1 instead of 9?
I've found the problem. Everytime the submit button is pressed a new record is created with NULL values even if there are validation errors.
Check out the documentation on unfinalized submissions.

If the form is started but never submitted, it will get a submission ID but not actually show up in your list of submissions on the back end.

If you are concerned about it, there is a delete unfinalized submissions function.
Does this compress all the ID's as well? IE, make them sequential? 14,7,8,9,11,12 turn into 1,2,3,4,5,6,7? I've seen this command as well, but not quite sure how to implement it.

Forum Jump:

Users browsing this thread: 1 Guest(s)