Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
field_jspx_html
field_jspx_html
A field is both a place in a record to input a specific type of information, and the information itself that is then stored in that part of a record.Agiloft
Companyname
supports fields of many different data types, such as text, single choice list, multi-choice list, integer, floating (decimal) point, telephone, email, URL, attached file, date, time, date/time, elapsed time, currency, and so on, and each field can be provided with validation rules appropriate Text, Multi-Choice, Integer, File with Versioning, Email, URL, Date, Currency, and so on. Each data type can be configured with settings and requirements specific to its type. For instance, an integer Integer field might require a value between 1 and 100. A , and a Currency field may be shown with the currency symbol before or after the value. For a full list of field types is provided in data types, see List of Data Types.

Each field has a " field name " and a " field label". The  The field name is the name of the column stored in the database tablesystem's database, and it cannot contain spaces or most special characters. The field label is the value that users see through the GUI. Labels on the interface, and it can contain spaces , for example Customer Name.Agiloft provides full National Language Support, meaning that field labels can and special characters. It can also be translated into multiple foreign languages so that the user will see labels in sees the language specified by their browser settings.

To review the fields for a particular Table and add, modify, or delete fields, go to Setup/Tables/, select the Table to edit, then select the Fields tab. Mouse-over "New" to view the drop-down of all available data types to choose from.

A new progress window with progress indicators will pop-up when an administrator adds a new column to a table. This window will give administrators better indications of duration and progress of this operation.

There is a set of Default Fields for each table:
Image Removed, thanks to 

Companyname
's full National Language Support.

For more information about field functionality and specific data types, see the following articles.

Hide If
displayprintable

Content by Label
showLabelsfalse
max5
spaces

...

PROD
showSpacefalse
sortmodified

...

reversetrue
typepage
cqllabel = "fields" and type = "page" and space = currentSpace()
labelsfields