Aug 26th, 2011, 1:38 PM
Hi Lina,
The API works by creating an empty, hidden (i.e. unfinalized) submission when the user goes to the form. They then fill it up with values as they progress through the form pages. Once they click to the thankyou page, the submission is (usually) finalized, which means at that point it's then visible within the Form Tools interface.
The reason it's done this way is to create a storage mechanism for all the form data as the user progresses through the form - the database itself! "Finalization" is a simple way to hide those incomplete submissions until they've been completed.
So when you look at your database, yes - you'll see some unfinalized submissions. Those are from people that either just clicked to the form and didn't fill anything in, or started filling in the form but stopped somewhere along the way. It's normal! Don't worry.
If you don't like your database table getting all cluttered with this dud data, check out this function:
http://docs.formtools.org/api/?page=ft_a...ubmissions
You can just include that function on one of your form pages and it will clean out the database's old, unwanted unfinalized submissions.
Hope this helps!
- Ben
Quote:I found somewhere on the forum that code on the first page creates new blank submission, right? What does this mean?
The API works by creating an empty, hidden (i.e. unfinalized) submission when the user goes to the form. They then fill it up with values as they progress through the form pages. Once they click to the thankyou page, the submission is (usually) finalized, which means at that point it's then visible within the Form Tools interface.
The reason it's done this way is to create a storage mechanism for all the form data as the user progresses through the form - the database itself! "Finalization" is a simple way to hide those incomplete submissions until they've been completed.
So when you look at your database, yes - you'll see some unfinalized submissions. Those are from people that either just clicked to the form and didn't fill anything in, or started filling in the form but stopped somewhere along the way. It's normal! Don't worry.

If you don't like your database table getting all cluttered with this dud data, check out this function:
http://docs.formtools.org/api/?page=ft_a...ubmissions
You can just include that function on one of your form pages and it will clean out the database's old, unwanted unfinalized submissions.
Hope this helps!

- Ben