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.

1. Click the to add a field in your form.
2. Choose “New Field”
3. Select the table you wish to add the field to. Most of the time, this will be the current table you are on, called the current context.
4. Select a field name and click “Choose Type”.
5. Choose “Currency” from the list of field types.
6. You can continue adding fields or click the “Select” button to finish adding.

Field features can be edited by clicking on the orange field icon when the presentation layer is displayed.

• Field Label
• Field Setting - Display Alternate Label (affects this form only)

• Column Span
• Row Span

• Sizing

• Tooltip
• Descriptive Text
• Display Alternate Descriptive Text (affects this form only)

• Decimal places to show on the Form
• Decimal places to store in the Field

• Temporary Block Association
• Global Block Association

• Default Value

• Regionalization

• Required
• Maximum Length

• Audit This Field
• Show Audit History

• View Only

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

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

The currency field can be filtered using any of the number-type filters.