¶ Auto-Incrementing Field
The Auto-Incrementing Field provides the following capabilities:
- Auto Population
Simply saving the record will cause the auto incrementing number field to take on the next available integer value among all the records in the table. - Prefixing
In Form Designer you can specify a prefix. This prefix will be appended on every record's auto incrementing number field value - Zero Padding
Zero padding ensures that every auto incrementing number field has the same number of total characters.
¶ Form Designer
¶ Adding an Auto-Incrementing Field to a form
In Form Designer you can add an auto-incrementing field by dragging the auto-incrementing number field icon onto the form from the toolbar. 
¶ Auto-Incrementing Field Properties
In addition to the Default Field Properties Auto-Incrementing fields expose the following additional properties:
TODO This needs to be re-populated when the field properties for auto-incrementing number fields are turned bak on.
¶ Field Details (Auto-Incrementing)
¶ Auto-Incrementing Field Security
Details about field security are available here: Field Security
¶ Auto-Incrementing Field History
TODO: Link to the basic field history document that does not exist yet
¶ Accessibility
Details about field accessibility are available here: Accessibility
¶ Scripting Auto-Incrementing Fields
Auto-Incrementing fields can be read in script but are set and maintained by Platform Server. The value of an Auto-Incrementing field can not be set in script.
¶ Setting the value in script.
N/A
¶ Reading the value in script.
$ps.toast("Auto Increment Field:" + $current.new_autoincrement_field_1);
¶ Supported Query Operators
- =,!=
- <=, >=, <, >
Details about query operators are available here: ps-queryoperators