Difference between revisions of "Custom Field Type: Text Box - Number"
Nancy Sabo (talk | contribs) |
|||
(45 intermediate revisions by 6 users not shown) | |||
Line 1: | Line 1: | ||
− | The '''Number | + | ==General Description== |
+ | The '''Text Box - Number''' field allows you to define how numbers in the field will be displayed. | ||
+ | ==Field Illustrated== | ||
+ | [[Image:placeholder.png]]<br /> | ||
+ | ''Text Box - Number, in Edit Mode (above)'' | ||
− | + | ==FieldOptions== | |
− | :{| | + | All common options:<br /> |
− | | | + | [[Custom Fields - General Information #General_Settings|General Settings]]<br /> |
− | !Number Format! | + | [[Custom Fields - General Information #Role Field Permissions and Status Field Permissions|Permissions & Availability]]<br /> |
− | | | + | [[Custom Fields - General Information #Classic Options|Classic Options]]<br /> |
− | | | + | For further information, please refer to [[Custom Fields – General Information]].<br /><br /> |
− | | | + | Options listed below are specific to this particular field type. |
− | | | + | |
− | | | + | ===Number Format=== |
− | | | + | |
− | | | + | ---- |
− | |Percent||. | + | {| class="wikitable" |
− | | | + | |- |
− | | | + | !|Number Format |
− | | | + | !|Value (Example) |
− | |Decimal|| | + | !|Display (Example) |
− | | | + | |- |
− | | | + | !|None |
− | | | + | ||123456.51 |
− | | | + | ||123456.51 |
− | | | + | |- |
− | | | + | !|Integer |
− | | | + | ||123456.51 |
− | | | + | ||123,457 |
− | | | + | |- |
− | | | + | !|Comma |
+ | ||123456.51 | ||
+ | ||123,457 | ||
+ | |- | ||
+ | !|Decimal | ||
+ | ||123456.51 | ||
+ | ||123,456.51 | ||
+ | |- | ||
+ | !|Currency (US Dollars) | ||
+ | ||123456.51 | ||
+ | ||$123,456.51 | ||
+ | |- | ||
+ | !|Percent (Decimal) | ||
+ | ||0.5199 | ||
+ | ||52% | ||
+ | |- | ||
+ | !|Percent (Display Number) | ||
+ | ||51.99 | ||
+ | ||52% | ||
+ | |- | ||
+ | !|Custom | ||
+ | ||''Not Applicable'' | ||
+ | ||''Not Applicable'' | ||
+ | |} | ||
+ | |||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | !|Number Precision | ||
+ | !|Value (Example) | ||
+ | !|Display (Example) | ||
+ | |- | ||
+ | !|Whole Number | ||
+ | ||1234.1234 | ||
+ | ||1234 | ||
+ | |- | ||
+ | !|One Decimal | ||
+ | ||1234.1234 | ||
+ | ||1234.1 | ||
+ | |- | ||
+ | !|Two Decimals | ||
+ | ||1234.1234 | ||
+ | ||1234.12 | ||
+ | |- | ||
+ | !|Three Decimals | ||
+ | ||1234.1234 | ||
+ | ||1234.123 | ||
+ | |- | ||
+ | !|Four Decimals | ||
+ | ||1234.1234 | ||
+ | ||1234.1234 | ||
+ | |- | ||
+ | !|Nearest Ten | ||
+ | ||1234 | ||
+ | ||1230 | ||
+ | |- | ||
+ | !|Nearest Hundred | ||
+ | ||1234 | ||
+ | ||1200 | ||
+ | |- | ||
+ | !|Nearest Thousand | ||
+ | ||1234 | ||
+ | ||1000 | ||
|} | |} | ||
+ | [[Category:Custom Fields]] | ||
+ | [[Category:Custom Field Types]] | ||
+ | <!--[[Image:PrecisionSetting.png|link=]] | ||
+ | [[Image:NewNumberFormatting.png|link=]]--> | ||
===Notes=== | ===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. | + | * 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 "Apply 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. | + | * 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 (,). | '''Important''': in [[edit mode]] you must use a period (.) as the decimal, even if the currency defined uses a comma (,). | ||
==See Also== | ==See Also== | ||
+ | * [[Field Formatting Options]] | ||
* [[Displaying a Number Value as Currency]] | * [[Displaying a Number Value as Currency]] | ||
* [[The Musings of Chin - Best Practice: Correct Data Formats]] | * [[The Musings of Chin - Best Practice: Correct Data Formats]] | ||
− | [[Category:Custom Fields]][[Category:Currency]] | + | [[Category:Custom Fields]][[Category:Currency]][[Category:How]] |
Latest revision as of 19:21, 21 November 2018
Contents
General Description
The Text Box - Number field allows you to define how numbers in the field will be displayed.
Field Illustrated
File:Placeholder.png
Text Box - Number, in Edit Mode (above)
FieldOptions
All common options:
General Settings
Permissions & Availability
Classic Options
For further information, please refer to Custom Fields – General Information.
Options listed below are specific to this particular field type.
Number Format
Number Format | Value (Example) | Display (Example) |
---|---|---|
None | 123456.51 | 123456.51 |
Integer | 123456.51 | 123,457 |
Comma | 123456.51 | 123,457 |
Decimal | 123456.51 | 123,456.51 |
Currency (US Dollars) | 123456.51 | $123,456.51 |
Percent (Decimal) | 0.5199 | 52% |
Percent (Display Number) | 51.99 | 52% |
Custom | Not Applicable | Not Applicable |
Number Precision | Value (Example) | Display (Example) |
---|---|---|
Whole Number | 1234.1234 | 1234 |
One Decimal | 1234.1234 | 1234.1 |
Two Decimals | 1234.1234 | 1234.12 |
Three Decimals | 1234.1234 | 1234.123 |
Four Decimals | 1234.1234 | 1234.1234 |
Nearest Ten | 1234 | 1230 |
Nearest Hundred | 1234 | 1200 |
Nearest Thousand | 1234 | 1000 |
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 "Apply Format in Edit Mode" is selected in the custom field settings.
- Any currency defined by 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 (,).