Column Data

Display data from another record defined in the source

Specs

Label	Value
Version	0.1.0 (updated on 2024-01-21)
Developer	Labii Inc.
Type	Column
Support Configuration	Yes
Support Readonly view	Yes
Support Edit view	No
Support Form view	No
Support Default data	No
Support Import	No
Allow multiple	Yes

Overview

The Column Data widget is designed to display data from another record in a source. It differs from the Column Citation widget as it saves a copy of the data in the widget for quick loading. This widget is particularly useful for displaying text-type data, and it can be automatically updated to reflect changes in the source.

Use case

1. Stock checkout: Display the same unit as the stock using the Column Data widget.

Configuration

To enable the widget's functionality, it requires the provision of options. Each option comprises the following fields:

• Source column: Select one of the ForeignKey columns to define the data source.

• Field: Choose the field you want to display.

• Should auto update: If checked, the widget will reload data from the source.

Examples:

{
    "column": {"sid":"", "name":""},
    "field": "name",
    "should_auto_update": false
}

Views

See the interface of the widget in the following views.

Readonly view

Readonly view display the values of the column.

Edit view

The Edit view is the interface that allows you to modify the value.

Edit view is not supported.

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 not supported.

Data

Each widget in Labii stores data in a unique manner; refer below to understand how data from this widget is stored.

Data format

Same data format as the source record field. It can be anything but mostly the text.

Default value

The Default Value field within the column allows you to specify the default value when a record is created.

You can assign any data type as the default value, but it is advisable not to set a default value as it might hinder the widget from loading data from the source.

Import value

The Import Value is the value you need to include in your Excel table for it to be imported into Labii.

You can assign any data type as the import value, but it is advisable not to set a import value as it might hinder the widget from loading data from the source.