Thu, 24 Sep 2026
Login

How to display value from JDBC query in Spreadsheet

Confluence User - 25 Apr, 2022

Hi,


I got one query which is call from MSSQL (query set in load binder: JDBC binder). 

SELECT TrxRem1 as 'A',TrxRem1 as 'A'
FROM cb.dbo.pp WHERE TNo = 'pp012200040'

How to display this result in spreadsheet drop down?

Had tried follow guide in JDBC Form Binder but, the dropdown not display any value.(sad)

TQ (smile)

forms;spreadsheet;jdbcbinder;dropdown

2

Confluence User •
25 Apr, 2022 •
confluenceUser •
•
confluenceUser •

In your spreadsheet column set up, your column name need to be 'A' since your data set is return the columns as such.

Confluence User •
25 Apr, 2022 •
confluenceUser •
•
confluenceUser •

In spreadsheet column I did declare the column name and label as A, format type as Dropdown and Format as 'Child'. Im not sure on format, so I follow as guide in JDBC Form Binder..

But once O preview, the value still not in drop down.

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