A Fields record consists of all of the attributes of a single field within an Aptify entity. Fields records may only be created from the Fields tab Tab on an Entities record.
Top Panel
...
Also, developers will find that working with embedded links will reduce code complexity; Aptify creates an embedded Generic Entity (GE) object within the current entity that simplifies set and get operations on records in linked entities. See Embedded Objects for details.
Mode
This field appears when you set Link Type to Embedded. It specifies whether or not the embedded link in this entity is also shared by another entity. See Designing and Creating Shared Embedded Objects for information on Shared Embedded objects. This attribute supports the following options:
...
This link box specifies the stored procedure which defines the logic for updating the dynamic non-owner shared links specified in the Dynamic Sharing sub-type listing. See Designing and Creating Shared Embedded Objects for more information.
Dynamic Sharing Relationships Sub-Type Area
This sub-type control stores the list of entities and their embedded links that can share an embedded record with this owner entity as a non-owner. Each sub-type record stores the Related Entity name, the Related Entity Field (this is the embedded link in the Related Entity that links to the shared embedded object), and a Dynamic Flowdown Filter (which you can use to filter the set of records to which this shared embedded object relationship applies). See Designing and Creating Shared Embedded Objects for more information.
General Tab
The general tab of the Fields record allows the configuration of discrete database field type and size information. The values placed within this tab of the Fields record are automatically assigned to the supplied SQL Server's table schema. The General tab Tab also provides indirect linkage to other Aptify field types.
...
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 Base Fields for more information.
SQL Data Type
...
This option is only available when the SQL Data Type is set to money or smallmoney. Select the option to indicate that this money field can be expressed in multiple currencies. After selecting this option, select a Currency Type Field, which is a linked field to the Currency Types entity's ID.
If you leave this box option clear, this money field is currency - agnostic (in other words, values in this field will not be treated as having a particular currency type).
...
When creating a sub-type entity, the system uses this attribute to link to the parent entity's ID field on the ParentID field of the sub-type. It can also be used for second-level sub-types to link back to the top-level entity. See the PersonID field in the PersonCompanyFunctions sub-type entity for an example. See Multiple Filegroups for more information on sub-type entities. Finally, it is also used in some instances for top-level entities; see the OrderMeetingDetail top-level entity for an example.
...
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.
...
- When set to None, Aptify adds this field to a generated form as a standard multi-line text field. See Multi-Line Text Field for more information.
- When set to RTF, Aptify adds this field to a generated form as a Rich Text Field part. See Rich Text Field for more information.
- When set to HTML, Aptify adds this field to a generated form as an HTML Field part. See HTML Text Field for more information.
Security Tab
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 Field Level Security for details.
Group Permissions Sub-Tab
...
For Standard + Script and Script Only, the Script sub-tab stores a validation script that either supplements (for Standard + Script) or replaces the GE validation (for Script Only) for the field. Field validation scripts should be in VBScript format. See Scripts Service for information on writing scripts in Aptify.
...
- Static List: When this option is selected, an administrator manually enters one or more values in the Values sub-type list (by creating a Values record for each value; see Values Form). Also, see Standard Combo Drop-down List.
- SQL Statement: When this option is selected, an administrator enters a SQL Statement in the Values field of a Values record (see Values Form) to define the list of records and the associated fields that appear in the selection list (both in a data combo drop-down field on a form and in a multiple selection dialog, depending on the configuration of the GUI Type Single Select and GUI Type Multi Select options). When selecting this option, you may also need to specify the Linked Entity and Linked Field in the Fields record's Top Area. See Data Combo Drop-down List.
- Entity List: An entity list is a register of values that originates from a list populated with values from another entity. If this option is selected, all of the information within the Entity Link display information section of the associated Values records must be - populated (see Values Form).
...