The Record Number engine automatically generates a new record number increased by 1.It can be used for various purposes, such as for registering tasks for further processing and collecting statistical data.
To create a record numbering, the following criteria must be met:
- The object for which you are configuring a record numbering must have a field that should be incremented.
- The field should be of String type. These fields are usually named Number.
If your table does not have this field, you can create it. Refer to the Create Columns article for more information.
The record numbering settings are stored in the Record Number (sys_number) table.
Number form fields
Field | Mandatory | Description |
|---|
| Prefix | Y | Specify at least three Latin letters that will be added at the beginning of every record number in this table. |
| Maximum digits | Y | Define the maximum number of digits after the prefix. |
| Start value | Y | Specify the initial value of the sequence. The default value is 1. |
Example
If the Start value changes, and it is greater than the current value of the sequence, the previous sequence will be saved, and the new sequence will be set to a new starting value.
