ForeignKeys
Akin to the ForeignKey widget but offers the capacity to link to one or multiple other records.
Specs
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.
The widget allows users to add a new record if it does not already exist. To add a new record, click the “Add XXX” button. This will open a form to collect the necessary information for the record. Once the record is added, the page will redirect back to the original view.
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
