Form Builder Menu Items

Menu Path	Purpose	Notes
File > Properties	View or modify properties for the form or report.	You view and change the properties in the Form Properties dialog box.
Form > Background	Sets the background color of the form or report.	Defaults to White.
Form > Grid	Turn the grid on for the form or report.	The grid can be used as a guide to place controls evenly in the workspace.
Form > Ruler	Turn the ruler on for the form or report.	The ruler can be used as a guide to place controls evenly in the workspace.
Form > Add New Page	Add a new page to the form or report.	You can add an unlimited number of pages to a form or report.
Form > Delete Page	Delete the selected page from the form or report.	A form or report must have at least one page.
Form > Move Page Forward	Move the selected page forward by one page in the form or report.
Form > Move Page Back	Move the selected page back by one page in the form or report.
Form > On Validate	Specify the JavaScript (executed when the form or report is submitted for processing) that validates the input fields.	Validating form or report criteria is optional. However we recommend that you use validation to ensure that input fields are completed before submitting the form or report. Use the Help button to view detailed descriptions of the variables for each expression in the JavaScript window.
Form > On Load	Specify the JavaScript (executed when the user loads the form or report) that validates the input fields.	See Notes above for On Validate.
Form > Common Script	Store functions that are shared between all events and other scripts. If a function can be used in more than one script in a form or report, the function can be placed in a common script and referenced as required.
Form > Actions	Select the button or buttons that are displayed at the top of a form or report when the form or report is viewed in a browser.	Options include: OK Cancel Print <<Back Next>> Create Criteria By default, all options are selected. You must unselect the check boxes for the buttons that you do not want to appear. For example, if you add a customized Submit button to a form or report, you must unselect the "Actions" Submit check box so that the same button does not appear twice on the report.
Form > Key Fields	Use this path to indicate the fields that are displayed in the Available Drafts table when a user saves a form as a draft. All controls that are on the form can be selected.	This menu path does not apply to the reports. The path is used to create forms only.
Form > Group permissions	Assign group permissions to the form or report. Assign view and run report permissions to any of the groups set up in the system, for example, Employees or Supervisors.	You cannot distinguish between view and run permissions for a group. For example, if you assign Supervisors permissions, you cannot specify that the group can view the form or report but not run the form or report.
Tools > Template Management	Create, edit, or delete form or report templates.	All form or report templates that have been created in the Form Builder are displayed in the Template Manager window.
Tools > System Defaults	Add, edit, or delete System Default entries.	These entries act as templates for tasks you perform often. They are created in the SYSTEM_DEFAULT table and can be used as the default value in the Default property of the following controls: Date Picker HiddenLabel Text Box TimeEditor
Tools > Form Management	Delete reports, data forms, or forms from the application database.	Once you delete an item from the Form Management window, you cannot retrieve the item. Make sure you no longer need the item when you remove the item.
Help > Trace SQL	Displays SQL trace data to help you troubleshoot forms or reports.
Help > Debug Function	Acts as an editor where you can create or modify SQL or JavaScript without opening a specific form.

File > Properties

View or modify properties for the form or report.

You view and change the properties in the Form Properties dialog box.

Form > Background

Sets the background color of the form or report.

Defaults to White.

Form > Grid

Turn the grid on for the form or report.

The grid can be used as a guide to place controls evenly in the workspace.

Form > Ruler

Turn the ruler on for the form or report.

The ruler can be used as a guide to place controls evenly in the workspace.

Form > Add New Page

Add a new page to the form or report.

You can add an unlimited number of pages to a form or report.

Form > Delete Page

Delete the selected page from the form or report.

A form or report must have at least one page.

Form > Move Page Forward

Move the selected page forward by one page in the form or report.

Form > Move Page Back

Move the selected page back by one page in the form or report.

Form > On Validate

Specify the JavaScript (executed when the form or report is submitted for processing) that validates the input fields.

Validating form or report criteria is optional. However we recommend that you use validation to ensure that input fields are completed before submitting the form or report. Use the Help button to view detailed descriptions of the variables for each expression in the JavaScript window.

Form > On Load

Specify the JavaScript (executed when the user loads the form or report) that validates the input fields.

See Notes above for On Validate.

Form > Common Script

Store functions that are shared between all events and other scripts. If a function can be used in more than one script in a form or report, the function can be placed in a common script and referenced as required.

Form > Actions

Select the button or buttons that are displayed at the top of a form or report when the form or report is viewed in a browser.

Options include:

OK

Cancel

Print

<<Back

Next>>

Create Criteria

By default, all options are selected. You must unselect the check boxes for the buttons that you do not want to appear. For example, if you add a customized Submit button to a form or report, you must unselect the "Actions" Submit check box so that the same button does not appear twice on the report.

Form > Key Fields

Use this path to indicate the fields that are displayed in the Available Drafts table when a user saves a form as a draft. All controls that are on the form can be selected.

This menu path does not apply to the reports. The path is used to create forms only.

Form > Group permissions

Assign group permissions to the form or report. Assign view and run report permissions to any of the groups set up in the system, for example, Employees or Supervisors.

You cannot distinguish between view and run permissions for a group. For example, if you assign Supervisors permissions, you cannot specify that the group can view the form or report but not run the form or report.

Tools > Template Management

Create, edit, or delete form or report templates.

All form or report templates that have been created in the Form Builder are displayed in the Template Manager window.

Tools > System Defaults

Add, edit, or delete System Default entries.

These entries act as templates for tasks you perform often. They are created in the SYSTEM_DEFAULT table and can be used as the default value in the Default property of the following controls:

Date Picker

HiddenLabel

Text Box

TimeEditor

Tools > Form Management

Delete reports, data forms, or forms from the application database.

Once you delete an item from the Form Management window, you cannot retrieve the item. Make sure you no longer need the item when you remove the item.

Help > Trace SQL

Displays SQL trace data to help you troubleshoot forms or reports.

Help > Debug Function

Acts as an editor where you can create or modify SQL or JavaScript without opening a specific form.