Differences

This shows you the differences between two versions of the page.

Link to this comparison view

field type - currency [2016/09/14 14: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]].
field type - currency.txt ยท Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2019