Autoincrement
Autoincrement is a function that operates with record numbers. It automatically generates a new record number increased by 1.
It can be used for various purposes. One of them, for example, is registering tickets for their further processing and statistical purposes.
Autoincrement settings are stored in the Number (sys_number) table.
To create a autoincrement rule, please complete the steps below:
1. Navigate to System Definition → Numbers
2. Click New, fill in the form and then click Save.
Autoincrement form fields
Field | Description |
|---|---|
| Maximum digits | Maximum digits possible after the prefix. |
| Autoincrement | Enter the start point for the numbering. An incremental step is always 1, so further entries in this table will have the number increased by 1. |
| Prefix | At least three Latin letters that will be the starting point of every record ID in this table. |
Example
You just created the rule, and you filled in the fields:
- Maximum digits - 6
- Prefix - ABC
- Autoincrement - 123
So the first record ID will be ABC000124, and the further ones will be ABC000125, ABC000126, and so on.
