1. NOTICE: If you are using Fabrik and update to Joomla 3.10, you will need to update to Fabrik 3.10. And, if you are using Fabrik, do not upgrade to Joomla 4, we do not have a supported version ready for release. More information on a release date coming soon. Also, please note that Fabrik 3.10 will not install on any Joomla sites less than 3.8.
    Dismiss Notice

How to pupolate a 'cascading dropdown' with 2 dropdowns filters

Discussion in 'Community' started by linque, May 19, 2022.

  1. linque

    linque New Member

    Level: Community
    I've a list with 4 fields.
    upload_2022-5-19_20-43-44.png

    The First (champid) is a databasejoin.
    The Second (champ_ed) is a cascadingdropdown depending on the First.
    The Third (champ_edcat) is a cascadingdropdown depending on the First and the Second.

    upload_2022-5-19_20-47-9.png

    How to do ?
     
  2. lousyfool

    lousyfool Well-Known Member

    Level: Community
    You mean filter options dynamically appearing depending on another filter's option? Sorry, that's not available in Fabrik out of the box.
     
  3. linque

    linque New Member

    Level: Community
    The second Dropdown is dynamic when I choose the first.
    I can have the Third dynamic when i choose the first.

    upload_2022-5-19_21-27-50.png

    If I choose the second one in the 'Watch tab',the Third Dropdown is empty.

    If it's not posible like it, can I use the 2nd choice to put it in 'Advance tab' in the 'Where query' clause ?
    like it for example :
    upload_2022-5-19_21-30-49.png
     
  4. linque

    linque New Member

    Level: Community
    Or how Can I do if I have not only 'Country' and 'Region' but 'Continent', 'Country', 'Region' and 'City' ?
     
  5. lousyfool

    lousyfool Well-Known Member

    Level: Community
    Oh, so we're not talking "filters"(above a list), but "form" (as in "add/edit records")?

    In that case:
    Instead of cascading dropdowns you can also use databasejoins, there enable "AJAX Update" and use the placeholder of the element it depends on in the "WHERE" clause.
    Wiki: http://fabrikar.com/forums/index.php?wiki/database-join-element
     

Share This Page