Form Tools
Non-consecutive IDs - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: API (https://forums.formtools.org/forumdisplay.php?fid=17)
+--- Thread: Non-consecutive IDs (/showthread.php?tid=27703)



Non-consecutive IDs - inscara - Sep 5th, 2017

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?


RE: Non-consecutive IDs - inscara - Sep 5th, 2017

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.


RE: Non-consecutive IDs - alexh - Sep 5th, 2017

Check out the documentation on unfinalized submissions. https://docs.formtools.org/api/ft_api_delete_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.


RE: Non-consecutive IDs - ocbroadband - Dec 3rd, 2017

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.