When adding a new field, what field types (such as character, numeric, or alp

0 Likes

Problem:

When adding a new field, what field types (such as character, numeric, or alphabetical) can be used?

Resolution:

The available data/field types are:


  • Single-line text (alpha)
  • Multiple-line text (alpha)
  • Numeric (numbers only)
  • Check box (Boolean)
  • Radio button (set of Booleans)
  • Combo box (any object type -- see below)
  • List box (any object type - see below)
  • Date
  • Date/time
  • Date/time span (a single field with two sets of date/time field - for ranges and such)

Combo boxes and list boxes can be associated with any other item type in the database. For example, you can have a combo box that associates with the "Project" item type. In this case, the combo box displays the default abbreviation for each of the Project items in the database. A Project item itself can be made up of any of the field types listed above.

Old KB# 10759
Comment List
Related
Recommended