This page describes the characteristics of each Caspio Bridge format type. You can define format types for the entire DataPage through a Localization and/or format each field separately when configuring DataPage fields.

Format TypeDescription
NumberDefines the presentation of numeric values.

Decimal symbolA period, a comma, a space or your custom symbol to separate the integral and decimal part.
Digits after decimalThe number of digits after the decimal separator. If the underlying value in the table has greater precision, the value is rounded.
Digit groupingA period, a comma, a space or your custom symbol to separate the hundreds from thousands and so on.
Negative symbolNormally a minus.
Negative number formatFive patterns are provided, where “n” is the value and “-” will be replaced by your custom negative symbol, if any.

Applies to: Number, AutoNumber, Text

CurrencyDefines the presentation of numeric values representing money amounts.

Decimal symbolA period, a comma, a space or your custom symbol to separate the integral and decimal part.
Digits after decimalThe number of digits after the decimal separator. If the underlying value in the table has greater precision, the value is rounded.
Digit groupingA period, a comma, a space or your custom symbol to separate the hundreds from thousands and so on.
Currency symbolIn addition to the three major currency symbols, each region’s custom symbols are available. If needed, provide your own custom symbol by entering it in the field on the right.
Positive currency formatFour patterns are provided, where “n” is the value.
Negative currency formatSixteen patterns are provided, where “n” is the value.

Applies to: Number, AutoNumber, Text

PercentDefines the presentation of numeric values representing money amounts.

Decimal symbolA period, a comma, a space or your custom symbol to separate the integral and decimal part.
Digits after decimalThe number of digits after the decimal separator. If the underlying value in the table has greater precision, the value is rounded.
Digit groupingA period, a comma, a space or your custom symbol to separate the hundreds from thousands and so on.
Percent symbolNormally the % sign.
Positive percent formatThree patterns are provided, where “n” is the value.
Negative percent formatThree patterns are provided, where “n” is the value and “-” will be replaced by your custom negative symbol, if any.

Applies to: Number, AutoNumber, Text

Long dateDefines the long date pattern. Choose one of the many patterns available for the selected region or provide your own format. When specifying a custom format, choose one of the provided patterns first so that it appears in the custom field on the right. Then, choose custom in the end of the list to make the custom field editable, and modify the pattern as necessary. Applies to: Date/Time, Text
Short dateDefines the short date pattern. Choose one of the many patterns available for the selected region or provide your own by choosing customApplies to: Date/Time, Text
TimeDefines the time pattern. Choose one of the patterns available for the selected region, and provide your own AM and PM symbols if desired. Applies to: Date/Time, Text
Yes/NoDefines the appearance of fields that have two values only: yes or no. They can be represented as Yes/No, Y/N, 0/1, True/False, or your custom symbols. In addition, you can select distinct colors to mark yes and no values. Applies to: Text, Number, Date/Time, Yes/No