Examples

Changed in version 12.0: Inline fields should not be used anymore to handle files. Use the TCA column type file instead.

Simple 1:n relation

../../../_images/Inline1nInline1.png

This combines a table (for example companies) with a child table (for example employees).

EXT:styleguide/Configuration/TCA/tx_styleguide_inline_1n.php
[
    'columns' => [
        'inline_1' => [
            'label' => 'inline_1 description',
            'description' => 'field description',
            'config' => [
                'type' => 'inline',
                'foreign_table' => 'tx_styleguide_inline_1n_inline_1_child',
                'foreign_field' => 'parentid',
                'foreign_table_field' => 'parenttable',
                'appearance' => [
                    'showSynchronizationLink' => true,
                    'showAllLocalizationLink' => true,
                    'showPossibleLocalizationRecords' => true,
                ],
            ],
        ],
    ],
]

Attributes on anti-symmetric intermediate table

../../../_images/Inline1n1nInline1.png

The record has two child records displayed inline.

This example combines records from a parent table tx_styleguide_inline_mn with records from the child table tx_styleguide_inline_mn_child using the intermediate table tx_styleguide_inline_mn_mm. It is also possible to add attributes to every relation – in this example a checkbox.

The parent table tx_styleguide_inline_mn contains the following column:

EXT:styleguide/Configuration/TCA/tx_styleguide_inline_mn.php
[
    'columns' => [
        'inline_1' => [
            'label' => 'inline_1',
            'config' => [
                'type' => 'inline',
                'foreign_table' => 'tx_styleguide_inline_mn_mm',
                'foreign_field' => 'parentid',
                'foreign_sortby' => 'parentsort',
                'foreign_label' => 'childid',
                'appearance' => [
                    'showSynchronizationLink' => 1,
                    'showAllLocalizationLink' => 1,
                    'showPossibleLocalizationRecords' => 1,
                ],
            ],
        ],
    ],
]

If the child table tx_styleguide_inline_mn_child wants to display its parents also it needs to define a column like in this example:

EXT:styleguide/Configuration/TCA/tx_styleguide_inline_mn_child.php
[
    'columns' => [
        'parents' => [
            'label' => 'parents',
            'config' => [
                'type' => 'inline',
                'foreign_table' => 'tx_styleguide_inline_mn_mm',
                'foreign_field' => 'childid',
                'foreign_sortby' => 'childsort',
                'foreign_label' => 'parentid',
                'maxitems' => 10,
                'appearance' => [
                    'showSynchronizationLink' => 1,
                    'showAllLocalizationLink' => 1,
                    'showPossibleLocalizationRecords' => 1,
                ],
            ],
        ],
    ],
]

The intermediate table tx_styleguide_inline_mn_mm defines the following fields:

EXT:styleguide/Configuration/TCA/tx_styleguide_inline_mn_mm.php
return [
   'columns' => [
      'parentid' => [
         'label' => 'parentid',
         'config' => [
            'type' => 'select',
            'renderType' => 'selectSingle',
            'foreign_table' => 'tx_styleguide_inline_mn',
            'foreign_table_where' => 'AND {#tx_styleguide_inline_mn}.{#pid}=###CURRENT_PID### AND {#tx_styleguide_inline_mn}.{#sys_language_uid}=\'###REC_FIELD_sys_language_uid###\'',
            'maxitems' => 1,
            'localizeReferences' => 1,
         ],
      ],
      'childid' => [
         'label' => 'childid',
         'config' => [
            'type' => 'select',
            'renderType' => 'selectSingle',
            'foreign_table' => 'tx_styleguide_inline_mn_child',
            'foreign_table_where' => 'AND {#tx_styleguide_inline_mn_child}.{#pid}=###CURRENT_PID### AND {#tx_styleguide_inline_mn_child}.{#sys_language_uid}=\'###REC_FIELD_sys_language_uid###\'',
            'maxitems' => 1,
            'localizeReferences' => 1,
         ],
      ],
      'parentsort' => [
         'config' => [
            'type' => 'passthrough',
         ],
      ],
      'childsort' => [
         'config' => [
            'type' => 'passthrough',
         ],
      ],
   ]
];

Attributes on symmetric intermediate table

../../../_images/InlineMnSymmetric11Branches.png

Record 1 is related to records 6 and 11 of the same table

This example combines records of the same table with each other. Image we want to store relationships between hotels. Symmetric relations combine records of one table with each other. If record A is related to record B then record B is also related to record A. However, the records are not stored in groups. If record A is related to B and C, B doesn't have to be related to C.

../../../_images/InlineMnSymmetric11Branches.png

Record 11 is symmetrically related to record 1 but not to 6

The main table tx_styleguide_inline_mnsymmetric has a field storing the inline relation, here: branches.

EXT:styleguide/Configuration/TCA/tx_styleguide_inline_mnsymmetric.php
[
    'columns' => [
        'branches' => [
            'label' => 'branches',
            'config' => [
                'type' => 'inline',
                'foreign_table' => 'tx_styleguide_inline_mnsymmetric_mm',
                'foreign_field' => 'hotelid',
                'foreign_sortby' => 'hotelsort',
                'foreign_label' => 'branchid',
                'symmetric_field' => 'branchid',
                'symmetric_sortby' => 'branchsort',
                'symmetric_label' => 'hotelid',
                'maxitems' => 10,
                'appearance' => [
                    'showSynchronizationLink' => 1,
                    'showAllLocalizationLink' => 1,
                    'showPossibleLocalizationRecords' => 1,
                ],
            ],
        ],
    ],
]

