====== 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]].