Custom Field Type: Layout - Tabbed Section
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
{| class="wikitable"
|-
!|Number Format
!|Value (Example)
!|Display (Example)
|-
!|None
123456.51
>-
!|Integer
123456.51
>-
!|Comma
123456.51
>-
!|Decimal
123456.51
>-
!|Currency (US Dollars)
123456.51
>-
!|Percent (Decimal)
0.5199
>-
!|Percent (Display Number)
51.99
>-
!|Custom
Not Applicable
>}
 Please note that this page is currently under construction. There is more information to come.
|
Value Storage
* From Custom Field(s):
- To Custom Field:
==Permissions & Availability Tab==
- Field Permission Matrix: See the Field Permission Matrix Wiki page.
- Role - Field Permissions: These settings allow you to control by Role who is allowed to view and/or modify the field.
- Status - Field Permissions: These settings allow you to control by the Status of the record whether or not the field can be viewed and/or modified. (Only present within the Universal Tracking Application)
- Type - Field Permissions: These settings allow you to control by the template of the record whether or not the field can be viewed and/or modified. (Only present within the Universal Tracking Application)
- Visibility Condition: See the Visibility Condition Wiki page.
- On New Record: Used to control when the field should be displayed.
Classic Options
- Tab Name: Creates and displays a specific tab for the field (field will not exist on main page of UTA record anymore).
- Custom HTML Tag: For additional attributes to the field HTML tag.
- Searchable: Enable to make field to be searchable.
- Read Only: Enable to make field read only.
- Disable Quick Edit: Enable to disable quick edit.
- Disable Field from Global Search: Enable to disable field from global search.
===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
