Mapped Statements

Mapped statements let you map form questions to columns in your database tables using the database connection string. 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.

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 read/write access to the tables you are saving the form information to.

How Do I...