There are a number of different types of field, listed below:
- COMBOX/OPEN LIST: defined as a combo box corresponding to a list with no predefined values
- COMBOX/CLOSED INDEXED LIST: defined as a combo box corresponding to a list in which predefined values are defined when the field is configured from the administrator interface
- CHECKCOMBOBOX/PREDECESSOR: a list from which the user can select several values, associated with the record in the current table
- CHECKCOMBOBOX/CLOSED INDEXED MULTIPLE LIST: identical to a CLOSED INDEXED LIST COMBOBOX, with the option of selecting several values (limited to 4000 characters)
- RADIOBUTTON: identical to COMBOX/CLOSED INDEXED LIST, displayed as a radio button in forms
- The Edit, RichEdit (using character attributes) and Memo fields are multi-character fields linked to the description: they differ in the number of character limits.
- EDIT/URL: a 100-character string describing a valid URL
- RICHEDIT: an RTF text, used to nest Word™ or Excel™ styled text.
- MEMO: limited to 500 or 4000 bytes depending on configuration. Single characters count as 1 byte and special/accented characters count as 2 bytes
- MEMO UNLIMITED: an unlimited string of characters.
- EDIT/TEXT: a string of 100 characters
- DATE: a date, displayed in French notation JJ MMM AAAA
- DATE TIME: combined date and time display
- DATE/TIME: display time only
- IMAGE: a PNG/JPG file (only accepted formats)
- CALCULATED FIELD: the calculated field corresponds to a formula that will execute actions on one or more other fields in the data source. This field cannot be modified by the user; it is read-only.
Information
For Edit, RichEdit and Memo fields, an error message is displayed at the bottom of the field in the input form when the authorised character limit is exceeded.