Page Comparison

...

• SQLDataType: Use a data type that corresponds to a string value, such as char, nchar, varchar, or nvarchar. For large fields, use nvarchar(max) or varchar(max).
  
  
• SQLFieldSize: Use a field size greater than 256 (or max, for nvarchar(max) and varchar(max)).
  
  
• Category: If you want a large text field to appear as its own tab without a separate field caption, enter the field's Name in the Category field. If no other fields are in the same category, Aptify will create a separate tab for this field that does not include a field caption.
  • In the example shown in the figure below, the multi-line Details field is displayed on a separate Details tab.
  • Note that this functionality is only applicable if the Category value equals the field's Name and no other fields are in the same category.
    
    
• Text Interpretation Mode: This option is found on the Options tab. For plain text fields, leave this option set to None. To specify that this field stores text in rich text format, specify RTF. To specify that this field stores HTML text, set this option to HTML.
  • 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. 
    
    

...

1. Create a Link Box or Data Combo Drop-down List field and click OK to save and close the Fields record.
   • A message dialog appears automatically.
     
     
2. Click Yes to open the Aptify Entity Virtual Fields dialog.
   • You can also open the dialog at any time by clicking the Add Virtual Field... icon in the Field tab's toolbar. Note that an entity must have at least one linked field before the dialog will open.
     
     
3. If the entity's Fields list has more than one linked field, select the linked field for which you want to create a virtual field from the Linked (Foreign Key) Field drop-down list.
   • The wizard loads and displays all of the fields from the entity linked to the field you selected.
   • If the linked field you created in Step 1 is the first or only linked field in the entity, the wizard loads and displays all of the fields from that linked entity automatically and the Linked (Foreign Key) Field is grayed out.
   • If one or more virtual fields already exist for the linked field, these existing virtual fields are grayed out within the wizard. Note that you cannot modify the settings for an existing virtual field within the wizard; in this case, you need to edit the corresponding Fields record.
   • The Is Required column helps you identify which of the fields are required to save a record in the related entity. You can ignore this column when creating a virtual field for a Standard link. (this column is important for Embedded links — see Understanding the Embedded Object Model for details).
     
     
4. Select the Create column for each field for which you want to create a virtual field.
   • Typically, you want to create a virtual field for the linked entity's Name or Display Name field.
   • When you select the Create column for a field, the wizard also selects the Default In View column automatically.
     
     
5. If you do not want the Virtual Field to appear in views by default, clear the Default In View column option.
6. Enter a name for the field in the Virtual Field field.
   • Aptify's standard naming convention for virtual fields associated with a linked entity field is the name of the link box field plus _Name. For example, the virtual field for an - ApplicationID link box would be named ApplicationID_Name.
   • The name cannot contain spaces or dashes.
     
     
7. Specify the name that you want users to see as this field's column heading in a view in the Display Name field.
8. Enter a Description for the virtual field (optional).
   
   
9. Click OK to create the field.
   • The virtual field is added to the entity's Fields list.
   • If you want to review the virtual field's configuration, you can open the new Fields record.
     
     

10. Add any additional fields and save and close the entity.

    • The virtual field information is automatically added to the entity's base view.

...

• Top Area and General Tab: Configure the fields in these areas as necessary.
  
  
• Values Tab: Configure the following:
  
  • GUIType Single Select: Select Supported.
  • Value List Type: Select Static List.
  • Values Sub-Type: Add one Values sub-type record for each possible field value. In the example shown in the figure below, the static list contains the Active and Inactive values. These are the values that will appear in the drop-down list on the generated form. Note that the values enter in the value list can not exceed the SQL Field Size for the specified field. You can also localize the values associated with a standard comb drop-down list. See Localizing Standard and Data Combo Value Lists in the Admin Guide for  for more information.

Anchor
Data Combo Drop-down List Data Combo Drop-down List

Data Combo Drop-down List

...