...
Things get tricky if you are trying to update a Form that is NOT directly part of the flow. Joget will not be able to use the same PID to match the record row.
Table Name: | transactions |
|---|---|
PK | id |
| name |
FK | account_no |
Figure 1: Transaction table which is mapped to the process activity.
Table Name: | accounts |
|---|---|
PK | id |
| name |
| expiry |
Figure 2: Account table which is not part of the process activity but has relationship to the Transaction table.
...
The solution is simple. One will simply need to define a "id" field in the Update Fields section. State the value that would correspond to the record identifier of the Form.
Related Elements