The columns below appear on many field tables. They are field metadata: they control how Hop converts a string to a typed value, and how a typed value is written back to a string. They do not change the value stored in a database.
| Column | Description |
|---|---|
Format / Conversion mask |
Number or date pattern used to parse and print the value. See Formatting numbers and dates. |
Length |
String: maximum characters.
Number / BigNumber: significant digits.
Integer: display width (leading zeros when writing).
Date: length of the printed string (for example |
Precision |
Decimal digits after the radix for Number and BigNumber. Not used for String, Date or Boolean. |
Decimal |
Character that separates the integer and fractional parts.
|
Group / Grouping |
Thousands grouping symbol.
|
Currency |
Optional currency symbol used when the format mask contains a currency sign ( |
Value |
A single constant, entered as a string and parsed with Type, Format, Decimal, Group and Currency. Not a comma-separated list of values. Use Data Grid when you need several different rows. |
Set empty string? |
When the constant is empty, emit an empty string ( |