Table of Contents
Introduction
| English |
|---|
| The ID Generator Field is used to produce a running number based on an App Variable. To learn more about its usage, refer to Generate Reference ID. |
| Note |
|---|
You will only need to do this if you are using MySQL, as other databases already default to "READ-COMMITTED". Run the following queries in MySQL. SET GLOBAL tx_isolation='READ-COMMITTED'; SET SESSION tx_isolation='READ-COMMITTED'; You will also need to set the following in your |
...
- Start the Joget Server and open the App Center.
- Log in as admin and click on the pencil icon on the Expenses Claim to open the App Composer (see Figure 1).
Figure 1 - Under Form Builder column, click on Expense Claim New (see Figure 2).
Figure 2 - Click on the ID Generator Field element on the canvas to open up the Configure ID Generator Field properties. (see Figure 3)
Figure 3 - Take note of the Format.
- To see it working, head back to the App Composer and click the Launch button in the UI column.
- Click on Create a New Expense Claim button on the Dashboard, fill up the necessary details and click Continue Next Screen button.
- Click on Save As Draft button.
- Go to My Expenses on the menu to the left and click on My Inbox. Here you can see the ID generator has generated a 4 digit running number (as defined in the Format field in steps 4 & 5) under the # column (see Figure 4).
Figure 4
...
| Name | Description | |||||
|---|---|---|---|---|---|---|
| ID | Element ID (By declaring as "ref", a corresponding database table column "c_ref" will be created)
| |||||
| Label | Element Label to be displayed to the end-user. | |||||
| App Variable Name | Name of the app variable to be used to keep the running number. | |||||
| Format | Determines the pattern of the generated value (e.g., "REF-?????" will yield "REF-00001") |
Advanced Options
| Name | Description | |||||||
|---|---|---|---|---|---|---|---|---|
| Hidden? | Determines if the element should be made visible in the form. | |||||||
| Workflow Variable | If the form is part of a workflow process, upon saving of the form (by clicking on "Save as Draft" or "Complete" button). The value in this input field will be saved into the corresponding workflow variable named here.
| |||||||
| Distributed Unique ID | Generates a distributed sequential unique ID.
|