Create a Database Form Outside Web Press

Create a Database Form

Steps to Complete in Your Web Page Authoring Software (ex: Microsoft FrontPage)

  1. Create an HTML page with a form. See the Optional Form Fields section below for fields you may want to include in the form.
  2. Set the form action to https://apps.missouristate.edu/web/database/formprocessor.aspx

    Example form tag:
    <form id="MyForm" method="post" action="https://apps.missouristate.edu/web/database/formprocessor.aspx">
    Microsoft FrontPage Instructions: From the Form Properties window, click the Send to other: Custom ISAPI, NSAPI, CGI, or ASP Script radio button. Click the Options button; the Options for Custom Form Handler window opens. Set the Method to Post, the Action to https://apps.missouristate.edu/web/database/formprocessor.aspx,and click OK twice.
  3. Save the form to your website.

Steps to Complete in Your Web Browser

  1. Access your Form Options in the Database Services Management System through one of the following methods:
    • Visit your form in a web browser. In the address bar, add a .db to the end of the form's web address and visit that address.
    • Visit the Database Services Management System. Enter the web address of your form in the Form Address text box and click the Lookup Database button.
    You will be asked to log in and will be redirected to the Database Services Management System.
  2. Click Update Table Structure on the navigation.
    The Update Table Structure page appears.
  3. At the bottom of the page, click Create Table (or Update Table if the table already exists).
    The database table is created/updated. Submissions from your form will now be inserted into the database.

Note: You should visit the Database Services Management System as directed in Step 1 under the Steps to Complete in Your Web Browser section and update the table structure any time you make changes to your form.

Optional Form Fields

The form processor will recognize the following special form fields.

DBTableName
Specifies a table to store the results of your form. If your page has more than one form, this field is required. The application will automatically generate a table name when this field is omitted.
<input type="hidden" name="DBTableName" value="MyTableName" />
ConfirmationPage
Specifies a thank you page which will be displayed to a user upon successful submission.<input type="hidden" name="ConfirmationPage" value="http://www.missouristate.edu/web/thanks.htm" />
IgnoredFields
Specifies form fields which do not have matching database records. Field names should be separated by semicolons. Unmatched fields not listed here will generate a submission error.<input type="hidden" name="IgnoredFields" value="B1;Submit" />
NotifyOnSubmission
Specifies email addresses to which the form processor should send notifications when a form submission is received. Email addresses should be separated by semicolons.<input type="hidden" name="NotifyOnSubmission" value="bearpass1@missouristate.edu;bearpass2@missouristate.edu" />

Sample Form

<form id="MyForm" method="post" action="https://apps.missouristate.edu/web/database/formprocessor.aspx">
  <input type="hidden" name="DBTableName" value="MyTableName" />
  <input type="hidden" name="ConfirmationPage" value="http://www.missouristate.edu/web/thanks.htm" />
  <input type="hidden" name="IgnoredFields" value="B1;Submit" />
  <input type="hidden" name="NotifyOnSubmission" value="bearpass1@missouristate.edu;bearpass2@missouristate.edu" />
</form>