Hello, we are building a form for a fishing club and we want our members to send us their fishing reports and i have some problems with some fields. I want 3 dropdowns (ecosystem, river, location). I have made a second list that contains the data of these 3 options, (i dont know if this is right). The second ccd (river) is depending on the first option (ecosystem) and it works but the 3rd (location) i cant make it work, i only see plese select so i need some help on how i must buld the lists and the elements. i just want the second dropdown depend on the first and the 3rd dropdown depend on the second option. i think it is simple but i am trying one week with no luck
-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
Help with cascading dropdowns
- Thread starter tilbellos
- Start date
cheesegrits
Support Gopher
Can you describe your tables?
I presume they are something like ...
ecosystems:
id, ecosystem
rivers:
id, river, ecosystem_id
locations:
id, location, river_id
... and the "rivers" CDD watches "ecosystems" and uses ecosystem_id as the FK (foreign key), and "locations" watches "rivers", and uses river_id as the FK?
-- hugh
I presume they are something like ...
ecosystems:
id, ecosystem
rivers:
id, river, ecosystem_id
locations:
id, location, river_id
... and the "rivers" CDD watches "ecosystems" and uses ecosystem_id as the FK (foreign key), and "locations" watches "rivers", and uses river_id as the FK?
-- hugh
Thank you for your reply. i have made some changes. We decided that we don't need the 3rd dropdown (locations) so i removed it and now i'm working with ecosystems table and rivers table only but i have some problems understanding how the cdd works.
Table: "Fishing report" (the main form that is showing in the frontend)
Elements:
"ecosystems" databasejoing to ecosystems table (working and showing ecosystems in frontend)
"rivers" cdd - List: rivers, Id: id, Label: river, watch element: ecosystems, FK: ecosystem_id or river - not working with both options
and some other elements (checkboxes etc)
Table "ecosystems"
elements:
id, ecosystems
Table "rivers"
elements:
id, river, ecosystem_id (dbjoin to ecosystems)
Now i have problem with the only cdd (rivers), its not working and i don't know what i am doing wrong
Table: "Fishing report" (the main form that is showing in the frontend)
Elements:
"ecosystems" databasejoing to ecosystems table (working and showing ecosystems in frontend)
"rivers" cdd - List: rivers, Id: id, Label: river, watch element: ecosystems, FK: ecosystem_id or river - not working with both options
and some other elements (checkboxes etc)
Table "ecosystems"
elements:
id, ecosystems
Table "rivers"
elements:
id, river, ecosystem_id (dbjoin to ecosystems)
Now i have problem with the only cdd (rivers), its not working and i don't know what i am doing wrong