Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Обязательное условие, чтобы у тебя префикс стал автоинкрементируемым и отображался у объекта, у него должно быть стринговое поле, number которое называется, и после этого ты можешь сделать свой префикс, который будет только в этом поле отображаться. Этот момент надо сформулировать и записать, чтобы было в быстром доступе.
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 user queries for their further processing and statistical purposes.
Autoincrement settings Autoincrement settings are stored in two tables:
Thethe Number (sys_number) table contains the Maximum digits, the Prefix,and the
PrefixStart Value settings for the table
;| Tip |
|---|
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 autoincrementTo 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.
- The field should be of String type. These fields are usually named “Number”.
If your table does not have this field, please create it: please refer . Refer to the related Create Columns article for more information: Creating Objects#Howtocreateacolumn.
1. Navigate to System Definition → Numbers;
2. Click New, fill in the form and then click Save.
.
Record Number form Autoincrement form fields
Field | Mandatory | Description | ||
|---|---|---|---|---|
| Maximum digits | Y | Define the max number of 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 | Y | Specify at | Prefix | At least three Latin letters that will be the starting point beginning of every record ID in this table. |
| Start Value | Y | Specify the initial value of the sequence. The default value is '1'. |
Example
| Info |
|---|
You just created the |
sequence, and you filled in the fields:
|
|
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.
| Note |
|---|
|