Mapped Statements

Mapped statements let you map form questions to columns in your database tables using a database defined in the Databases screen. This feature only allows you to insert data into the table and not update existing date or complete questions on the form.

Jenzabar recommends inserting the information into a custom table as the information the form user enters cannot be validated or verified to determine if it already exists in the database.  

Mapped Statements can be executed once per submission or they can be executed once for each response to a multi-response question such as the Collection Grid. Statements can also be specified to execute on approval where the Workflow portlet will control the time of execution.

For this feature to work:

You must have a connection to the database you are mapping to set up in FormFlow. See Set Up Database Connections for more information.

You must have select/insert access to the tables you are saving the form information to.

How To

Map Data as Single Row

Map Data for Each Question/Collection grid

Save the Submission as a PDF

Save the Submission as a PNG

Related Topics

Collection Grids