The '''Number Format''' setting on [[Custom Fields]] allows you to define how numbers in the field will be displayed.
==Field Illustrated==<br />[[Image:placeholder.png]]<br /><br />''Text Box - Number, in Edit Mode (above)''
{{FieldOptions}}
'''Mandatory'''===Validation===
----
* '''Mandatory''': Selecting this option means that this field is required and must be completed.
* '''Appear Mandatory''': Selecting this option means that this Makes the field appear as though it is a required and must be completedfield. Typically used in conjunction with browser scripts, JavaScript Validation or Submit Logic that perform validation.>
* '''Appear Mandatory''': Makes the field appear as though it is a required field. Typically used in conjunction with browser scripts, JavaScript Validation or Submit Logic that perform validation.
* '''Custom Validation''':
* '''Failed Validation Message''': Message displayed if validation fails.
===Feature Options===
----
* '''Track Changes''':
===Value Storage===
Feature Options * '''Track Changes''' : {{FieldPermissions}} Value Storage ----* '''From Custom Field(s)''' :
* '''To Custom Field''':
==Permissions & Availability Tab==
{{FieldPermissionMatrix}}
{{FieldPermissions}}
{{VisibilityCondition}}
{{On New Record}}
{{ClassicOptions}}
[[Category:Custom Fields]]
[[Category:Custom Field Types]]
<!--[[Image:PrecisionSetting.png|link=]]<br />[[Image:NewNumberFormatting.png|link=]]-->
===Notes===
* The
'''Number Format'''
setting applies in
[[view mode]]
, or when the values are displayed in a
[[Web Page View]]
,
[[Report]]
,
[[MS Word Merge]]
,
[[List View]]
, etc.
* Currency formatting will be applied when the record is in
[[edit mode]]
only if the setting "Show Currency Format in Edit Mode" is selected in the custom field settings.
* Any currency defined by
[http://en.wikipedia.org/wiki/ISO_4217 ISO 4217]
can be shown by using the appropriate three-letter currency code. For example, if
''Currency-JPY''
(for Japanese Yen) is entered into the Number Format setting, the entered value of
'''12'''
will be displayed as
'''¥12'''
.
'''Important'''
: in
[[edit mode]]
you must use a period (.) as the decimal, even if the currency defined uses a comma (,).==See Also==
*
[[Field Formatting Options]]
*
[[Displaying a Number Value as Currency]]
*
[[The Musings of Chin - Best Practice: Correct Data Formats]]
|-here to learn why this feature is a benefit to your organization.>} ¶ Category:Custom FieldsCategory:CurrencyCategory:How>