Changes

Custom Field Type: Text Box - Number

585 bytes added, 23:21, 21 November 2018

no edit summary

==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 />

[[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"

|-

!|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''

|}

 

{| class="wikitable"

|-

!|[[Image:HowNumber Precision!|Value (Example)!|Display (Example)|-!|Whole Number||1234.1234||1234|-!|One Decimal||1234.1234||1234.1|-!|Two Decimals||1234.png1234||50px1234.12|link=]]-!|This article will explain '''how''' you can implement this feature for use on your SmartSimple systemThree Decimals||1234.1234||1234.123|-!|Four Decimals||1234.1234||1234.1234|-!|Nearest Ten||1234||1230|-!|Nearest Hundred||1234||1200|-!|Nearest Thousand||1234||1000

|}

The '''Number Format''' setting on [[Category:Custom Fields]] allows you to define how numbers in the field will be displayed.[[Category:Custom Field Types]]

<!--[[Image:PrecisionSetting.png|link=]]

[[Image:NewNumberFormatting.png|link=]]-->

 

:{| border="1" cellpadding="5"

|+

!Number Format!!Value!!Display

|+

|#,###.##||1234.5||1,234.5

|+

|#,###.00||1234.5||1,234.50

|+

|#.00||1234.5||1234.50

|+

|Percent||.15||15%

|+

|Integer||12.9995||12

|+

|Decimal||12||12.00

|+

|Currency||20000||$20,000.00

|+

|$###,###,###||20000||$20,000 (currency with no decimals)

|+

|Currency-EUR||20000|| €20,000.00

|+

|Currency-GBP||20000|| £20,000.00

|+

|Currency-QAR||20000|| QAR 20.000,00

|+

|T##-#######||123456789||12-3456789 (EIN)

|+

|T### ### ###||123 456 789||123 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|50px|link=]]

|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]]

• ← Older edit

Nancy Sabo

Smartstaff, administrator

421

edits