+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Missing data rows from admin side view (/showthread.php?tid=780)
Missing data rows from admin side view - coldrake - Jul 15th, 2010
Hi, I have come across a really weird issue.
When I log in as an admin I have one form that is missing rows in both the views and export. The data comes up in my front-end forms and MySQL no problem, but not on the admin side. I have 3 forms, the other two are fine. The form is missing 7 out of 24 records. This really has me scratching my head. If anyone any suggestions, they would be highly appreciated.
Thanks,
Penny
RE: Missing data rows from admin side view - Ben - Jul 17th, 2010
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_api_delete_unfinalized_submissions
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
RE: Missing data rows from admin side view - coldrake - Jul 18th, 2010
You are absolutely right, the missing entries weren't finalized. Once I changed them to finalized they showed up right away. Thanks so much for your help. I was really pulling my hair out.
Penny