Online Help Center

Caspio Bridge offers one of the easiest ways of creating feature-rich Web Forms to place on your web site. These Web Forms validate and store information in your Caspio Bridge table.

Advanced users can configure Web Forms to receive and pass parameters to facilitate data input or build multi-paged applications that use all relational database capabilities.

Caspio Bridge Web Forms can generate automatic emails to those who submit information (acknowledgement emails) and to people in your organization (notification emails).

With Web User Authentication and Record Level Security, Web Forms can be used to update the information already in the database.

Creating a Web Form to Receive New Submissions

Web Forms are created easily through DataPage Wizards. Here is the process for creating a Web Form to accept new submissions and trigger automatic emails. Creating an update form is described here.

• Ensure that you already have a table or view for this Web Form. If you are using a view, it must be based on a single table.

• From the File menu select New DataPage or in the DataPages view click on the toolbar. This brings up the DataPage Wizard.

1. DataPage Properties

Click on the Web Form icon on the left to select the DataPage type.

Select your table or view as data source and enter a name for your DataPage.

Select a Style and a Localization to apply.

Advanced Options

Click Next.

2. Capture or Update

Continue with the default choice of Capture Form (new submission). Update Forms are described here.

To allow automatic focus of cursor on the first field of the Web Form DataPage, check the Automatically focus cursor on first field option.

Click Next.

3. Select Fields

Select the desired fields from your table or view for the Web Form. Each field has an icon beside it indicating its data type. AutoNumber fields cannot be selected for a Web Form since they are automatically maintained by Caspio Bridge.

Advanced Options

While not selectable for a form, AutoNumber field often needs to be passed as parameter to the next page. If this is the case, check the On exit, pass AutoNumber ID field as parameter option.

Click Next.

4. Configure Fields

The fields you selected are listed on the left. Select each field, one at a time, and configure its properties on the right. Form element types are described separately.

Click the Insert button to add a section, a virtual field, an HTML block , CAPTCHA or header and footer.

Use the Move up and Move down buttons to change the display order of the sections, fields and blocks.

Advanced Options

Click the Advanced tab to configure the following:

Layout Options

• By default, every form field starts on a new line. Check Continue next element on same line to place multiple fields on one line.
• The Label Position radio buttons are useful when you want to override the section's label position for this particular field.

External Associations and Defaults

• By default, form fields are blank on load. You can either Assign a static value to provide a default value for the field or Receive parameter from another DataPage or from an external application.
• On exit, the form can Pass field value to next page as a parameter.

5. Destination and Triggers

Configure the Destination Page of this form. This is the page that is displayed for the user when this form is submitted. You have these options:

• Load the same form.  This is useful for data entry purposes.
• Redirect the user to a confirmation page (URL) on your own site.  For the URL address, you can enter the full URL address or you can enter a relative path.  To enable a relative path for your destination page, check the Relative checkbox and enter a valid relative path in relation to the deployed DataPage. You must have a confirmation page designed and accessible on your site.
• Load another DataPage.
• Display a confirmation message. Use the area below to compose the message.

Advanced Options

Use the Insert button to insert field values submitted through the form into the URL and the confirmation message.

Enable Acknowledgement email and/or Notification email, if desired. For acknowledgement emails, select the field that will contain the user's email address. The acknowledgement email will be sent to the value found in this field in the form.

Click Next to configure the emails, or click Finish.

6. Acknowledgement Email

This step is skipped if you did not enable Acknowledgement Emails.

Acknowledgement emails may be sent on your behalf to users who submit a DataPage. You have already identified the field of the form which contains the recipient's email address. Now, configure the remaining options as described here.

7. Notification Email

This step is skipped if you did not enable Notification Emails.

Notification emails are sent to fixed email addresses, normally within your organization, to notify one or more people that a new submission is made. You may assign a Table-driven value to the Reply-to field from the drop-down list or choose to use the same email address as the one in the From field. Configure your notification emails as described here.

8. Finish

A confirmation that your DataPage has been created is displayed. Click Close.