Versions Compared

Old Version 10

changes.mady.by.user Anna Kryzhanovskaya

Saved on

compared with

New Version 11

changes.mady.by.user Dina Baksheeva

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Merged branch "DOC0000311" into parent
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 Autoincrement settings are stored in two tables:

The

the Number (sys_number) table contains the Maximum digits, the Prefix,and the

Prefix

Start Value settings for the table

.
  • The Autoincrement (sys_number_autoincrement) table stores the autoincrement setting related to the table.
    • InfoIf the record in the Number (sys_number) table exists and the record in the Autoincrement (sys_number_autoincrement) table does 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

    • The object, for which you are configuring an autoincrement, must have a field that should be incremented.
    It must have a String type, and generally, these fields are
    • 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 . Refer to the Creating a ColumnCreate Columns article for more information.

    1. Navigate to System Definition → Prefixes.
    2. Click New and fill in the fields.
    3. Click Save or Save and Exit to apply changes.

    Autoincrement Record Number form fields

    Field

    		Mandatory

    Description

    Maximum digitsYThe Define the max amount of digits after the prefix.
    PrefixYAt Specify at least three Latin letters that will be the beginning of every record ID in this table.
    Start ValueYSpecify the initial value of the sequence. The default value is '1'. 

    Example

    Info

    You just created the

    rule

    sequence, and you filled in the fields:

    Field

    Type

    Value

    Maximum digits

    – 6

    Small Integer

    6

    Prefix

    String

    		ABC

    Start Value

    Integer

    		22
    Prefix – ABC

    So the first record ID will be

    ABC000001

    ABC000022, and the further ones will be

    ABC000002

    ABC000023,

    ABC000003

    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.

    Note
    • 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.