Field Types

The following workspace field types are supported:

• Character (single or multiple line)—This type of field can contain any type of data, such as alpha, numeric, or special characters.  Single-line character fields accept one line of data, while multiple-line character fields accept an unlimited number of lines of data.  There is no effective limit on the amount of text in a field.
• Integer—Accepts integers.
• Real Number—Accepts positive integers or decimal numbers (no negative numbers).  If FootPrints is running on MS SQL Server or MySQL, you will be asked to include Total Digits and Total Decimal Places for the real number when configuring the field.   Total Digits is the total number of digits in the number and Total Decimal Places is the number of digits to the right of the decimal. If an unacceptable value is entered into a real number field, such as a value that includes alphabetical characters, has too many digits after the decimal place, or is too wide for the field as it has been configured, FootPrints generates a warning before you can leave the page.

  When creating a new real number field, MS SQL versions of FootPrints asks for the total digits and total decimal places on the field maintenance page. This is necessary since SQL Server real numbers default to four decimal places, which might not be what you want displayed if you are entering currency information.

• Date—Accepts valid dates (format based on system or user preference).
• Date-Time—The user can select both a date and a time for this field type. Can optionally be linked to the Calendar. A default link to the calendar(s) can be changed at the time of Issue creation by the Agent.  In addition, the field can be configured as a link to the personal calendar or personal and workspace calendars by default.  by clicking the radio button for either linking to the personal calendar or linking to the personal and workspace calendars when the Issue is created. To select the current date-time, click the checkbox provided with the field.

• Drop-down—Offers a pre-defined drop-down list of choices from which the user chooses one of the options.
• Multi-select—Allows the user to select multiple choices from a pre-defined list.
• Checkbox—Offers a checkbox for users to select in the Issue form. In searches, reports and on the Details screen, the values "On" and "Off" are displayed, or alternate values can be defined. Mandatory/optional permissions do not apply to checkboxes; this field can be checked or left unchecked by the user.
• Web site—Accepts URL addresses (of the form http://server.name.com).  Appears as a hypertext link on the Details page of an Issue.
• FTP—Accepts fully-qualified FTP addresses (of the form ftp://ftp.sitename.com).  Appears as a hypertext link on the Details page of an Issue.
• Email Address—Accepts Email addresses. Appear as a hypertext link on the Details page of an Issue.
• Add Tab/Section—Adds a section header or tab, depending on whether you are using the expand/collapse or tabs interface. When a tab or section is added, it is automatically placed at the end of the set of tabs or sections. The administrator must use the arrow keys to move the tab or section into its appropriate position on the page and must also move the fields to be associated with that tab or section individually.