Changes

Jump to: navigation, search

Custom Field Type: Text Box - Number

1,127 bytes removed, 23:21, 21 November 2018
no edit summary
The '''Number Format''' setting on [[Custom Fields]] allows you to define how numbers in the field will be displayed.
 
==General Description==
The '''Text box for email addressesBox - Number''' field allows you to define how numbers in the field will be displayed.
==Field Illustrated==
[[Image:placeholder.png|<em>Text Box - Email, in Edit Mode (above)</em>]]<br />''Text Box - EmailNumber, 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"
|-
|-
!|Whole Number
||1234561234.511234||123456.511234
|-
!|IntegerOne Decimal||1234561234.511234||123,4571234.1
|-
!|CommaTwo Decimals||1234561234.511234||123,4571234.12
|-
!|DecimalThree Decimals||1234561234.511234||1234.123,456.51
|-
!|Currency (US Dollars) Four Decimals||1234561234.511234||$123,4561234.511234
|-
!|Percent (Decimal)Nearest Ten||0.51991234||52%1230
|-
!|Percent (Display Number)Nearest Hundred||51.991234||52%1200
|-
!|CustomNearest Thousand||''Not Applicable''1234||''Not Applicable''1000
|}
===Validation===
{| class="wikitable"
|-
!|Option
!|Description
!|Format
|-
!|Mandatory
||Selecting this option means that this field is required and must be completed.
||''Not Applicable''
|-
!|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.
||''Not Applicable''
|-
!|Custom Validation
||-
||''Not Applicable''
|-
!|Failed Validation Message
||Message displayed if validation fails.
||''Not Applicable''
|}
===Feature Options===
{| class="wikitable"
|-
!|Option
!|Description
!|Format
|-
!|Track Changes
||-
||''Not Applicable''
|}
===Value Storage===
{| class="wikitable"
|-
!|Option
!|Description
!|Format
|-
!|From Custom Field(s)
||-
||''Not Applicable''
|-
!|To Custom Field
||-
||''Not Applicable''
|}
[[Category:Custom Fields]]
[[Category:Custom Field Types]]
 
 
<!--[[Image:PrecisionSetting.png|link=]]
[[Image:NewNumberFormatting.png|link=]]-->
 
 
: {| border="1" cellpadding="5"
+Number FormatValueDisplay+#,###.##1234.51,234.5+#,###.001234.51,234.50+#.001234.51234.50+Percent.1515%+Integer12.999512+Decimal1212.00+Currency20000$20,000.00+$###,###,###20000$20,000 (currency with no decimals)+Currency-EUR20000€20,000.00+Currency-GBP20000£20,000.00+Currency-QAR20000QAR 20.000,00+T##-#######12345678912-3456789 (EIN)+T### ### ###123 456 789123 456 789 (Canadian SIN)
 
 
 
===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 "Show Currency 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'''.
* [[Displaying a Number Value as Currency]]
* [[The Musings of Chin - Best Practice: Correct Data Formats]]
 
{| class="wikitable"
|-
||[[Image:Why.jpeg|link=|50px]]
||Click [http://wiki.smartsimple.com/wiki/Number_-_Why%3F here] to learn why this feature is a benefit to your organization.
|}
[[Category:Custom Fields]][[Category:Currency]][[Category:How]]
Nancy Sabo
Smartstaff, administrator
421
edits
Retrieved from ‘https://wiki.smartsimple.com/wiki/Special:MobileDiff/32633...33639’

Navigation menu