From the Submissions page you can see who has been using your form and what data they submitted. You can see exactly when the form was submitted, the user’s IP address, and all data the user entered. You can view each submission individually by double clicking a submission in the table.
Submissions can be accessed directly via database SQL queries. By default Live Forms's submissions are stored in the built-in HSQLDB. You can easily [[V4_Installation_Instructions#Changing_from_HSQLDB_to_another_database | configure Live Forms to use a different database]] such as mySql, MS SQL Server, etc.. Doing so can make direct access to the submission database simpler.
There are many possibilities when using direct SQL queries against the Live Forms submissions repository. Several examples are described below. [http://www.frevvo.com/frevvo/web/static/contactUs Contact frevvo] for further assistance.
You may have a pledge or survey form and you would like to track the number of people that have submitted your form. Here is the SQL query to retrieve the count from the Live Forms submissions repository. In this example your Live Forms designer account name is 'JoeSmith', your application name is 'Economic Impact' and your pledge form is named 'pledge2009'.
To retrieve the count of ALL submission for a specific form:
To retrieve the count of ALL submission for forms in a specific application:
To retrieve the count of ALL submission for a given form designer:
Currently, if the user or app no longer exist (was deleted) the submissions will still be counted.