Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Section
Column
width40%
Panel
borderColorlightgrey
bgColor#F0F0F0
titleColorwhite
borderWidth1
titleBGColor#88AACC
borderStylesolid
titleOverview

The Submissions page shows 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.

 

Image Added

Note
Currently, if the user or app no longer exist (was deleted) the submissions will still be counted.
Column
width20%
Panel
borderColorlightgrey
bgColor#F0F0F0
titleColorwhite
borderWidth1
titleBGColor#88AACC
borderStylesolid
titleSubmissons Chapters

Submissions Database

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.

Count

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:

Code Block
select count(*) from formsubmission fs, formsubmissiontype fst where formsubmissiontype_formtype_id=fst.id 
and fst.ownerid='JoeSmith' and fst.deleted is null and fs.state='SUBMITTED' and 
fst.applicationname='Economic Impact' and fst.name='pledge2009'

To retrieve the count of ALL submission for forms in a specific application:

Code Block
select count(*) from formsubmission fs, formsubmissiontype fst where formsubmissiontype_formtype_id=fst.id 
and fst.ownerid='JoeSmith' and fst.deleted is null and fs.state='SUBMITTED' 
and fst.applicationname='Economic Impact'; 

To retrieve the count of ALL submission for a given form designer:

Code Block
select count(*) from formsubmission fs, formsubmissiontype fst where formsubmissiontype_formtype_id=fst.id 
and fst.ownerid='JoeSmith' and fst.deleted is null and fs.state='SUBMITTED'; 

View/Edit Submissions

XML Documents 

Process Form Data Tutorial

Warning

The frevvo database is not designed for custom reporting. The submission data is stored in an unsearchable blob format. Although

Frevvoproduct
in-house customers may access submissions directly via database SQL queries, this is strongly discouraged. Future
Frevvoproduct
versions often have changes to the underlying submission database schema which will break your SQL queries. If you are thinking about using a third party reporting tool to read from the frevvo database, we recommend that you store form/flow submission data in a custom database using the frevvo Database Connector. Use the reporting tool against the custom database.