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 tasks for their further processing and statistical purposes.
Autoincrement settings are stored in the Number (sys_number) table contains the Maximum digits, the Prefix,and the Start Valuesettingsfor the table.
In order to create an autoincrement, the following criteria must be met:
The object, for which you are configuring an autoincrement, must have a field that should be incremented.
The field should be of String type. These fields are usually named as "Number".
If your table does not have this field, please create it. Refer to the Creating a Column article for more information.
Record Number form fields
Field
Mandatory
Description
Maximum digits
Y
Define the max amount of digits after the prefix.
Prefix
Y
Specify at least three Latin letters that will be the beginning of every record ID in this table.
Start Value
Y
Specify the initial value of the sequence. The default value is '1'.
Example
You just created the sequence, and you filled in the fields:
Field
Type
Value
Maximum digits
Small Integer
6
Prefix
String
ABC
Start Value
Integer
22
So the first record ID will be ABC000022, and the further ones will be ABC000023, ABC000024, and so on.
If the value of the Start Value changes, and it is greater than the current value of the sequence, the value will be saved, and the sequence will be set to a new starting value.
If you create a record in the Record Number (sys_number)table, a sequence is created.
If you delete a record in the Record Number (sys_number)table, the sequence is deleted.
