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.
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.
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.
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.
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.
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.
Click Next.
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. Each field can be formatted
as described under Advanced Optionshere.
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. Configure your notification emails as described here.
8. Finish
A confirmation that your DataPage has been created is displayed. Click Close.
Preview your DataPage.
Deploy your DataPage on your site.
Control access with Web User Authentication and Record Level Security.
Customize DataPage look and feel through DataPage Styles.
Localize your DataPage into any language with country-specific formatting.