Formatting

Owned by Former user (Deleted)
Last updated: Sep 12, 2023 by Jessica Tomkins
2 min read



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 ("zeroBalance"): 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. 

    • Edit Mask("edtMsk"): Applies an Edit Mask. 

    • 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.