Skip to end of metadata
Go to start of metadata

Formatting is used to control how data in a "bound" value is displayed.  Since data may arrive in a variety of numeric, indicator, date, time or timestamp formats, formatting allows them to be displayed the way you want your user to see them.

Formatting ("formatting"): The type of formatting you want to use for your data. The following types are available:

  • Text
    • Trim Leading Spaces ("trimLeading"): Boolean value. If true, trims leading spaces from data.
    • Trim Trailing Spaces ("trimTrailing"): Boolean value. If true, trims trailing spaces from data.
    • Right Justify and Blank Fill ("blankFill"): Boolean value. If true, right justifies and blank fills data.
    • Right Justify and Zero Fill ("rjZeroFill"): Boolean value. If true, right justifies and zero fills data.
    • Text Transform ("textTransform"):
  • Number
    • Use 1000 Separator ("numSep"): Boolean value. If true,
    • Show Zero Balance ("zeroSep"): Boolean Value. If true, zero is shown whenever it becomes the value of this field (as opposed to just showing blank).
    • Blank Fill("numBlankFill"): Boolean value. If true, blank fills data.
    • Zero Fill("zeroFill"): Boolean value. If true, zero fills data.
    • Edit Word("edtWrd"): Applies an Edit Word. See: http:// www.publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp
    • Edit Mask("edtMsk"): Applies an Edit Mask. See: http:// www.publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/rzakc/rzakcmstedtmsk.htm
    • Currency Symbol("curSym"): Specify a currency symbol for the data (like $ for example)
    • Negative Number ("negNum"): Specify a format for displaying negative numbers.
    • Units ("units"):  Specify a Unit of Measure for the data. The following are available:
      • Pixels ("pixels")
      • Percentage ("percentage")
      • Inches ("inches")
      • Centimeters ("centimeters")
      • Millimeters  ("millimeters")
      • Em ("em")
      • Ex ("ex")
      • Points ("points")
      • Picas  ("picas")
  • Indicator
    • Indicator Format ("indFormat"): The format you wish to use for the indicator. The following are available
      • 1/0
      • True/False
      • Italic/Normal
      • Bold/Normal
      • Underline/None
      • Visible/Hidden
      • Hidden/Visible
      • Custom Values
        • For Custom values, you will have to define the On value ("customTrue") and the Off value ("customFalse").
  • Date
    • Date Format ("dateFormat"): The format you wish to use for your date, for example 01/15/13 or 2013-01-15
    • Locale ("locale"): Locale for the Date.
      • United States
      • Netherlands
      • Denmark
      • Italy
      • United Kingdom
      • France
      • Germany
      • Ireland
      • Brazil
      • Mexico
  • Time
    • Time Format ("timeFormat"): The Format you wish to use for the time, such as 1:00pm or 1:00:00.
    • Locale ("locale"): Locale for the Time. Same as the date Locales.
  • Time Stamp
    • Locale ("locale"): Locale for the Time Stamp. Same locales as time and date.
    • Time Stamp Format ("timeStampFormat"): The format you wish to use for the Time Stamp. Example:
      01/15/13 1:00 PM or 01/15/13 13:00:00
  • Special
    • Type: The type of “Special” formatting you wish to use for this field. The following are available:
      • Percentage
      • Zip Code
      • Zip Code + 4
      • Phone Number
      • Social Security Number
  • Custom
    • Custom Javascript Function ("customFunction"): Custom Javascript Function that you can define if you wish to use a different formatting than from the ones available. See Custom Javascript Formatter.
    • Custom Date/Time Pattern ("customPattern"): Custom date or time pattern you wish to use for your data type.
    • Locale ("locale"): Locale you wish to use for your custom date/time pattern. Same as previously listed locales.
Labels
  • No labels