Overview

Column widgets are used for defining and customizing structured data. They are similar to the data types in mysql, but are more powerful in that functions can be attached.

Labii ELN & LIMS currently provides these widgets:

Basic

Basic widget to provide certain types of data.

Text

Use this widget to edit text value. There is no length limit on how much text you can provide.

​​​

Number

Use this widget to edit numeric value. The value can be positive (+), negative (-), integer, or float.

​​​

Select

Use this widget to choose a value from dropdown list. The items of dropdown list are defined in the default value field of column settings. The widget can be used for controlled vocabulary.

​​​

MultiSelect

Use this widget to choose multiple values from dropdown list. It is identical to Select widget except that more than one value can be selected.

​​​

Boolean

Use this widget to edit boolean value.

​​​

Secret

Use this widget to hide sensitive data. The value will be displayed as "****". Use it for password or salary, etc.

​​​

To display the hidden value, click "view" icon to display.

​​

Formula

Use this widget to display value calculated based on a formula. The formula shall be defined in the Default Value of the column.

​​

​​

Syntax

[Field 1] + [Field 2]

Wheres, Field is the sid of a column. For example

• [8adg0a40x52520ejotyDI] + [69be0a40x52508chmrwBG]

• [8adg0a40x52520ejotyDI].substring(1,2)

• [8adg0a40x52520ejotyDI].substring(1,3) == "ATCG" ? "Good" : "Bad"

Operator

• + Addition, a + b

• - Subtraction,

• * Multiplication

• ** Exponentiation (ES2016)

• / Division

• % Modulus (Remainder)

• Priority calculate with () is supported, (100 + 50) * a;

• If condition: true ? a : b, if the condition is true, then return a, else, return b

• Substring: string.substring(start, end)

• Case:

  • Upper: str.toUpperCase()

  • Lower: str.toLowerCase()

• Date: new Date(dateString), learn more at here.

• ​Math:

  • abs(x) Returns the absolute value of x

  • acos(x) Returns the arccosine of x, in radians

  • asin(x) Returns the arcsine of x, in radians

  • atan(x) Returns the arctangent of x as a numeric value between -PI/2 and PI/2 radians

  • atan2(y, x) Returns the arctangent of the quotient of its arguments

  • ceil(x) Returns the value of x rounded up to its nearest integer

  • cos(x) Returns the cosine of x (x is in radians)

  • exp(x) Returns the value of Ex

  • floor(x) Returns the value of x rounded down to its nearest integer

  • log(x) Returns the natural logarithm (base E) of x

  • max(x, y, z, ..., n) Returns the number with the highest value

  • min(x, y, z, ..., n) Returns the number with the lowest value

  • pow(x, y) Returns the value of x to the power of y

  • random() Returns a random number between 0 and 1

  • round(x) Returns the value of x rounded to its nearest integer

  • sin(x) Returns the sine of x (x is in radians)

  • sqrt(x) Returns the square root of x

  • tan(x) Returns the tangent of an angle

Count

Use this widget to display the count of a link. For example, the number of biospecimens generated from a host.

To make it work, provide a link (without domain) into column default value.

​​

​​

Variables

Some variables can be added to the link. The widget will replace it for you:

• {{ROW:SID}}, the sid of the current record.

Consumption

Use this widget to display the remaining volume of a sample or reagent.

Requirements:

• Column "Volume Value" with Number widget

• Table "Consumption"

  • Column "Sample" or "Reagent" with ForeignKey widget

  • Column "Amount" with Number widget

Default Value:

The consumption widget requires JSON format default values as below:

• volume_value__sid - the sid of the column "Volume Value"

• consumption_sample__sid - the sid of the column "Sample" or "Reagent" from the consumption table

• consumption_amount__sid - the sid of the column "Amount" from the consumption table

• threshold - the color of the value will turn red if remaining value lower than the threshold

{
    "volume_value__sid":"RUX10a40x94dcTY49dins", 
    "consumption_sample__sid":"KNQT0a40x94d5MRW27bgl", 
    "consumption_amount__sid":"MPSV0a40x94d7OTY49din", 
    "threshold":10
}

​​​

Image

Use this widget to display the image of a record. For example, display the molecular structure of a chemical.

To delete the image, click the edit icon and then click X.

​​

​​

ForeignKey

ForeignKey is a group of widgets to link one record with one or many other records.

ForeignKey

Use this widget to link to one other record. The linked record is clickable.

​​​

ForeignKeys

Use this widget to link to many other records. The usage is same to ForeignKey.

​​​

Member

A group of widgets to manage member related functions.

Member

Use this widget to choose a member. Use this widget to assign task to a member.

​​​

Members

Use this widget to choose multiple members. The usage is save to Member widget.

​​​

MemberEmail

Use this widget to choose a member. It is the same as Member widget except it will send an email notification to the member.

​​​

MemberEmails

Use this widget to choose multiple members. It is the same as Members widget except it will send an email notification to all selected members.

​​​

DateTime

A group of widgets to handle date and time value.

Date

Use this widget to edit date value. A date picker is provided to select date.

​​​

Time

Use this widget to pick a time. Currently, Labii supports time in 30-min intervals.

​​​

DateTime

Use this widget to pick a date and time. This widget is the combination of Date and Time widget.

​​​

Appointment

Use this widget to set appointment and add the appointment calendar. Currently, Google calendar is supported.

​​​

Chemistry

Chemistry related widgets

Chemical Structure

Use this widget to display the chemical structure. This widget could not create/draw chemical structure, it can only display the chemical structure from a chemical drawing section.

​​

​​

SMILES Structure

This widget uses Smiles Drawer to draw the chemical structure from SMILES.

​​

​​

Molecular Formula

This widget can:

1. Generate molecular formula from the name

2. Generate molecular weight

3. Generate SMILES (Simplified molecular-input line-entry system)

4. Generate molecular structure

Before using this widget, these columns need to be created, and the corresponding name_system needs to be selected. The default chemical table will create these columns automatically.

• molecular_weight

• SMILES

• molecular_structure

Some function of chemcalc is used for this widget.

ChemCalc: a building block for tomorrow’s chemical infrastructure. Patiny, Luc; Borel, Alain Journal of Chemical Information and Modeling 2013. DOI:10.1021/ci300563h

Click the Generate button to get the molecular formula directly from the name.

​​

Click the convert icon to generate the molecular weight, SMILES, and molecular structure.

​​

​