| Table of Contents |
|---|
Introduction
| English |
|---|
| ID Generator Tool allows one to increment a value stored in |
...
| App Variable by one. It is often used to generate/keep a running number (e.g. application reference number) in your form. |
ID Generator Field Properties
...
Configure ID Generator
...
Tool
Figure 1: ID Generator Tool Properties
| Name | Description | |||||
|---|---|---|---|---|---|---|
| Form | Choose the Target form. | |||||
| Field ID | Form field id. Only alpha-numeric and underscore characters allowed. Mandatory field. If you use "id", the form will save with the "id" primary key in running sequence. Joget will not create the "id" in UUID format. | |||||
| LabelRecord ID | Key in the label of this field. Mandatory field. | |||||
| Environment App Variable Name | Name of the environment app variable to be used to store the running number. Joget will automatically create the environment variable in Properties & Export the app variable if the name does not exist. Only letters (a-z and A-Z), numbers (0-9) and underscore (_) are allowed in the Environment App Variable Name field. Do ensure your Environment App Variable Names are unique unique for each form in your app (meaning for each form that is mapped to a different database table name). If you are using the ID the ID Generator Field as "id", meaning it is a primary key value, be careful not to override the environment app variable value when inporting importing apps: do not click the "Show Advanced Options > Override environment Show Advanced Options > Override app variables" checkbox in Import App screen. | |||||
| Format | Determines the pattern of the generated value (e.g., "REF-?????" will yield "REF-00001"). | |||||
| Hidden | Click the checkbox to hide this field in the form. | |||||
| Workflow Variable | The value generated can be saved into the corresponding workflow variable named here.
| |||||
| Distributed Unique ID | Generates a distributed sequential unique ID.
|
Isolation Level For MySQL Database
...