Page tree

Versions Compared


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

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
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.

, thanks to 

's full National Language Support.

You can generate an Excel file of your system's field information by going to Setup > Tables. From there, click Generate field documentation for all tables, and complete the form that appears.

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


Hide If

Content by Label




cqllabel = "fields" and type = "page" and space = currentSpace()