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 inquiries for their further processing and statistical purposes.
Autoincrement settings are stored in two tables:
For working correctly, records in both tables must be created. If the record in the Number (sys_number) table exists and the record in the Autoincrement (sys_number_autoincrement) table is not, then it will be created automatically, and the numbering will start with 1. |
In order to create an autoincrement rule, the following criteria must be met: the object you are configuring an autoincrement for must have a field that should be incremented. It must have a String type, and generally, these fields are named as "Number".
If your table does not have this field, please create it: please refer to the Creating a Column article for more information.
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 amount 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 beginning of every record ID in this table. |
You just created the rule, and you filled in the fields:
So the first record ID will be ABC000124, and the further ones will be ABC000125, ABC000126, and so on.