0
edits
Changes
no edit summary
==General Description==
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}}
===Number Format===
----<br />{| class="wikitable"<br />|-<br />!|Number Format<br />!|Value (Example)<br />!|Display (Example)<br />|-<br />!|None<br />123456.51<br />>-<br />!|Integer<br />123456.51<br />>-<br />!|Comma<br />123456.51<br />>-<br />!|Decimal<br />123456.51<br />>-<br />!|Currency (US Dollars) <br />123456.51<br />>-<br />!|Percent (Decimal)<br />0.5199<br />>-<br />!|Percent (Display Number)<br />51.99<br />>-<br />!|Custom<br />''Not Applicable''<br />>}
{| class="wikitable"<br />|-<br />!|Number Precision<br />!|Value (Example)<br />!|Display (Example)<br />|-<br />!|Whole Number<br />123456.51<br />>-<br />!|Integer<br />123456.51<br />>-<br />!|Comma<br />123456.51<br />>-<br />!|Decimal<br />123456.51<br />>-<br />!|Currency (US Dollars) <br />123456.51<br />>-<br />!|Percent (Decimal)<br />0.5199<br />>-<br />!|Percent (Display Number)<br />51.99<br />>-<br />!|Custom<br />''Not Applicable''<br />>}
===Validation===
----<br />* '''Mandatory''': Selecting this option means that this field is required and must be completed.
* '''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===
----<br />* '''Track Changes''':
<span class="mceNonEditable template" id="bs_template:@@@TPL3@@@" data-bs-name="Banner-UnderConstruction" data-bs-type="template" data-bs-id="3">{{ Banner-UnderConstruction }}</span>
===Value Storage===
----<br />* '''From Custom Field(s)''':
* '''To Custom Field''':
==Permissions & Availability Tab==<br />{{FieldPermissionMatrix}}<br />{{FieldPermissions}}<br />{{VisibilityCondition}}<br />{{On New Record}}
{{ClassicOptions}}
[[Category:Custom Fields]]<br />[[Category:Custom Field Types]]
<!--[[Image:PrecisionSetting.png|link=]]<br />[[Image:NewNumberFormatting.png|link=]]--><br />===Notes===<br />* 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.<br />* 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.<br />* 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==<br />* [[Field Formatting Options]]<br />* [[Displaying a Number Value as Currency]]<br />* [[The Musings of Chin - Best Practice: Correct Data Formats]]
{| class="wikitable"<br />|-<br />[[Image:Why.jpeg|link=|50px]]<br />here to learn why this feature is a benefit to your organization.<br />>}
[[Category:Custom Fields]][[Category:Currency]][[Category:How]]