Changes

Custom Field Type: Text Box - Number

499 bytes removed, 23:21, 21 November 2018

no edit summary

{{FieldPermissionMatrix}}

<br /><br />

 

==General Description==

The '''Text Box - Number Format''' setting on [[Custom Fields]]  field allows you to define how numbers in the field will be displayed.

==Field Illustrated==

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

|-

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

 

----

* '''Mandatory''': Selecting this option means that this field is required and must be completed.

 

* '''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.

 

* '''Custom Validation''':

 

* '''Failed Validation Message''': Message displayed if validation fails.

 

===Feature Options===

 

----

* '''Track Changes''':

 

===Value Storage===

 

----

* '''From Custom Field(s)''':

 

* '''To Custom Field''':

 

==Permissions & Availability Tab==

{{FieldPermissionMatrix}}

{{FieldPermissions}}

{{VisibilityCondition}}

{{OnNewRecord}}

[[Category:Custom Fields]]

[[Category:Custom Field Types]]

 

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

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

 

 

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

• ← Older edit

Nancy Sabo

Smartstaff, administrator

421

edits