Introduction

...

1. Start the Joget Server and open the App Center.
   
   
2. Log in as admin and click on the Design New App button. (see Figure 1)
   Image Removed Image Added
   
   Figure 1
   
   
3. Fill up the App Details as follows and click Save (see Figure 2):
   1. App ID: ajaxSubform
   2. App Name: AJAX Subform
   Image Removed
   Image Added
   Figure 2
   
   
4. You will be directed to the Design App Composer. Click on the Create New Form button and fill up the Form Details as follows (see Figure 3):
   
   1. Form ID: formA
   2. Form Name: Form A
   3. Table Name: as_a
   Image Removed
   Image Added
   Figure 3
   
   
5. Click on Save and you will be directed to the  Form Builder.
   
   
6. Drag and drop a Text Field element on to the canvas.
   
   
7. Hover the mouse over Click on the Text Field element element on the canvas and click on Edit to open up the Edit Text Configure Text Field properties.
   
   
8. Fill up the Edit Text Field the Configure Text Field  properties as follows and click on OK  Apply Change (see Figure 4):
   1. ID: name
   2. Label: Name
   Image Removed
   Image Added
   Figure 4
   
   
9. Click on Save on the Form Builder.
   
   
10. Click on Generate App, select Generate CRUD and click OK click Generate (see Figure 5)
    
    
11. Once the App Generator is complete, click on the link to launch the userview.
    
    
12. Click on New button and Save at least 2 records of data (see Figure 5)
    Image Removed
    Image Added
    Figure 5
    
    
13. Head back to the Design the App Composer.
    
    
14. Click on the Create New Form button and fill up the Form Details as follows (see Figure 6):
    
    1. ID: formB
    2. Form Name: Form B
    3. Table Name: as_b
    Image Removed
    Image Added
    Figure 6
    
    
15. Click on Save and you will be directed to the  the  Form Builder. 
    
    
16. Drag and drop a Select Box element on to the canvas.
    
    
17. Hover the mouse over Click on the Select Box element on on the canvas and click on Edit to open up the Edit Select Configure Select Box properties. 
    
    
18. To Save any changes in any Configuration Properties, Click on Apply Change.
19. Fill up the Configure Select Fill up the Edit Select Box properties as follows and click on Next  (see Figure 7):
    1. Label: Choose record from Form A
       Or
       1. Choose Options
       Binder
       1. Data Store:
       Default
       1. Form
       Options Binder
       1. Data
          
          
    2. Fill up the following details in the Edit Select Box and click OK  Configure Select Box properties as follows(see Figure 7):
       
       1. ID: field1
       2. Form: Form A
       3. Label Column: name
       Image Removed
       Image Added
       Figure 7
       
       
    3. Drag and drop an AJAX Subform element on to the canvas.
       
       
    4. Hover the mouse over Click on the AJAX Subform element on the canvas and click on Edit to element on the canvas to open up the Edit AJAX Configure AJAX Subform properties.
       
       
    5. Fill up the Edit AJAX Subform Configure AJAX Subform properties as follows and click on Next  (see Figure 8):
       1. Form: Form A
       
       
       
    6. Tick the first three checkboxes and click Next  (see Figure 8)
       a. Reload Subform When Parent Field Value Change
       b. Readonly
       c. Display Field as Label When Readonly? 
       Image AddedFill up the Edit AJAX Subform 

          Figure 8

         24. Fill up the Configure AJAX Subform properties as follows

    ...

     (see Figure 8):

    1. Parent Field to keep Subform ID: field1Image Removed field1 (see Figure 9)

    
    Image Added
    
    Figure

    ...

    9
    
    

    25.  Click on Preview and select between the records in the Select Box to see the Subform dynamically loads the appropriate record.

    How to use AJAX Subform

    Widget Connector
    width 700 url https://www.youtube.com/watch?v=arYXY7TDOtA height 550

    AJAX Subform Properties

    ...

    Configure AJAX Subform 

    Image RemovedImage Added

    Name	Description
    Label	Element Label to be displayed to the end-user.
    ID	Element ID (By declaring as "view_existing_claim", a corresponding database table column "c_view_existing_claim" will be created) Please see Form Element for more information about defining the ID and list of reserved IDs.	Label	Element Label to be displayed to the end-user .
    Form	Target Form to be loaded. Info title Usage of Hash Variable The use of Hash Variables inside the target form is permissible but may be limited due to the nature of how the form is loaded. Example 1: One can use #requestParam.primaryKey# to access the record ID. Example 2: One can use #form.tableName.fieldId[{requestParam.primaryKey}]# to access field value of the given record ID.

    
    

    UI

    General

    Image RemovedImage Added

    Name	Description
    Reload SubForm when Parent Field value change?	Dynamically reload the subform when parent field value changes. Info Parent Field value here refers to the Parent Field to keep Subform ID setting in the next tab.
    Readonly	Determines if the element is editable.
    Display field as Label when read-only?	Displays the value of the element as plain text when an element is set to "Readonly".
    Display without frame?	Decorator option. Removes default styling applied to SubForm when checked.

    
    

    
    

    Collapsible

    ...

    Collapsible Setting

    Image RemovedImage Added

    Name	Description
    Collapsible?	Make the AJAX Subform collapsible.
    Label when expanded	Label when expanded
    Label when collapsed	Label when collapsed
    Expanded by default?	Expanded by default option.
    Hide when no value?	To hide the AJAX Subform when there's no data to be loaded.
    Do not load subform in background when it is collapsed or hidden	To not load the subform when it is collapsed or hidden. Info title New Feature Newly introduced in Joget DX

    
    

    Data &

    ...

    Data Store

    Data Linkage

    Image RemovedImage Added

    Name	Description
    Parent Field to keep Subform ID	The ID of the field in the parent form to store the SubForm table's primary key. SubForm data will be loaded based on the record ID retrieved from this field.
    Subform Field to keep Parent ID	The ID of the field in the SubForm form to store the parent table's primary key.

    
    

    
    

    Data Store

    ...

    By default, the Workflow Form Binder plugin is used for loading and storage of form data in the AJAX Subform, you may override it with other plugins.

    Info
    title Important
    The target form's Store Binder will not be executed. The Store Binder selected in this property will be executed instead.

    See the list of available Form Binder.

    Image Added

    
    

    Binder

    Image Removed

    Name	Description
    Save Date To	Default	Store Binder	By default, the Workflow Form Binder plugin is used for loading and storage of form data in the AJAX Subform, you may override it with other plugins. Info title Important The target form's Store Binder Data Store will not be executed. The Store Data Store Binder selected in this property will be executed instead. See a list of available Form Binder Form Data Store.

    
    

    Related Video Tutorials

    Widget Connector
    url https://www.youtube.com/watch?v=TXh_5_Wh26Y&feature=youtu.be

    
    

    ...

    Download the demo app with examples on using Ajax Subform with two options: 'JDBC Database SQL queryQuery' and ' Workflow Parent Form BinderData Store':

    • APP_ajax_subform_jdbc_dx_kb.jwa

    ...