Adding a form generated from Campaign

An associated form is automatically created in Distributed Marketing when you publish a flowchart in Campaign.

The underlying schema for the associated form does not yet exist in the Distributed Marketing database.

When you open such a form, you are presented with a screen where you can select the database type and the action to take. You select one of the following:

  • Preview SQL

    Select this option to preview the SQL script that is used to create the database table for the form.

  • Run SQL Script

    Select this option to run the SQL script to create the database table for the form.

You cannot work with the form unless the underlying schema exists. That is, before you can edit or publish the form, someone must run the generated SQL commands to create the tables to store the contents of the form.