Database Form Block

Use a database form to accept submissions from website visitors.

Best practices

  • Consider using CASHNet storefronts as the first option for accepting payments.
  • Use concise yet descriptive field labels.
  • Group similar fields within fieldsets.
  • Use radio buttons instead of drop-down when four or fewer options are presented
  • Consider checkboxes instead of multi-select drop-down lists.
  • Offer as few fields as possible to complete the task.
  • Set the required and type option on form fields as applicable.

Create a database form

  1. Click the dot for Open Row where you would like to include a database form.
    The page appears and displays additional options.
  2. Click the dot for Edit column content.
    A window appears displaying choices.
  3. Click the Create and Connect Page option.
    A list of Content Class Groups appears.
  4. Click the Forms group in the top panel.
    The List of Content Classes in the bottom panel updates.
  5. Click the Database Form block.
    The Edit Headline window appears.
  6. Type a title for your form in the Enter the headline text box--this title will be hidden from the web page, but will be used for searching within Web Press. Click OK.
    The form is added to your page.

Add fields to your form

  1. If the Database Form Page is not already open (Close Database Form Page will display if this is the case), click the Open Database Form Page dot.
    The form opens.
  2. Click the dot for Edit list of form field items.
    The Edit Link Element window appears.
  3. Click the Create and Connect Page link.
    The List of Content Classes appears.
  4. Click the type of field you'd like to add to your form.
    A window appears asking for a label for your field.
  5. Type the label for your form field (which will show on your web page), and click OK.
    The field is added to your form.

Repeat steps 1-5 in this section until you have added all needed form fields.

Publish form

Once you're finished with your form, you must submit it to workflow and release it. This will publish the file to your website. To do this, follow these steps:

  1. Click the Tasks tab, which is third tab from the right on the top of the page.
    The screen changes to the Tasks tab.
  2. In the left navigation in the Tasks tab, expand My Pages. Then expand Pages Saved as Draft, and click the page that appears.
    The page shows up in the top window of the tasks tab.
  3. In the top window, right click the page and select Submit to Workflow.

If you are an editor for the site, continue with these steps:

  1. Expand Releases (if not already expanded), then expand Pages Waiting for Release. Click the page that shows up underneath.
    The page shows up in the top window of the tasks tab.
  2. In the top window, right click the page and select Release.
    The page is now submitted and released.

If you are not an editor for the site, wait until an editor has released the pages, then continue with the next section.

To publish the site,

  1. Click the SmartEdit tab on the top of the page to take you back to the page being edited.
  2. Click Open Web Page.
  3. Once the page is opened, right click somewhere on the page and select Publish Page.
    You may have to wait a few minutes for the page to show up on the live site.

Create/Update your database table

After your form has been published to your live site, you must visit the Database Services Management System to create the database table to hold the form submissions.

Follow these steps to create/update your form's database table:

  1. Access your Form Options in the Database Services Management System through one of the following methods:
    • Open the database form page in Web Press. Click the Database Services Management System link that appears in the shaded note.
    • 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. Type 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. Select Update Table Structure from the navigation.
    The Update Table Structure page appears.
  3. At the bottom of the page, select 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: Every time you make changes to your form, you must visit the Database Services Management System (as directed in Step 1 under the Create/Update Your Database Table section above) to update the table structure.