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.
There is a set of Default Fields for each table:'s full National Language Support.
, thanks to
For more information about field functionality and specific data types, see the following articles.
- Working with Fields: Learn general instructions and tips for working with fields.
- List of Data Types: Review a complete list of data types in the system.
- Choice Lists: Use the Choice or Multi-Choice data types to select choices in a record.
- Date and Time Fields: Display date and time values.
- Linked Fields: Create links between two or more records using one of the various linked field types.
- File with Versioning Fields: Attach files to a record and optionally track the file's version.
- Relationship Diagram Fields: Create a visualization that represents links between records.
- Heat Bars: Show proportions and progress related to a record.
- Surveys and Questionnaires: Create surveys and questionnaires using a family of data types.
- Variable Formula Field: Create queries and formulas, which may include system variables, to produce a result.
- Visibility Dependent Fields: Hide or show fields based on conditions.
- History Fields: Track the edits and events that occur in a record.
- Singleton Check: Visually represent a true/false toggle as a single checkbox.
- Image with Versioning: Attach image files to a record and optionally display them on table views.
|Content by Label|
|cql||label = "fields" and type = "page" and space = currentSpace()|