...
When specified, the contents of this Help Text field appear in the tool tip. If not specified, the contents of the field's Description appears in the tool tip window, if different from the field's Display Name. If the Description is blank or matches the Display Name, or if the Help Text is blank, the tool tip indicates that no specific help is available for the field.
...
When a user clears the option from the In Table option, a Virtual Field tab appears on the Fields form. See Virtual Field Tab.
...
Only one field in the entity may be designated as the Is Name field. The administrator determines which field in the entity best characterizes the record and designate the field as Is Name. The system uses this field to represent the record in graphical user elements, such as the link box control. Note that when you select the Is Name Field option, the system automatically clears the Allow Null option on the General tab and selects the Is Required option on the Validation tab. In general, Is Name fields are required and do not support Null values.
...
Selecting the Is Sequence attribute specifies that this field is a Sequence field, which is used to sort records in an order other than by primary key. Prior to version 4.0, a Sequence field was required for sub-type entities.
...
The following security settings appear on the Options sub-tab:
Encrypt Data
Selecting this attribute enables data encryption for this field. When enabled, the Security Key field becomes available. See Managing Field Level Encryption for details.
...
Selecting this attribute enables In Place Editing at the field level. This is only applicable if In Place Editing is enabled at the entity level (on the Entity's Security > Options tab). Once enabled at the field level, youcan specify Edit In Place permissions for users and/or groups in the field's User and Group Permissions records (under the User Permissions and Group Permissions sub-tabs).
User Permissions Sub-Tab
...
- None: Selected by default. This value is the default used for fields that are not virtual fields. Virtual fields should never be set to this type.
- Manual: User must manually modify the Base View for the entity as necessary to accommodate this field.
- Joined: The virtual field displays a value from a field defined in a joined table. See Joined Virtual Field for information on how to create a Joined Virtual Field.
- Calculated: Indicates that the virtual field is calculated from other values, including values from fields in other entities. The information is not stored in the database table but the relevant information is added to the entity's Base View.
- Computed: Indicates that the virtual field is calculated from other values within the same table. Unlike a Calculated field, which is calculated within an entity's Base View, a Computed field is calculated at entity's primary database table. Note that a Computed field is not a physical field in the table even the Computed field appears in the table details when viewed using SQL Server Management Studio. You cannot create a constraint or an index for a computed field. (Aptify does not create Persisted computed columns.) Also, if you are adding a Computed field to an entity that has multiple base tables, the computed field and all of the fields that are referenced in its calculation must be in the entity's primary base table.
...
The Joined Field field is only available when Virtual Field Type is set to Joined. The list displays all fields in the entity selected in the Joined Entity field. The field selected indicates that this is the field in the joined entity that virtual field should display.
Foreign Key
The Foreign Key field is only available when Virtual Field Type is set to Joined. The Foreign Key is the field within the current entity that links to the primary key of the Joined Entity.
...