Question & Answer > View Question

Populate third drop down box basedon selection of other two drop downs

Confluence User - 20 Sep, 2018

Hi experts,

I am using Joget v6 community edition.

I have three select boxes in my form.

Second drop down should populate based on the selected value from first drop down

and third drop down should populate based on second drop down selection.

In the second drop down, I am using 'Default options binder' and given the grouping field as 'first dropdown field' and ,Second drop down is working fine .

And for the third drop down also I am using ''Default options binder" . I am not sure how to give grouping field for this drop down.

Can anyone please let me know how can i do this.

Thanks in advance..

forms;selectbox

1

Confluence User •

23 Sep, 2018 •

confluenceUser •

•

confluenceUser •

Hi

Use JDBC Binder in Option Binder, and use simple quires to populate combo boxes

for example we have three combo boxes which is retrieved data for a database table, 3rd one is dependent on 2nd one and 2nd one depends on 1st one, boxes name are src_tag1, src_tag2, src_tag3

Query for first box ->

select distinct tag1, tag1 from tag_sheet
order by tag1

Query for 2nd box ->

select distinct concat(tag1, ',', tag2), tag2, tag1
from tag_sheet
where tag1 = ?
order by tag2

mention "src_tag1" in Field ID to control available options based on Grouping in Dependency Portion

Query for 3rd box ->

select distinct concat(tag1, ',', tag2, ',', tag3), tag3, tag2
from tag_sheet
where concat(tag1, ',', tag2) = ?
order by tag3

mention "src_tag2" in Field ID to control available options based on Grouping in Dependency Portion

and so on .........

Regards,

1

CSV | Excel | XML | PDF

Your answer

Print

Populate third drop down box basedon selection of other two drop downs

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

1.builder-style-1e98dcaf-188b-40c4-bc9e-fc9e8991afe1{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-12fcd5b2-2159-4384-b6a0-f5307a0f3408{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

1

Your answer