Field administration The individual pieces of data in a record are called fields. Users can enter data in fields by using the list editor or by using a form. In form view, fields appear as fields in the form, and in list view they appear as columns of data in the table. Administrators can create new or modify existing fields. Field typesThese field types are available to administrators when creating fields or changing the type of existing fields.Valid data type changesYou can only change a dictionary entry's data type when the change does not result in data loss. Use the following guidelines to change a dictionary entry's data type.Database field typesAvailable field types and their corresponding MySQL database types. Add a new field to a tableAdministrators can add new fields to a table to store and display data.Change the field label or hintYou can change a field's label or the text that appears as a hint when you point your cursor to the field.Delete fieldsYou can delete custom fields that you created. Custom fields begin with u_. Remove the field from forms and lists instead of deleting it.UI16 and UI15 field status indicatorsIndicators are used on some fields to denote a special field type. UI11 field status indicatorsA field status indicator is a colored bar that may appear to the left of form elements.HTML fieldsAn HTML field allows users to define how field content is rendered by using HTML.Add an image fieldImage fields enable you to add images to forms.Journal fieldsThere are three types of journal field: journal, journal_list, and journal_input.Percent complete fieldsAdministrators can create percent complete fields, which accept decimal input and appear as progress bars when displayed in lists.Phone number fieldsThe E.164 phone number standard ensures that all necessary information for a phone number is included and properly formatted to successfully route an international call over a territory's public telephone network.Watch listsWatch lists allow multiple users to subscribe to notifications of a task.Wiki fieldsWikitext fields use the basic wiki markup language and support links to external URLs and to sources within the system.Choice listsA choice list is a type of field that lets the user select from a pre-defined set of choices.Define field stylesField styles allow you to declare individual CSS styles for a field in a list or form.Managing record numberingRecords in tables can be numbered automatically.Field spell checkingSpell checking can be added to any journal field, such as a Comments box or an HTML editor.Condition count widgetThe condition count widget can be activated on condition fields to display a preview of the records that would meet the current set of conditions.Reference fieldsA reference field stores a reference to a field on another table. For example, the Caller field on the Incident table is a reference to the User [sys_user] table. Create a document ID fieldYou can create document ID fields to reference any record on any table.Field normalizationField Normalization includes two features: normalization and transformation.Create a raw fieldA raw field is a custom field created by an administrator to show the original (raw) input in a field on a form after it has been normalized or transformed.Data policyData policies enable you to enforce data consistency by setting mandatory and read-only states for fields.Data lookup and record matching supportThe data lookup and record matching feature enables administrators to define rules that automatically set one or more field values when certain conditions are met.Suggestion fieldsA suggestion field allows users to select predefined text in addition to entering text.