• Payment Plugins Poll

    We need your feedback on the need for updated payment plugins. Please go here and give us your feedback.

  • Joomla 5.1

    For running J!5.1 you must install Fabrik 4.1
    See also Announcements

  • Subscription and download (Fabrik 4.1 for J!4.2+ and J!5.1) are working now

    See Announcement
    Please post subscription questions and issues here

    We have resolved the issue with the J! updater and this will be fixed in the next release.

  • Update & Changlog URL Fixer

    At the present time the update site URL for Fabrik is incorrect in all installations up to and including 4.1. This will be corrected in 4.2, however, if you wish to update Fabrik via the J! Updater you can download and install this plugin.

    This file is installed just like any other extension through the J! Extension Installation panel. It will not however actually install anything. Its sole purpose is to fix the Update Site and Changlog URL's. Once done it will simply exit.

    As always, we recommend you perform a site backup priot to installation.

List Related data

  • Views Views: 22,595
  • Last updated Last updated:

Navigation

  • When you create a database join element in another list which points to the current list you are editing (e.g. you create a 'country' Database join element in the 'regions' list), Fabrik can automatically provide 'related data' links in Lists and Forms.

    Settings​

    The related data section becomes populated as follows:

    list-data-related.png


    • Show related Add -
      • Setting this to Yes will always show an Add link
      • setting to NO will NEVER show an add link
      • Setting to ONLY IF EMPTY will show the add link only if the record count is 0.
    • Show related data link - If this form's table has related data links set up, and you select yes for this option then each of those related data links will also appear at the top of the form
    Links to Lists
    • Table - the table that contains a Database join element pointing to the current table you are editing
    • Link to list - if you select 'yes' then a column will be added to your table. This column will contain a link which will take you to the related table, filtering its results based on the current row's primary key.
      E.g:
      Your table is called 'Countries' and the related table is 'Regions'
      Regions has a Database join element to list which country it belongs to
      Activating the 'Regions' link to table option will create a link which for each listed country will show its associated regions
    • Heading- the link to table's label - e.g. 'Regions'
    • Button text - the text that appears in each cell - can use {Placeholders}
    • Popup-
      • No - the link will open in the same page
      • Yes - the link will open in a popup window
    Links to Forms:​
    • Link to form - creates a new column with a link to the related table's form. The Database join element will be pre-filled with the active records value.
      E.g.
      Your table is called 'countries' and the related table is 'regions'
      For the country 'UK' You click on the link 'add region'
      The regions form appears and its 'country' Database join element is pre-filled with UK as the desired country.
    • Heading- the link to form's heading- e.g. 'Add a region'
    • Button text- the link to form's label - e.g. 'add a region to {countries___label}'. You can use {Placeholders}
    • Popup -
      • No - the link will open in the same page
      • Yes - the link will open in a popup window
    Below is an example of the two related data columns:

    list-related-data-example.png
Back
Top