Thu, 24 Sep 2026
Login

Can I load data from Form in Joget App.

Confluence User - 22 Oct, 2018

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

ajax;ajaxsubform;forms;database

2

Confluence User •
23 Oct, 2018 •
confluenceUser •
•
confluenceUser •

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!

Confluence User •
23 Oct, 2018 •
confluenceUser •
•
confluenceUser •

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

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
How can I set dedicated datasource for each app ?
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Issue Saving AJAX Subform Data to Datalist in Joget
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print