Column Addition

Perform calculations on numeric columns originating from a source record

Specs

Label	Value
Version	0.1.0 (updated on 2023-12-08)
Developer	Labii Inc.
Type	Column
Support Configuration	Yes
Support Readonly view	Yes
Support Edit view	Yes
Support Form view	Yes
Support Default data	Yes
Support Import	Yes
Allow multiple	Yes

Overview

The Labii Column Addition widget is designed to perform calculations on numeric columns originating from a source record, defined by a ForeignKey widget. This powerful feature enables users to effortlessly manipulate and perform calculations on specified numeric data columns associated with interconnected records.

Use case

1. Update the stock quantity after checkin/checkout.

Configuration

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

• Source column - To define the data source, select one of the ForeignKey columns.

• Field Quantity - Choose a quantity column to be updated. The value of the column have to be numeric.

• Calculation - How do you want to change the quantity value. Default to addition.

• Other configurations same as the Number widget.

Examples:

{
    "column": {
        "sid": "xxx",
        "name": "source"
    },
    "quantity": {
        "sid": "xxx",
        "name": "quantity"
    },
    "calculation": "subtraction",
    "format": {
        "thousand": ","
    },
    "constraints": {
        "min": 0
    }
}

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.

The change of the value will trigger the addition/subtraction of the source column.

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

Numeric value.

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 a number.

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 a number.