Jul 17th, 2010, 9:50 AM
Hi Penny,
Thanks for the post! There are two likely causes:
1. The rows you can see by viewing the database directly are not finalized. You can check this out by looking at the is_finalized database column. Form Tools will only ever show finalized submissions. In short, what "finalization" means is that Form Tools sometimes stores incomplete form data in the database, then when it's complete it gets set as finalized. This can be handy for multi-page forms: the moment the user submits the first page of the form, the data is stored in the database. But you don't really want to SEE that data yet in Form Tools, since the person may not finish the submission. Hence the finalization mechanism.
If you're using the API, you might want to look at this function if you're concerned about these dud, orphaned DB entries:
http://docs.formtools.org/api/?page=ft_a...ubmissions
2. The other possibility is that the View you're using is limiting the results to a subset of all form submissions. You can check this by going to Edit Form -> Views -> Edit View -> Filters tab. That will list any filters you have hooked up for that form View.
Hope this helps!
- Ben
Thanks for the post! There are two likely causes:
1. The rows you can see by viewing the database directly are not finalized. You can check this out by looking at the is_finalized database column. Form Tools will only ever show finalized submissions. In short, what "finalization" means is that Form Tools sometimes stores incomplete form data in the database, then when it's complete it gets set as finalized. This can be handy for multi-page forms: the moment the user submits the first page of the form, the data is stored in the database. But you don't really want to SEE that data yet in Form Tools, since the person may not finish the submission. Hence the finalization mechanism.
If you're using the API, you might want to look at this function if you're concerned about these dud, orphaned DB entries:
http://docs.formtools.org/api/?page=ft_a...ubmissions
2. The other possibility is that the View you're using is limiting the results to a subset of all form submissions. You can check this by going to Edit Form -> Views -> Edit View -> Filters tab. That will list any filters you have hooked up for that form View.
Hope this helps!
- Ben