- 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 - number [2016/09/14 18:19] |
field type - number [2016/09/14 18:19] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== Number ====== | ||
| + | A number field holds up to 255 numerical characters and a decimal point. Any other characters will cause the field to fail validation. Use a Number Field to facilitate the use of numerical calculations and other expressions. | ||
| + | ===== 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 "Number" 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 {{:number.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]] | ||
| + | |||
| + | ==== View as Slider ==== | ||
| + | * [[Field Setting - Number Slider Interface|Slider Interface]] | ||
| + | |||
| + | ==== Default Value ==== | ||
| + | * [[Field Setting - Default Value|Default Value]] | ||
| + | |||
| + | ==== 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 Number Field has only one output format, which returns the number stored in the field. | ||
| + | |||
| + | |||
| + | ===== Acceptable inputs ===== | ||
| + | All numerical characters are allowed as well as one decimal. Any other characters will cause the Number Field to fail validation. | ||
| + | |||
| + | ===== Filters ===== | ||
| + | The number field can be filtered using any of the [[Query Builder - Filter#Number-type Filters|number-type filters]]. | ||
