...
Enter a culture string to use as the display name of the field in the Display Culture String field if you want to localize this field name on a user-by-user basis (based on a user's assigned Culture). See Localization in the Admin Guide for Using Localization Administration for details.
Linked Entity
The entity to which the current field links. Used when the current field acts as a foreign key to another entity. When used in conjunction with Linked Field, this creates a link box field.
...
Selection of a defined base field from the list defaults the rest of the field definition to the parameters defined for the base field. See Using Base Fields for for more information.
SQL Data Type
...
- Password:Fields defined with the extended type of Password displays a series of asterisks on a form rather than plain text. This is designed to mask the password to prevent authorized access. Note that following when working with a password field:
- The Password extended type functionality is only applicable for a Text Field. If your field's size is greater than 255 characters, the Aptify Baseline Form Template Generator will create a multi-line text field that displays the field's contents in plain text. In this case, use the Visual Designer to remove the multi-line text field and replace it with a text field that uses the Password extended type. See Modifying Field Layout with the Visual Designer in the Admin Guide for for information on the Visual Designer.
- Even though a Password field's value is masked on the form, the value will still show up as plain text within a view. Therefore, to adequately protect passwords, Aptify recommends that you encrypt any Password fields that you add to the system in addition to setting the Extended Type to Password. See Field Level Encryption for information on encrypting a field.
...
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.
...
If your organization has configured Aptify to display localized content to users, this field specifies a Culture Strings record that provides localized versions of the Help Text content. See Localization in the Admin Guide for Using Localization Administration for more information.
Help URL
...
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.
...
This tab configures the field's security settings. Field Level Encryption setting appears by default. Additional options and tabs appear when Field Level Security is enabled at the entity level. See Managing Field Level Security in the Admin Guide for Settings for details.
Group Permissions Sub-Tab
...
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 in the Admin Guide for for details.
Security Key
Security Key sets the key used to encrypt the field. This option is only available when the Encrypt Data option is selected. This field links to the corresponding Security Key record.
...
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.
Anchor _joinType _joinType
Join Type
| _joinType | |
| _joinType |
The Join Type field is only available when Virtual Field Type is set to Joined. The value selected in this field determines the type of join. Options available are:
...