Columns

Manage and create columns

Summary

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:

  1. Record list view from sidebar:

    1. Click table from navbar, select a table from the dropdown list

    2. Select Columns from the sidebar

  2. Table detail page from sidebar:

    1. Click the menu icon located on the top right of the page

    2. Select settings

    3. Select Tables and choose a table from the list

    4. Click Columns from sidebar

  3. From Column list view:

    1. Click the menu icon located on the top right of the page

    2. Select settings

    3. Select Columns

    4. Choose a table from the dropdown list

    5. Click the "+" icon on the top of the navbar.

      1. Example, select experiment table to view/customize columns

Add a column

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

  1. Navigate to the columns list view (see above)

  2. Click the "+" icon on the top of the navbar or click the "add column" from the sidebar

Form to Add a Column

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

  • 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 example use “EP” to only matches to 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

Manage/Edit Columns

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

Column List View for Experiment Table

Detail of a Column

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

Overview for "date_start" Column

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

Sidebar and Navbar within Column "date_start" View