<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.
==Field Illustrated==<br />[[Image:placeholder.png]]<br /><br />''Text Box - Number, in Edit Mode (above)''
{{FieldOptions}} ==General Description=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 />The ''Not Applicable''<br />>} |-!|Number Precision!|Value (Example)!|Display (Example)|-!|Whole Number123456.51>-!|Integer123456.51>-!|Comma123456.51>Layout -!|Decimal123456.51>-!|Currency (US Dollars) 123456.51>-!|Percent (Decimal)0.5199>-!|Percent (Display Number)51.99>-!|CustomNot Applicable>}>Validation<br />* Tabbed Section'''Mandatory''': Selecting this option means that this field is required and must be completed field on [[Custom Fields]] allows you to create a tabbed section.
* ==Field Illustrated==<!--[[Image:placeholder.png]]<br />''Layout - Tabbed Section, in '''Edit Mode (above)''Appear Mandatory''': Makes the field appear as though it is -->==Set Up==First, you must decide what custom fields you want to be under a required fieldtab. Typically used in conjunction with browser scriptsSecond, JavaScript Validation or Submit Logic that perform validation.* you must rearrange those custom fields by editing their [[Display Order]] to value(s) ABOVE '''Layout - Tabbed Section'Custom Validation''':s display order.<br />* You may separate tabs by creating multiple '''Failed Validation MessageLayout - Tabbed Section''': Message displayed if validation failswith display order values in between the custom fields.
Feature ==Field Options==All common options:<br />[[Custom Fields – General Information#General_Settings|General Settings]]<br />* '''Track Changes''':{{FieldPermissions}}Value Storage[[Custom Fields – General Information#Permissions & Availability|Permissions & Availability]]<br />[[Custom Fields – General Information#Classic Options|Classic Options]]<br />* '''From For further information, please refer to [[Custom Field(s)''':Fields – General Information]].<br /><br />Options listed below are unique and specific to this particular field type.
* '''To Custom FieldValues''':- sets the number of columns within the section. For usability and accessibility purposes, we recommend that this be left with a value of 1.
==Permissions & Availability Tab==<br />{{FieldPermissionMatrix}}<br />{{FieldPermissions}}<br />{{VisibilityCondition}}<br />{{On New Record}}{{ClassicOptions}}[[Category:Custom Fields]]<br />[[Category:Custom Field Types]]<!--[[ImageCategory:PrecisionSetting.png|link=]]<br />[[Image:NewNumberFormatting.png|link=]Custom Fields]--><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]]|-here to learn why this feature is a benefit to your organization.>} ¶ Category:Custom FieldsCategory:CurrencyCategory:How>
