Identification
Order - Order of fields in the table. The order or sequence of fields in a table is important to get correct calculation results.
Table - Area from which the List will fetch fields.
Field - Table field name, if no other is assigned in the table's long field
DB field name - Override the field name in the database. If this property is left blank the field name will be used, otherwise the name defined here is used. This field has a character limit greater than what can be given to the field.
Display name - Field designation. Intelligible name for the field (and which will be used by default when the field is inserted in a form).
Data type - Field Type (Integer, String, Date, Foreign Key, etc)
Relationship - Area from which the List will fetch fields.
Related field - Table field name, if no other is assigned in the table's long field
Width - Number of elements the field will have. For example, for a String it will be the number of letters and for a numeric field it will be the number of digits.)
Decimals - Field decimals
Default (F11) - Default value for the field: field type + field value Example: N 4 (Numeric field of value 4)
Value - Default value of the field in case the default type is fixed.
Required - Check this field if the value of this field cannot be null.
Unique - Check if this field cannot be duplicated. Use the non-duplication prefix if it is necessary that the duplication check only takes effect on some records.
Human key - Defines that this field is recognized by a human as a record identifier for choices and messages. A numeric value greater than zero defines the importance of this field in that identification.
Align - Field alignment type. If right-aligned, fill the left with spaces.
Save history - Area from which the List will fetch fields.
Formula
Write conditions
Constraints
Filling Rule - Field fill rule type. Allows you to define validation and formatting rules.
Prefix to be unique (F11) - It must be filled in with the name of the field that serves as a non-duplication filter. F11 for suggestions
Warning: If you define a prefix field to be unique, it will allow duplicate entries to be inserted/edited when the value of the prefix field is empty.
CAV - Type of inclusion of this field in the Advanced Query.
Name for Query Assistant - Description used for Advanced Query (CAv)
Clear on duplication - When duplicating a record, this field will be created with its value empty.
Display conditions
User's help
Properties
Access level - Minimum access level that the Genio user will have to have to be able to modify the values of this field.
Don't send to MQ - MQ is a queue with all fields that will be sent for synchronization between different platforms (server and client, for example). When selecting this option, the data in this field will not be sent to the server.
Audit - Indicates whether the field creates a log record when its content is changed. This log will have the information of the old value, new value, date and user of the operation
No sync - If checked, this field does not go to the replication script.
Digital signature - When checked, it indicates that this field is part of the digital signature.
Check spelling - When checked, it indicates that the spelling of this field is checked.
Used in routine - When checked, it indicates that this field is used in a manual routine.
No versioning - Allows not to use document versioning
Sorting - Indicates that this field will be used to maintain and force table sorting in reorder controls.
Formulas
Placeholder - The placeholder is intended to describe the expected value to be entered into a text input field. The placeholder is displayed in the input field before the user enters the text.
Formula type - Type of formula to use to calculate the value of this field.
Implementation of the formula - Where the field value will be calculated and how it will update to other locations.
Formula (F11) - Construction of the formula to be used to calculate this field. Press F11 to get help building the formula
Condition to prevent formula recalculation (F11) - Condition that, happening, causes registry value not to be recalculated
Condition to show the field (F11) - This field is only visible when the condition is true.
Condition to block the field (F11) - This field is blocked whenever the condition is true.
Condition to fill the field (F11) - It only allows filling data in the field if the condition indicated here is evaluated as true. If the field contains data and the condition due to external factors is evaluated as false, the field value is nullified.
Inhibit - When checked, the feature associated with this feature is removed whenever the client has that feature. When there is no feature associated with this feature, this field is ignored.
Properties