0
edits
Changes
no edit summary
<span class="mceNonEditable template" id="bs_template:@@@TPL3@@@" data-bs-name="Banner-UnderConstruction" data-bs-type="template" data-bs-id="3">{{ Banner-UnderConstruction }}</span>
==General Description==
The '''Number Format''' setting on [[Custom Fields]] allows you to define how numbers in the field will be displayed.
===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===
|-!|Number Precision!|Value (Example)!|Display (Example)|-!|Whole Number123456.51>-!|Integer123456.51>-!|Comma123456.51>-!|Decimal123456.51>-!|Currency (US Dollars) 123456.51>-!|Percent (Decimal)0.5199>-!|Percent (Display Number)51.99>-!|CustomNot Applicable>}>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.
* '''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]][[CategoryFieldsCategory:Currency]][[CategoryCurrencyCategory:How]]>
