Can I load data from Form in Joget App.

 
1
0
-1

Dear Expert,

 

I have 3 from in Application (attached .jwa)

1st form = Car data (CarID, Car Owner)

       Example

               BA 0001, AAAA

               BA 0002, BBBB

               BA 0003, CCCC

2nd form = Car Device data (Serial Number, CardID, Device Name)

              Serial1, BA 0001, Samsung Tablet

              Serial2, BA 0001, CAR TV

              Serial3, BA 0001, CAR RADIO

 

3rd form = Car Check List

 In 3rd form I have

        Multi select box  (JDBC Query to List Car Data from 1st form)

        AJAX Subform to show data from (1st Form) 

 

My Question is How can I list all device in 2nd form, that belong to selected CarID from the selected box.

from example, I need the listed of all device name (Samsung Tablet, CAR TV, CAR RADIO) which is in Car BA 0001.

Attached are .jwa for this

APP_CarAsset-1-20181022175559.jwa

 

Please help

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Dear Justin, Thank for your answer, but I need all serial number from 2nd form, and return to main form or Workflow variable.

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hey there,

        For your AJAX Subform, edit the properties, go to Data & Binder, under the Data Linkage tab, you can make use of this field, Parent Field to keep Subform ID. In this field, type in the form field ID of your multi-select box or any select box that contains the record ID for the subform to display the record data.

        Hope this helps!

          CommentAdd your comment...