Joget DX Preview Release Available for Download
Check out Joget DX, the next generation successor to Joget Workflow for faster, simpler digital transformation.
How to make three related tables show records. As an example masterDetail.png. Row selection on first table should populate row in 2nd table a row selection in 2nd table should populate rows in 3rd table.These would be read only Tables.
I tried Subform_Repeater and it does not show the second Grid. It does not load Data at all . Walter I would appreciate if you can show with an example.
I tried creating a Form view and it shows "save button" in the bottom and these three Tables are going to be read only Tables.This makes me think I am not using this correctly. Also the Grid when read only is not selectable.So you don't know which row is selected. Although the selection highlighting problem may be solved by using Spreadsheet grid.
I also considered using List view but it does not allow multiple Grids on same Page.
Example Student Parent Table Course Child Table and Lectures Grandchild Table. Each of them dependent on the selection of row of last table.
I would appreciate if Matthew or one of the experts on the forum can provide a quick Example. If this is a limitation of the platform I would appreciate some insight.
Based on the suggestion, I am using 2 Grid Tables, each of them are backed by their own bean shells load method i.e load (Element element, FormData formData) that returns the FormRowSet.
As mentioned I am challenged to create the injection point on a form where I need to
1. set and pass a parameter from a parent Gird to be accessible by the child's bean Shell. 2. Call the Child load Bean method based on the click event of the parent Grid. A parameter key needs to be passed that I need to use to retrieve the record for child Table.
It seems that there are multiple rows on first table, so there will be a need to iterate through second table? Maybe you can also consider https://marketplace.joget.org/jw/web/userview/mp/mpp/_/vad?id=Subform_Repeater plugin in your form design.
You can use custom JDBC Form Binder or Bean Shell Programming Guide#UseasFormMultiRowLoadBinder to populate the tables according to your specific rules.
More information in Load & Store Form Grid Data Using Bean Shell Form Binder .
Powered by a free Atlassian Confluence Open Source Project License granted to Joget Workflow. Evaluate Confluence today.