The field catalogue lists all fields in the database, structured per database table. Users with administrative authorisations can change or add to the field labels and also the help text (tooltip) for real database fields.
Note: Changes to the field catalogue usually take effect after restarting the application.
- Go to the Configurations tab in the function bar and select Catalogues > Fields.
- An overview of all database tables will open.
- Left-click the table you want and and Confirm your selection.
- A list of all fields in this table will open.
- Double-click any field to edit the value.
- Changed labels will appear in the user interface after restarting the application.
- Changed tooltips will appear on mouseover.
- Save your input by clicking on the icon in the top left-hand corner of the input window.
Term | Description |
Table |
Table name |
Technical name |
Unchanging technical name of the field. Many configurations are based on the technical name |
Field |
Field name, name in the interface |
Data type |
Field property, type of output - Boolean (truth value) - Longint (integer without decimal places) - String80 (character string with specification of the maximum number of characters) - Real (number with possible decimal separators) - Text (text format) - Date (date format) - Picture (picture format) - Time (time format)
|
Type |
Field type Database field Calculated field Added field
|