3 dropdown fields dependet

Fredolino 13 Feb, 2020
Hi,

I loaded 3 dropdown fields based on 3 tables with read_data.
The 3 dropdown boxes should now be made dependent. I just wanted to do that in the dropdown boxes under "Events".
What do I have to set?

Thanks in advance.

1. Dropdown / {var:read_data33}
Tabelle1
id_lkr | lkr | landkreise
------------------------
1 | BAR | Barnim
2 | BRB | Brandenburg/Havel
...

2. Dropdown / {var:read_data20}
Tabelle2
id_gem | id_lkr | gemeinde
------------------------
1 | 1 | Ahrensfelde
2 | 2 | Havel
...

3. Dropdown / {var:read_data37}
Tabelle3
id_ot | id_gem | ortsteil
------------------------
1 | 1 | OT Schönwalde
2 | 1 | OT Dumsdorf
3 | 2 | OT Alt Markendorf
...
Fredolino 16 Feb, 2020
Hi
In the meantime I have found out myself that it works with 2 dynamic pages and with the right "Where conditions" and "Fields to retrieve".

The dropdown fields work with the names:

1. DropDown
Name: landkreis

2. DropDown
Name: gemeinde

3. DropDown
Name: ortsteil

But the dropdown fields must have this name:

1. DropDown
Name: Marker[landkreis]

2. DropDown
Name: Marker[gemeinde]


How does it work?
GreyHead 17 Feb, 2020
Hi Fredolino,

As a fix I suggest that you use the names that work and combine the results into an array after the form submits. Does that do what you need?

Bob
Fredolino 17 Feb, 2020
Answer
Hi Bob,

yes, in save_data:
{data:landkreis}
...

Greatings
F.
This topic is locked and no more replies can be posted.