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

Concatenate values having id equal to other databasejoin element

Discussion in 'Community' started by enrb, Nov 25, 2021.

  1. enrb

    enrb Member

    Level: Community
    Good morning,

    I have a form with a databasejoin element that stores the id of the choice as a value.

    Is it possible to have under a calc element that returns me as a result the concatenated value of other elements having id equal to the databasejoin element chosen just above?
     
  2. troester

    troester Well-Known Member Staff Member

    Level: Community
    That's how a databasejoin is working: storing the value.
    You can use the id ({your-dbjoin_raw}) in a calc and run a query.
    But why don't you use the databasejoin's "Or concat label" to show concatenated columns?
     

Share This Page