Records of the main table can than have a symmetric relationship to each other using the intermediate table tx_styleguide_inline_mnsymmetric_mm.

The intermediate table stores the uids of both sides of the relation in hotelid and branchid. Furthermore custom sorting can be defined in both directions.

EXT:styleguide/Configuration/TCA/tx_styleguide_inline_mnsymmetric_mm.php
[
   'columns' => [
      'input_1' => [
         'exclude' => 1,
         'l10n_mode' => 'prefixLangTitle',
         'label' => 'input_1',
         'config' => [
            'type' => 'input',
            'size' => '30',
            'eval' => 'required',
         ],
      ],
      'branches' => [
         'exclude' => 1,
         'label' => 'branches',
         'config' => [
            'type' => 'inline',
            'foreign_table' => 'tx_styleguide_inline_mnsymmetric_mm',
            'foreign_field' => 'hotelid',
            'foreign_sortby' => 'hotelsort',
            'foreign_label' => 'branchid',
            'symmetric_field' => 'branchid',
            'symmetric_sortby' => 'branchsort',
            'symmetric_label' => 'hotelid',
            'maxitems' => 10,
            'appearance' => [
               'showSynchronizationLink' => 1,
               'showAllLocalizationLink' => 1,
               'showPossibleLocalizationRecords' => 1,
            ],
         ],
      ],
   ],
];

Note

TCAdefaults.<table>.pid = <page id> can be used to define the pid of new child records. Thus, it's possible to have special storage folders on a per-table-basis. See the TSconfig reference.

With a combination box

../../../_images/InlineUsecombinationcInline1.png

The combination box shows available records. On clicking one entry it gets added to the parent record.

EXT:styleguide/Configuration/TCA/tx_styleguide_inline_usecombination.php
[
    'columns' => [
        'inline_1' => [
            'label' => 'inline_1',
            'config' => [
                'type' => 'inline',
                'foreign_table' => 'tx_styleguide_inline_usecombination_mm',
                'foreign_field' => 'select_parent',
                'foreign_selector' => 'select_child',
                'foreign_unique' => 'select_child',
                'maxitems' => 9999,
                'autoSizeMax' => 10,
                'appearance' => [
                    'newRecordLinkAddTitle' => 1,
                    'useCombination' => true,
                    'collapseAll' => false,
                    'levelLinksPosition' => 'top',
                    'showSynchronizationLink' => 1,
                    'showPossibleLocalizationRecords' => 1,
                    'showAllLocalizationLink' => 1,
                ],
            ],
        ],
    ],
]

Add a custom fieldInformation

We show a very minimal example which adds a custom fieldInformation for the inline type in tt_content. Adding a fieldWizard is done in a similar way.

As explained in the description, fieldInformation or fieldWizard must be configured within the ctrl for the field type inline - as it is a container.

  1. Create a custom fieldInformation

    EXT:my_extension/Classes/FormEngine/FieldInformation/DemoFieldInformation
       <?php
       declare(strict_types=1);
       namespace Myvendor\Myexample\FormEngine\FieldInformation;
    
       use TYPO3\CMS\Backend\Form\AbstractNode;
    
       class DemoFieldInformation extends AbstractNode
       {
           public function render()
           {
               $result = $this->initializeResultArray();
    
                // Add fieldInformation only for this field name
                //   this may be changed accoringly
                if ($fieldName !== 'my_new_field') {
                    return $result;
                }
                $text = $GLOBALS['LANG']->sL(
                        'LLL:EXT:my_example/Resources/Private/Language/'
                        . 'locallang_db.xlf:tt_content.fieldInformation.demo'
                );
                $result['html'] = $text;
                );
                return $result;
           }
       }
    
  2. Register this node type

    EXT:my_extension/ext_localconf.php
       <?php
       use Myvendor\Myexample\FormEngine\FieldInformation\DemoFieldInformation;
    
       // ...
    
       $GLOBALS['TYPO3_CONF_VARS']['SYS']['formEngine']['nodeRegistry'][1654355506] = [
           'nodeName' => 'demoFieldInformation',
           'priority' => 30,
           'class' => DemoFieldInformation::class,
       ];
    
  3. Add the fieldInformation to the container for containerRenderType inline

    EXT:my_extension/Configuration/TCA/Overrrides/tt_content.php
        $GLOBALS['TCA']['tt_content']['ctrl']['container']['inline']['fieldInformation'] = [
            'demoFieldInformation' => [
                'renderType' => 'demoFieldInformation',
            ],
        ];
    
  4. A field my_new_field is created in the tt_content TCA:

    EXT:my_extension/Configuration/TCA/Overrides/tt_content.php
        'my_new_field2' => [
            'label' => 'inline field with field information',
            'config' => [
                'type' => 'inline',
                // further configuration can be found in the examples above
                // ....
            ],
        ],
        // ...
    

See also