This documentation is for Live Forms 9.1. v9.1 is a Cloud Only release. Not for you? Earlier documentation is available too.

COVID-19 Response Info: At frevvo, our top priorities have always been employees and customers. We have taken several steps to promote the well-being of our people, to minimize services disruptions, and to help where we can. Visit our website for updates.

Submissions

Owned by Former user (Deleted)
Last updated: Dec 12, 2019 by Megan Ellis
2 min read
Overview

Forms submissions can be saved to many places. For instance you can save your submissions in the Live Forms server's built-in submission repository; store them as email attachments in someone's email inbox; store them into a Google Sheets or a Google Drive folder; store them into a document management system or ECM system such as Confluence; store them into a database or other 3rd party system such as a CMS etc.

The submissions repository UI page allows non-admin users, with the proper permissions, to

  • View submissions activity over a given time period.
  • Search your submissions using form/workflow data.
  • Create search filters based on a wide variety of criteria.
  • Build logical expressions to quickly locate the submissions that match the specified conditions.
  • Export your submissions to a csv file that can be easily imported into Excel.

Submissions display in the Submission View and the Legacy Submission View. The Legacy Submissions View is provided for access to the Export to Excel feature.

The Export of submissions to Excel feature has been replaced by the Download to CSV. If you have not used the Export to Excel feature in the past, we recommend that you become familiar with the Download to CSV .
You can still use the Export to Excel feature by accessing it from the Submissions Legacy view. However, the Legacy Submissions view and the Export to Excel may be removed in a future release.

Submissions Legacy View

Tenant admins can monitor submission activity using the Reports.

Submissons Chapters

Submissions Stored Inside of Live Forms

Submissions Stored Inside of Live Forms - Legacy View

Submissions Stored Outside of Live Forms

XML Documents

The frevvo database is not designed for custom reporting. The submission data is stored in an unsearchable blob format. Although in-house customers may access submissions directly via database SQL queries, this is strongly discouraged. Future 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/workflow submission data in a custom database using the frevvo Database Connector. Use the reporting tool against the custom database.