Creating a Submission Form DataPage
Caspio Bridge offers one of the easiest ways of creating feature-rich Submission Forms to place on your web site. These Submission Forms validate and store information in your Caspio Bridge table.
Advanced users can configure Submission Forms to receive and pass parameters to facilitate data input or build multi-paged applications that use all relational database capabilities.
Caspio Bridge Submission 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, these forms can be used to update the information already in the database.
Creating a Submission Form to Receive New Submissions
Submission Forms are created easily through DataPage Wizards. This page explains the process for creating a Submission 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 Submission 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 Forms icon on the left and on the Submission Form icon on the right to select the DataPage type. Click Next.
2. DataPage DataSource
Select your table or view as data source and enter a name for your DataPage.
Select a Style and a Localization to apply.
Check Enable Advanced Options to access field layout options and set up external associations and defaults.
Check Enable parameters to enable your DataPage to pass and receive parameters. Read more about using parameters here.
3. Select Fields
Select the desired fields from your table or view for the Submission Form. Each field has an icon beside it indicating its data type. AutoNumber fields cannot be selected for a Submission Form since they are automatically maintained by Caspio Bridge.
To allow automatic focus of cursor on the first field of the Submission Form DataPage, check the Automatically focus cursor on first field option.
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.
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.
Click the Advanced tab to configure the following:
- 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.
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.
A confirmation that your DataPage has been created is displayed. Click Close.