Difference between revisions of "Custom Field Type: Text Box - Number"
From SmartWiki
Line 10: | Line 10: | ||
''Text Box - Email, in Edit Mode (above)'' | ''Text Box - Email, in Edit Mode (above)'' | ||
− | {{FieldOptions}} | + | {{FieldOptions}} |
+ | |||
===Number Format=== | ===Number Format=== | ||
+ | ---- | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
Line 91: | Line 93: | ||
===Validation=== | ===Validation=== | ||
+ | |||
---- | ---- | ||
* '''Mandatory''': Selecting this option means that this field is required and must be completed. | * '''Mandatory''': Selecting this option means that this field is required and must be completed. | ||
Line 96: | Line 99: | ||
* '''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. | * '''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''' | + | * '''Custom Validation''': |
* '''Failed Validation Message''': Message displayed if validation fails. | * '''Failed Validation Message''': Message displayed if validation fails. | ||
===Feature Options=== | ===Feature Options=== | ||
+ | |||
---- | ---- | ||
− | '''Track Changes''' | + | * '''Track Changes''': |
===Value Storage=== | ===Value Storage=== | ||
+ | |||
---- | ---- | ||
− | '''From Custom Field(s)''' | + | * '''From Custom Field(s)''': |
− | '''To Custom Field''' | + | * '''To Custom Field''': |
[[Category:Custom Fields]] | [[Category:Custom Fields]] |
Revision as of 11:27, 24 August 2018
Please note that this page is currently under construction. There is more information to come. |
The Number Format setting on Custom Fields allows you to define how numbers in the field will be displayed.
Contents
General Description
Text box for email addresses.
Field Illustrated
Text Box - Email, in Edit Mode (above)
Text Box - Email, in Edit Mode (above)
Field Options
Option | Description | Format |
---|---|---|
Custom Field ID | The unique 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. | @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@ |
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 | 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 |
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:
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 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 (,).
See Also
- Field Formatting Options
- Displaying a Number Value as Currency
- The Musings of Chin - Best Practice: Correct Data Formats
Click here to learn why this feature is a benefit to your organization. |