Differences

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

Link to this comparison view

field type - autonumber [2016/09/14 14:19] (current)
Line 1: Line 1:
 +====== Autonumber ======
 +The autonumber Field is used for sequentially numbering instances of one or more Item Types automatically. ​ It may only be set once for each instance of an Item, and always takes a value one greater than the value the previous instance too.
 +===== 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 "​Autonumber"​ from the list of field types. ​
 +  - You can continue adding fields or click the "​Select"​ button to finish adding.
 +  - Once your field is created, edit the settings for the field to set the [[Field Setting - Starting Value|starting value]].
 +===== Features =====
  
 +Field features can be edited by clicking on the orange field icon {{:​autonumber.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)
 +
 +==== Block Association ====
 +  * [[Field Setting - Temporary Block Association|Temporary Block Association]]
 +  * [[Field Setting - Global Block Association|Global Block Association]]
 +
 +==== Set Starting Value ====
 +  * [[Field Setting - Set Starting Value|Set Starting Value]]
 +
 +  ​
 +===== Output formats =====
 +The Autonumber Field has only one output format, which returns the number stored in the Field.
 +
 +===== Acceptable inputs =====
 +
 +The Autonumber Field is set in one of two ways.  If the Field has not been set for the current instance of an Item and the Field is displayed on a Layout that gets saved, the autonumber Field takes the next available number. ​ The other way is by using Actions: if the autonumber has not been set for the current instance of an Item, if any value is set to save into the autonumber through Actions, the autonumber field takes the next available numberThe autonumber Field has only one output format, which returns the number stored in the Field.
 +
 +===== Filters =====
 +The autonumber field can be filtered using any of the [[Query Builder - Filter#​Number-type filters|number-type filters]].
field type - autonumber.txt ยท Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2019