Thu, 24 Sep 2026
Login

How to display multiple rows of data in the spreadsheet of an ajax sub-form?

Confluence User - 14 May, 2022

How can I display multiple rows of data in the spreadsheet of an ajax sub-form which is linked to the multi-select box?

eg. when I select 2 different order numbers from the multi-select drop-down box, the details of both should be displayed in the spreadsheet in separate rows.

spreadsheet;forms

3

Confluence User •
14 May, 2022 •
confluenceUser •
•
confluenceUser •

When you use a multiselect box it stores semi colon separated (;) value. E.g Value1;Value2;Value3
If you Ajax is working on multiselect box and you are getting ids of the rows that you want to display in the spreadsheet then:
You need to user jdbc binder, write an sql query that can display the records of semi colon separated ids into separate rows  

Confluence User •
14 May, 2022 •
confluenceUser •
•
confluenceUser •

Thank you Anas Misbah Shami for your reply.


I have written an SQL query that fetches the data from the table view. But the spreadsheet displays the details of only one of the order numbers selected from the multi-select drop-down.

Confluence User •
14 May, 2022 •
confluenceUser •
•
confluenceUser •

There must be wrong something with the query. Have you tried running the query in heidisql?

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
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
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print