Columns
Labii ELN & LIMS uses columns to store a specific type of data for a record. Learn how to manage and create columns within the organization.
A column is a set of data values of a particular sample type, one for each row of the table.
Users within an organization can view Columns for a particular table in 3 ways:
Record list view from the sidebar:
Click table from navbar, select a table from the dropdown list
Select Columns from the sidebar
Table detail page from the sidebar:
Click the menu icon located on the top right of the page
Select settings
Select Tables and choose a table from the list
Click Columns from the sidebar
From the Column list view:
Click the menu icon located on the top right of the page
Select settings
Select Columns
Choose a table from the dropdown list
Click the "+" icon on the top of the navbar.
For Example, select the experiment table to view/customize columns
A column is a set of data values of a particularly simple type, one for each row of the table.
Note: only administrators within an organization can "add a new column."
A new column can be added in the columns list view
Navigate to the columns list view (see above)
Click the "+" icon on the top of the navbar or click the "add column" from the sidebar
Here are the fields to fill out on the “Add Column” form:
Name - required field, letters only for the name of a new column
Description - optional field; provide a description of the column and all other necessary information to help others in the same organization to fill out.
Widget - The widget to use, or the type of data. Default to Text. Check out Settings -> Widgets to install missing widgets. Check out here for a list of widgets
Configuration - The configuration for the widget. The configuration is different for different widgets, please check here for the details. If a JSON is provided, use python JSON format.
Default Value - optional field; used to set the default value of the field
For the Boolean field, the default value is 'false' if not provided. Use 1 for 'true' and 0 for 'false';
For the Select/MultiSelect field, add one item per line as an option. Use '__' to separate the value and label.
For ForeignKey, add the unique code of the table to match. Use ',' to separate multiple matches. If not provided, it will match everything. For example, use “EP” to only match experiments.
For Date, use YYYY-MM-DD.
Order - required field; the order to display the column, numbers only
Is Required - optional; if checked, the value of the column is required in form submitting
Is Hidden - optional; if checked, the column will not display in the list view but will be available for use.
Click submit once finished with all required and optional fields
Columns for a particular table can be viewed and managed from the column list view
On the column list view for the experiment table, the following fields are:
Name - Particular name for the column
Widget - The widget to use, or the type of data; tons of widgets to choose from via dropdown list and the widget store via Labii ELN & LIMS
Default Value - The default value for the field; can be boolean, multi-select, date, etc; Optional field can be blank.
Is Required - If checked, the value of the column is required in form submitting
Is Hidden - If checked, the column will not display in the list view but still is available for use.
Is Archived - Ability to archive particular column and will not be available to use if the box is checked
Table - Shows the table associated with the column
You can edit the fields if it has a pencil icon to the right of a field. For example, you can edit the Name field by clicking the pencil icon to the right, update the name and click submit.
To the left there is the sidebar which contains the following:
Add Column - click here to add a new column
Active/Archived Columns - Click here to view all active and archived columns within the organization
Experiment - Click here to see the experiment settings; viewing this from the experiment table
Sections - Click here to see the sections for the experiment table. Sections are the modules of a document and use sections to insert different types of data. A section holds the data for a widget for one particular record.
Filters - Click here to see all the filters related to the experiment table and ability to create a new filter as well
Workflows - Click here to see if there are any workflows related to the experiment table. Also can add workflow; A workflow consists of an orchestrated and repeatable pattern of activity, enabled by the systematic organization of resources into processes that transform materials, provide services, or process information
Tables - Click here to see all the tables associated with an organization
Experiment List - Click here to see all the experiments within an organization as a list view
Help - Dedicated support page with information on everything Labii ELN & LIMS, how-to guide, tutorial videos, and more
Send Feedback - Click here whenever you have a feature request or would like to submit feedback on how we can improve the platform
On the top of the page, there is the navbar which has the following:
“+” - Click to add a new column (the same function as the “add column” on the sidebar)
Search - Click the “search” icon to quickly find a specific column
Menu Drop List - Click on the “Menu” icon:
Ability to import and export
Links to quickly see all, active, or archived columns, experiments, sections, filters, and more.
Help - our dedicated support page with documentation/screenshots/videos
Ability to change the number of records per page
Starting at 10 up to 2000 per page
To see an overview of a particular column:
Navigate to the column list view using the method above
Click on the name of a particular column; “it will be in blue font indicating you can click to see more.”
For example, click on the date_start column name and here are the overview fields for the “Date_Start” column (note - the fields below can be updated without leaving the page by clicking the pencil icon to the right of each field):
Name - The name of the column
Description - Provide a description of the column and all other necessary information to help others in the same organization to fill out
Widget - The widget to use, or the type of data; tons of widgets to choose from via dropdown list and the widget store via Labii ELN & LIMS
Default Value - optional field; used to set the default value of the field
For Boolean field, the default value is 'false' if not provided. Use 1 for 'true' and 0 for 'false';
For Select/MultiSelect field, add one item per line as options. Use '_' to separate the value and label.
For ForeignKey, add the unique code of the table to match. Use ',' to separate multiple matches. If not provided, it will match everything.
For Date, use YYYY-MM-DD.
Order - required field; the order to display the column, numbers only
Is Required - optional; if checked, the value of the column is required in form submitting
Is Hidden - optional; if checked, the column will not display in the list view but will be available for use.
Add Metadata - Can add metadata by providing the label and value properties
Is Archived - Ability to archive this particular column and will not be available to use if marked true.
Date Created - Automatically captured in the background of Labii ELN & LIMS in real-time
Staying within the column “date_start” overview page, there is the sidebar to the left which contains the following:
Columns (experiment) - Click here to see the columns for the “experiment table.” A column is a set of data values of a particular sample type, one for reach row of the table
Table (experiment) - Click here to see the overview of the experiment table
Tables - Click here to see all the tables associated with an organization
Experiment List - Click here to see all the experiments within an organization as a list view
Help - Dedicated support page with information on everything Labii ELN & LIMS, how-to guide, tutorial videos, and more
Send Feedback - Click here whenever you have a feature request or would like to submit feedback on how we can improve the platform.
On the top of the page, there are more useful functions such as:
“+” - click the icon to add a new column without having to leave the page
More Drop-Down Menu - quick access links for the following:
Columns, tables, help and send feedback
