General Column

YW
Last updated 22 days ago

Basic column type widgets

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:

Category

Widget

Type

Description

Basic

Text

Column

Edit text value

Basic

Number

Column

Edit numeric value

Basic

Select

Column

Choose a value from a dropdown

Basic

MultiSelect

Column

Choose multiple value from a dropdown

Basic

Boolean

Column

Edit boolean value

Basic

Secret

Column

Display sensitive value as *

ForeignKey

ForeignKey

Column

Link to one other record

ForeignKey

ForeignKeys

Column

Link to many other records

Member

Member

Column

Choose of a member

Member

Members

Column

Choose of many members

Member

MemberEmail

Column

Choose of a member with email notification

Member

MemberEmails

Column

Choose of many members with email notification

DateTime

Date

Column

Edit date value

DateTime

Time

Column

Choose of a time

DateTime

DateTime

Column

Combination of Date and Time

DateTime

Appointment

Column

Add DateTime to Calendar

Basic

Basic widget to provide certain type 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 is defined in the default value field of column settings. The widget can be used for controlled vocabulary.

Use ___ to separate value and label of a dropdown item. For example, if an item has value of "#000", and you want to label it as "Black", you can set "#000___Black" in the default value field.

MultiSelect

Use this widget to choose multiple value 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.

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.

  • To limit the link to a particular table, use Unique Code in the widget default value. For example, "EP" with limit the widget to only search experiments.

  • To limit the link to one or more tables. Add multiple unique code separated with ",". For example, "EP,SP".

  • The widget is searchable. If you did not find the record you want, type in keywords in the top of dropdown. Currently, the search only goes to the name of a record.

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.

  • Only active member is choosable.

  • The widget is searchable. If you did not find the member you want, type in name in the top of dropdown.

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 same to Member widget except it will send an email notification to the member.

MemberEmails

Use this widget to choose multiple members. It is same to 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 at every 30-min slot.

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 to calendar. Currently Google calendar is supported.