If you have a comment on this topic, contact Aptify Documentation. If you want to return to the Aptify Community Site, please click here.

Applying Field Level Formatting in a List View

In addition to formatting the entire List view's row color and font, you can configure the formatting on a field-by-field basis, as necessary.

Follow these steps to modify the formatting for a single field in a List view:

  1. Click the Format tab in the Create View or View Properties dialog and select the Use Custom Formatting for this View option.
  2. Click the Field Level Formatting tab.
  3. Select the Format Fields Individually? option.
    • A list of fields from the view's service appear in the dialog.

  4. Select the field whose formatting you want to modify and click the Format button.

    Field Level Formatting Dialog
    • The Format Individual Field dialog appears and reports the font, border, and display settings for an individual field.

  5. To modify the font settings for field, click the Settings... button on the Font tab to open the Font dialog.
    • The Underline option is grayed out on the Font sub-tab. This feature is not currently available.
      Format Individual Field Dialog

  6. Configure the following options in the Font dialog:
    • Font: Select the font in which the text will be displayed.
    • Font style: Select the text's style. Options include Regular (no formatting), Italic, Bold, and Bold Italic.
    • Size: Select the text's size. Options range from 8 point to 72 point. Note that you can only select from the values displayed in the size list.
    • Script: You can select the font's script from the list of available script types. Note that this option is not currently supported. A font uses its default script type (typically Western).
    • For example, you could set the Font to Times New Roman, the Font style to Bold, and the Size to 10, as shown below. The Sample box provides an example of how the text will look using your current selections.
      Font Settings Dialog - Individual Field

  7. Click OK to return to the Font sub-tab.
  8. To change the text color, click the ellipsis (...) button in the Text Color field to open the Color dialog. Then, choose the new text color and click OK.
  9. To change the field's background color, click the ellipsis (...) button in the Background field to open the Color dialog. Then, choose the new background color and click OK.
    • See Selecting Dashboard Colors for information on using the Color dialog.
    • A preview of the settings you selected appear in the Font field.
      Font and Back-ground Settings Preview

  10. Click the Border tab.
  11. Select one of the following styles from the Border Style drop-down list:
    • Default: Each cell uses a standard border line of the width and color specified on the bottom and right side of the field only. This is the default setting.
    • None: The field has no border lines. Note that the values of the Border Color and Border Width fields are ignored when the Border Style is set to None.
    • Flat: This setting displays a border similar to the Default border style.
    • Double: Each cell uses a standard border line of the width and color specified on all four sides.
    • Raised: This option uses a raised effect to emphasize the selected record. (The field's cell within the selected row appears larger and slightly to the right of the other cells in the same column). A dark gray border appears across the bottom and right side of each cell. The Border Color and Border Width options are not applicable for this Border Style so these fields are removed from the dialog.
    • Inset: This option uses a raised effect to emphasize the selected record. (The field's cell within the selected row appears larger and slightly to the right of the other cells in the same column). A dark gray border appears across the top and left side of each cell. The Border Color and Border Width options are not applicable for this Border Style so these fields are removed from the dialog.
    • Groove: This option uses a raised effect to emphasize the selected record. (The field's cell within the selected row appears larger and slightly to the right of the other cells in the same column). A dark gray border appears across all four sides of each cell. The Border Color and Border Width options are not applicable for this Border Style so these fields are removed from the dialog.
    • Fillet: This option uses a raised effect to emphasize the selected record. (The field's cell within the selected row appears larger and slightly to the right of the other cells in the same column). A dark gray border appears across all four sides of each cell, although there is a small space between the column dividers and the cell borders along the top and left sides. The Border Color and Border Width options are not applicable for this Border Style so these fields are removed from the dialog.
    • Dotted: Each cell uses a dotted border line of the color specified on the bottom and right side of the field only. Note that the Border Width option is not available when this Border Style is selected.

  12. Select a Border Color (if applicable, depending on the Border Style selected).
    • Click the ellipsis (...) button to open the Color dialog.
    • See Selecting Dashboard Colors for information on how to use the Color dialog.

  13. Select a Border Width (if applicable, depending on the Border Style selected).
    • This field specifies the width of the field's border, in pixels.
      Border Format

  14. Click the Display Format tab.
  15. Select a Text Alignment option:
    • Default: The text is aligned with the left side of the column.
    • Left: The text is aligned with the left side of the column.
    • Right: The text is aligned with the right side of the column.
    • Center: The text is centered within the column.

  16. Clear the Wrap Text option if you do not want the field contents to automatically wrap to the next line if the contents exceed the width of the column.
    • By default, the Wrap Text option is selected when you click the Display Format tab.
    • When wrapping text, you may need to increase the height of the rows to see the wrapped text. See Resizing Rows for details.

  17. To specify a particular format for the field's contents, select the Custom Text Formatting option and select a format from the Category list (which appears automatically when you select the Custom Text Formatting option). When you select a category from the list, a corresponding sample of the text format you selected appears under the Sample heading. The available formats are:
    • General: This is the default setting. The field does not use a particular text format.
      Display Format Tab

    • Number: Use this format for numbers. You can also specify the number of decimal places to display, whether or not to display commas to separate thousands (this corresponds to the Use 1000 Separator select option), and the format for negative numbers (negative (-) sign or parentheses).

      Custom Text Format Categories

    • Currency: Use this format for fields in dollars or another currency. The currency depends on the default currency specified in your computer's regional settings (accessible at Start > Control Panel > Regional and Language Options).
    • Date: Use this format for date fields. Note that dates are displayed in the format specified in your computer's regional settings (accessible at Start > Control Panel > Regional and Language Options).
    • Time: Use this format for time fields. Note that the system uses the time format specified in your computer's regional settings (accessible at Start > Control Panel > Regional and Language Options).
    • Date and Time: Use this format for fields that display the date and time. Note that the system uses the date and time formats specified in your computer's regional settings (accessible at Start > Control Panel > Regional and Language Options).
    • Percentage: Use this format for fields that corresponds to percent values. You can also specify the number of decimal places to display, whether or not to display commas to separate thousands (this corresponds to the Use 1000 Separator option), and the format for negative percents (negative (-) sign or parentheses).
    • Custom: This option is for advanced users. Advanced users can specify a custom format for a number or date field. This option uses Microsoft Visual Basic's Format function to create a user-defined numeric or date/time format. Refer to Microsoft's MSDN (https://msdn.microsoft.com/default.aspx) for information on how to construct a style argument for the Format function. Refer to Microsoft's MSDN (https://msdn.microsoft.com/default.aspx) for information on how to construct a style argument for the Format function.

  18. Click OK twice to load the view with the format settings you specified for the individual field.

View with Modified Fonts in Individual Field

Copyright © 2014-2017 Aptify - Confidential and Proprietary