ForeignKeys
Akin to the ForeignKey widget but offers the capacity to link to one or multiple other records.
Specs
| Label | Value |
|---|---|
Version | 1.1.0 (updated on 2024-03-11) |
Developer | Labii Inc. |
Type | Column |
Support Configuration | Yes |
Support Readonly view | Yes |
Support Edit view | Yes |
Support Form view | Yes |
Support Default value | Yes |
Support Import | Yes |
Allow multiple | Yes |
Overview
The ForeignKeys widget within Labii operates akin to the ForeignKey widget but offers the capacity to link to one or multiple other records. This versatile widget establishes connections to multiple related data sets, allowing users to create clickable links to these associated records. This functionality enables a dynamic and comprehensive interlinking of data, facilitating efficient navigation and exploration of interconnected information within the Labii platform.
Use case
Use this widget to define what other jobs related to the current job.
Configuration
The widget will function without additional setup. However, the configuration options empower you to impose additional restrictions on the tables to which the linked data can be associated. Leave it empty to include all tables.
Tables - Select one or more tables to link.
Examples:
Views
See the interface of the widget in the following views.
Readonly view
Readonly view display the values of the column.
A button for List view will be accessible to open all items listed when the widget is directed to a single table.
Edit view
The Edit view is the interface that allows you to modify the value.
Form view
The Form view is the field integrated into the add form for collecting values when creating a new record.
The Form view is same as the Edit view.
Data
Each widget in Labii stores data in a unique manner; refer below to understand how data from this widget is stored.
Data format
JSON array with keys of sid and name:
Default value
The Default Value field within the column allows you to specify the default value when a record is created.
Default value shall be the name or UID separated by comma(,).
Import value
The Import Value is the value you need to include in your Excel table for it to be imported into Labii.
Import value shall be the name or UID separated by comma(,).
Last updated
