Column Data
Display data from another record defined in the source
Last updated
Display data from another record defined in the source
Last updated
Version
1.1.0 (updated on 2025-04-14)
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
The Column Data widget is designed to display data from another record in a source. It differs from the 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.
Stock checkout: Display the same unit as the stock using the Column Data widget.
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.
Stop condition: The formula will stop calculation when the condition is met. It must return a true
or false
value. This field does not support other column data, you can only use the variable data
to reference the current record data.
Should auto update: If checked, the widget will reload data from the source.
Should auto update when readonly - If checked, this widget will perform a live calculation when readonly.
See the interface of the widget in the following views.
Readonly view display the values of the column.
The Edit view is the interface that allows you to modify the value.
Edit view is not supported.
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.
Each widget in Labii stores data in a unique manner; refer below to understand how data from this widget is stored.
Same data format as the source record field. It can be anything but mostly the text.
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.
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.