Difference between revisions of "Custom Field Type: Text Box - Number"
From SmartWiki
Nancy Sabo (talk | contribs) |
|||
(24 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | |||
− | |||
==General Description== | ==General Description== | ||
− | Text | + | The '''Text Box - Number''' field allows you to define how numbers in the field will be displayed. |
==Field Illustrated== | ==Field Illustrated== | ||
− | [[Image:placeholder.png | + | [[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 /> | ||
+ | [[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=== | ||
− | + | ---- | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
Line 89: | Line 22: | ||
!|Value (Example) | !|Value (Example) | ||
!|Display (Example) | !|Display (Example) | ||
+ | |- | ||
+ | !|None | ||
+ | ||123456.51 | ||
+ | ||123456.51 | ||
|- | |- | ||
!|Integer | !|Integer | ||
Line 118: | Line 55: | ||
||''Not Applicable'' | ||''Not Applicable'' | ||
|} | |} | ||
− | + | ||
{| class="wikitable" | {| 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 Fields]] | ||
[[Category:Custom Field Types]] | [[Category:Custom Field Types]] | ||
− | |||
− | |||
<!--[[Image:PrecisionSetting.png|link=]] | <!--[[Image:PrecisionSetting.png|link=]] | ||
[[Image:NewNumberFormatting.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 " | + | * 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. 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'''. | * 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'''. | ||
Line 192: | Line 111: | ||
* [[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:How]] | [[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 (,).