Differences

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

Link to this comparison view

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