Introduction

AJAX SubForm gives you the flexibility of dynamically loading a Subform by attaching a listener to another form field. 

The Advanced Grid is only available on Professional and Enterprise Edition.

Get Started

The easiest way to see how the AJAX Subform works is to create a new app. Here are the steps:

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)
   
   
   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
   
   
   Figure 2
   
   
4. You will be directed to the Design App. 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
   
   
   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. Click on the Text Field element on the canvas to open up the Configure Text Field properties.
   
   
8. Fill up the Configure Text Field  properties as follows and click on OK (see Figure 4):
   1. ID: name
   2. Label: Name
   
   
   Figure 4
   
   
9. Click on Save on the Form Builder.
   
   
10. Click on Generate App, select Generate CRUD and click OK (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)
    
    
    Figure 5
    
    
13. Head back to the Design App.
    
    
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
    
    
    Figure 6
    
    
15. Click on Save and you will be directed to the  Form Builder. 
    
    
16. Drag and drop a Select Box element on to the canvas.
    
    
17. Click  on the Select Box element on the canvas to open up the Configure Select Box properties. 
    
    
18. To Save any changes in any Configuration Properties, Click on Apply Change.
19. Fill up the Configure Select Box properties as follows (see Figure 7):
    1. Label: Choose record from Form A
       1. Choose Options Binder: Form Data
          
          
20. Fill up the Configure Select Box properties as follows(see Figure 7):
    
    1. ID: field1
    2. Form: Form A
    3. Label Column: name
    
    
    Figure 7
    
    
21. Drag and drop an AJAX Subform element on to the canvas.
    
    
22. Click on the AJAX Subform element on the canvas to open up the Configure AJAX Subform properties.
    
    
23. Fill up the Configure AJAX Subform properties as follows (see Figure 8):
    1. Form: Form A
    
    
    
24. Tick the first three checkboxes (see Figure 8)
    a. Reload Subform When Parent Field Value Change
    b. Readonly
    c. Display Field as Label When Readonly? 
    

      Figure 8

     24. Fill up the Configure AJAX Subform properties as follows (see Figure 8):

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

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

AJAX Subform Properties

Configure AJAX Subform 

UI

General

Collapsible Setting

Data & Binder

Data Linkage

Data Store

Related Video Tutorials

Download Demo App

Download the demo app with examples on using Ajax Subform with two options: 'JDBC SQL query' and ' Workflow Form Binder':

• APP_ajax_subform_jdbc_dx_kb.jwa