Non-consecutive IDs

[inscara]

Hi,

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?

[inscara]

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.

[alexh]

Check out the documentation on unfinalized submissions. https://docs.formtools.org/api/ft_api_de...bmissions/

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.

[ocbroadband]

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.