Changes

Custom Field Type: Text Box - Number

2,957 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|]]<embr />''Text Box - EmailNumber, in Edit Mode (above)'' ==FieldOptions==All common options:<br />[[Custom Fields - General Information #General_Settings|General Settings]]<br /em>[[Custom Fields - General Information #Role Field Permissions and Status Field Permissions|Permissions & Availability]]<br />''Text Box [[Custom Fields - EmailGeneral Information #Classic Options|Classic Options]]<br />For further information, in Edit Mode (above)''please refer to [[Custom Fields – General Information]].<br /><br />Options listed below are specific to this particular field type. ===Number Format===

==General Settings==

===General===

{| class="wikitable"

|-

!|Option

!|Description

!|Format

|-

!|Custom Field ID 

||The ID number associated with the custom field.

||''Not Applicable''

|-

!|Field Type

||The list of available Field Types

||@fieldtype@

|-

!|Field Name

||The name of the field, used internally to reference the user's input.

||@fieldname@

|-

!|[[Caption]] 

||The leading question or prologue before the field. If left blank, the Field Name will be displayed as the caption.

||@caption@

|-

!|Display Order 

||The order (relative to other fields) in which this field is displayed.

||@displayorder@

|-

!|Description

||Definition and general description of the custom field. Will not be displayed.

||@description@

|-

!|Values

||The value that will be displayed.

||''Not Applicable''

|}

===Display===

----

{| class="wikitable"

|-

!|Option

!|Description

!|Format

|-

!|Caption Location 

||Determines the positioning and visibility of the [[caption]] relative to the field. Options include: Left of Field, Above Field, No Caption, Hide Caption. '''Note:''' this option was previously called '''Label Display'''. ([[Label Display Options|See examples here.]])

||''Not Applicable''

|-

!|Instructions

||Text input here displays under the caption. If caption has Hide Caption enabled then any defined instructions will continue to be displayed above the input.

||''Not Applicable''

|-

!|Placeholder Text

||Text input here displays within the text box as placeholder text that will disappear once the user clicks into the field to enter content. Note: this function is different from Default Text, as Placeholder text will not create content to be stored within the field.

||''Not Applicable''

|-

!|[[Tool Tip]]

||When the user hovers their mouse pointer over the caption of a field, the text in this section will appear.

||''Not Applicable''

|-

!|Classify as Personal Data

||For use in storing personal data.

||''Not Applicable''

|-

!|SmartFields View

||Include or exclude this field from SmartField Views (@SmartFields@) or only display this field for SmartField Views. See SmartField View for further details.

||''Not Applicable''

|-

!|SmartFields PDF Formatting

||PDF formatting option when rendered from SmartFields Views.

||@SmartFields@

|-

!|Width

||Width of text box.

||''Not Applicable''

|}

====Number Format====

{| class="wikitable"

|-

!|Value (Example)

!|Display (Example)

|-

!|None

||123456.51

||123456.51

|-

!|Integer

|}

===Validation===

{| class="wikitable"

|-

!|OptionNumber Precision!|DescriptionValue (Example)!|FormatDisplay (Example)

|-

!|MandatoryWhole Number||Selecting this option means that this field is required and must be completed1234.1234||''Not Applicable''1234

|-

!|Appear MandatoryOne Decimal||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 validation1234.1234||''Not Applicable''1234.1

|-

!|Custom ValidationTwo Decimals||-1234.1234||''Not Applicable''1234.12

|-

!|Failed Validation MessageThree Decimals||Message displayed if validation fails1234.1234||''Not Applicable''|}===Feature Options==={| class="wikitable"1234.123

|-

!|OptionFour Decimals!|Description|1234.1234!|Format|1234.1234

|-

!|Track ChangesNearest Ten||-1234||''Not Applicable''|}===Value Storage==={| class="wikitable"1230

|-

!|OptionNearest Hundred!|Description|1234!|Format|1200

|-

!|From Custom Field(s)Nearest Thousand||-1234||''Not Applicable''|-!|To Custom Field||-||''Not Applicable''1000

|}

 

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

• ← Older edit

Nancy Sabo

Smartstaff, administrator

421

edits