- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
This shows you the differences between two versions of the page.
|
field type - currency [2016/09/14 18:19] |
field type - currency [2016/09/14 18:19] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== Currency ====== | ||
| + | The currency Field stores a monetary value. It works much like a number Field but has been slightly modified. For instance, a currency Field will never show the value 34.2. Instead, it will show $34.20. | ||
| + | |||
| + | ===== How to Create ===== | ||
| + | - Click the {{:presentation-layer:field-plus.png|}} to add a field in your [[Form|form]]. | ||
| + | - Choose "New Field" | ||
| + | - Select the table you wish to add the field to. Most of the time, this will be the current [[Table|table]] you are on, called the current [[Context|context]]. | ||
| + | - Select a field name and click "Choose Type". | ||
| + | - Choose "Currency" from the list of field types. | ||
| + | - You can continue adding fields or click the "Select" button to finish adding. | ||
| + | ===== Features ===== | ||
| + | |||
| + | Field features can be edited by clicking on the orange field icon {{:currency.png|}} when the [[Presentation Layer|presentation layer]] is displayed. | ||
| + | |||
| + | ==== Field Label ==== | ||
| + | * [[Field Setting - Field Label|Field Label]] | ||
| + | * [[Field Setting - Display Alternate Label]] (affects this form only) | ||
| + | |||
| + | ==== Grid Appearance ==== | ||
| + | |||
| + | * [[Field Setting - Column Span|Column Span]] | ||
| + | * [[Field Setting - Row Span|Row Span]] | ||
| + | |||
| + | ==== Sizing ==== | ||
| + | |||
| + | * [[Field Setting - Sizing|Sizing]] | ||
| + | | ||
| + | ==== Tooltip ==== | ||
| + | * [[Field Setting - Tooltip|Tooltip]] | ||
| + | * [[Field Setting - Descriptive Text|Descriptive Text]] | ||
| + | * [[Field Setting - Display Alternate Descriptive Text|Display Alternate Descriptive Text]] (affects this form only) | ||
| + | ==== Field Format ==== | ||
| + | * [[Field Setting - Decimal places to show on the Form|Decimal places to show on the Form]] | ||
| + | * [[Field Setting - Decimal places to store in the Field|Decimal places to store in the Field]] | ||
| + | ==== Block Association ==== | ||
| + | * [[Field Setting - Temporary Block Association|Temporary Block Association]] | ||
| + | * [[Field Setting - Global Block Association|Global Block Association]] | ||
| + | |||
| + | ==== Default Value ==== | ||
| + | * [[Field Setting - Default Value|Default Value]] | ||
| + | |||
| + | ==== Regionalization ==== | ||
| + | * [[Field Setting - Regionalization|Regionalization]] | ||
| + | |||
| + | ==== Validation ==== | ||
| + | * [[Field Setting - Required|Required]] | ||
| + | * [[Field Setting - Maximum Length|Maximum Length]] | ||
| + | |||
| + | ==== Audit History ==== | ||
| + | * [[Field Setting - Audit This Field|Audit This Field]] | ||
| + | * [[Field Setting - Show Audit History|Show Audit History]] | ||
| + | |||
| + | ==== View Only ==== | ||
| + | * [[Field Setting - View Only|View Only]] | ||
| + | |||
| + | |||
| + | ===== Output formats ===== | ||
| + | The currency Field has two different output formats: | ||
| + | * Full Field - This output format returns the entire dollar amount, including a dollar sign. Thus, a typical output might be $4.40. | ||
| + | * Number Only - This output format returns only the number stored in the currency Field. The value $4.40 would be displayed as 4.4 | ||
| + | ===== Acceptable inputs ===== | ||
| + | The currency Field accepts the same input as any number Field. All numerical characters are allowed as well as one decimal. Any other characters will cause the currency Field to fail validation. Since the Field accepts only numbers, and no other characters (including dollar signs), the expression for defaulting a currency Field should result in a number with no symbols. Thus if defaulting a currency Field to the value of another currency Field, the "Number Only" output format should be used | ||
| + | |||
| + | ===== Filters ===== | ||
| + | The currency field can be filtered using any of the [[Query Builder - Filter#Number-type filters|number-type filters]]. | ||
