Difference between revisions of "Custom Field Type: Text Box - Number"
From SmartWiki
Line 1: | Line 1: | ||
<span id="bs_template:@@@TPL3@@@" class="mceNonEditable template" data-bs-name="Banner-UnderConstruction" data-bs-type="template" data-bs-id="3">{{ Banner-UnderConstruction }}</span> | <span id="bs_template:@@@TPL3@@@" class="mceNonEditable template" data-bs-name="Banner-UnderConstruction" data-bs-type="template" data-bs-id="3">{{ Banner-UnderConstruction }}</span> | ||
+ | ==General Description== | ||
The '''Number Format''' setting on [[Custom Fields]] allows you to define how numbers in the field will be displayed. | The '''Number Format''' setting on [[Custom Fields]] allows you to define how numbers in the field will be displayed. | ||
− | |||
− | |||
− | |||
==Field Illustrated== | ==Field Illustrated== |
Revision as of 11:32, 24 August 2018
Please note that this page is currently under construction. There is more information to come. |
Contents
General Description
The Number Format setting on Custom Fields allows you to define how numbers in the field will be displayed.
Field Illustrated
File:Placeholder.png
Text Box - Number, 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. |