Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
...
It can be used for various purposes. One of them, for example, is registering
...
user queries for
...
further processing and statistical purposes.
...
Autoincrement settings are stored in
...
the Number (sys_number) table contains the Maximum digits, the Prefix,and the Start Value settings for the table.
...
In order to create
...
an autoincrement
...
,
...
1. Navigate to System Definition → Numbers
2. Click New, fill in the form and then click Save.
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 “Number”.
If your table does not have this field, please create it. Refer to the Create Columns article for more information.
Record Number
...
form fields
Field | Mandatory | Description |
|---|---|---|
| Maximum digits |
...
| Y | Define the max number 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
| 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 |
|---|
|