How to work with Related Objects
Last updated
Last updated
Related objects are objects referred to the current one via their lookup fields (or another similar way). Because of many records belong to related objects can be linked to the same record of current object, we should use only one of them. We need to specify:
related object itself
conditions that should restrict related object records
sorting order
The top first record from the related object that match condition will be used as a Data Source.
Go to "Data Source Configuration" and click "Add Object" button.
Select related object, to configure condition for current related object click "Add Condition". Row with new condition form will be shown. Click button to choose field. Select "Operator", "Type" and "Value" for condition.
To configure sorting order for current related object click "Add Order". Row with new order form will be shown. Click button to select Field for sorting. Select order type and specify nulls logic (how fields without data will be sorted - shown last or first).
Fields from related object can be set in kanban cards using merge fields.
Go to Compact Layout editor, add necessary element and use related object fields on it:
Related object fields are available in the formula builder. Proper notification will remind user configure related object on columns: