1. Fabrik 3.7 is now available. This version contains critical security updates, please update as soon as possible. Please remember to backup your site before updating, we also recommend testing your updates on development sites if possible.
  2. We had to restore the site around midday (CST) on Wed 7/26 from a backup approximately 8 hours old. So a few posts in the forums were lost. You may want to check to see if you need to re-post anything.
  3. The release of Fabrik for J! 3.8 is not yet ready. Do not update your sites to J! 3.8 until this notice is removed.

Related data

Aug 21, 2013
Related data
  • 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 (top)

    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(top)

    • 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:(top)

    • 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
  • Loading...