Use value from dynamic DB dropdown 1 as where condition in dynamic DB dropdown 2

How to filter a second dynamic dropdown based on the first dropdown's selection in ChronoForms 6.

Overview

The issue occurs because the 'Set Dynamic Options' Ajax event available in CF5 is not present in CF6.
Use the method described in the linked forum thread to create a dependency where the second dropdown's query includes a WHERE condition based on the first dropdown's selected value.

Answered
ChronoForms v6
er erikjo 27 Jul, 2017
Hi,

I got this working with CF5, however it stopped working and now I want to build the following with CF6 straight away:

Dropdown 1 "Country" is populated from a DB table with the list of countries.
Dropdown 2 "Competitions" is populated also from a DB table with the list of competitions, but it should display only those competitions from the particular country value, which was selected in Dropdown 1.

Could somebody please give advice, how to build this linkage in CF6? In CF5 it worked with the Ajax Event "Set Dynamic Options" in Dropdown Event settings, but I miss this action in CF6.

Thanks and regards,
Erik
er erikjo 28 Jul, 2017
Hello,

has no one else had the same requirement for his dropdown fields and found a solution?
I screened all the forum threads re CF6, plus the new manual and FAQs - however I cannot find the solution.

I would also buy you a coffee - this is a major showstopper that prevents me from further develop my own match tracker app on my website.

Any advise or help would be much appreciated.

Thanks,
Erik
HC HCH 29 Jul, 2017
Answer
1 Likes
Hello erikjo,

I cannot help you in detail, because I'm actually not firm in this. But perhaps you find some answer in the thread https://www.chronoengine.com/forums/posts/t103555/2-dynamic-dropdonw-based-on-db-table.html that seems to have the same question.

Regards,
Hans-Christian
er erikjo 31 Jul, 2017
Hello Hans-Christian,

thanks a lot for pointing me to the exact similar issue. Just need to figure out the instruction in the correct way.

Will ask in the other thread.

Regards,
Erik
This topic is locked and no more replies can be posted.