Tables

Change table settings to meet your requirement

Summary

Tables are individual modules to manage research data in categories.

Admins within an organization can use the table settings to customize how they store their data. Please be very careful, every change that is made will affect the data dramatically. These changes can not be restored. Only Administrators have permission to make these changes.

To view the settings of tables within your organization, simply:

  1. Click menu icon top left

  2. Select settings

  3. Choose Tables (under table settings header)

Settings of Tables

Add a table

Add a new table and use it to store a new type of data.

A new table can be added with the following 3 methods:

  1. Add a new table by simply clicking the “Add” button on the top right of the homepage and select the “add table” from the dropdown list of tables.

  2. List view

    1. Click on menu icon top left and select settings

    2. Choose Tables

    3. Within the list view, click the “+” icon on the top of the navbar

      1. Or click add table from the sidebar to the left to add a new table

  3. Details view

    1. Click on menu icon top left and select settings

    2. Choose Tables

    3. Select any table name under “Name Singular” which will direct the user to the detail view page

    4. Click the “+” icon on the top of the nav bar to add a new table

Form to add a table

Here are the fields to fill out on the “Add Table” form:

  • Type (optional) - select from the dropdown list of the type of table you are going to create

  • Table Name Singular (required) - Table name, in a singular format. Letters and Numbers only, no blanks.

  • Table Name Plural (required) - Table name, in plural format. Letters and Numbers only, no blanks.

  • Description (optional) - Description of the table. Provide enough information for other users in your organization to understand.

  • Unique Code (Required) - The abbreviation term of a table name. The code must be at least 2 characters long and contain only uppercase letters.

  • Icon (optional) - Icon of the table. Choose one at https://material.io/icons/. Replace blanks with '_'. For example: 'account_circle'

  • Default View - Can choose between Overview or Detail:

    • The Default setting is set to overview which will give an overview when opening a record. Change it to 'Detail' to see the details of the record

Click Submit once finished with all required and optional fields

Only administrators within an organization can “add a new table.”

Manage Tables

All tables are customizable, attributes can be updated without leaving the table page because of Labii ELN & LIMS in-line editing function.

To view the list of tables within your organization, simply:

  1. Click menu icon top left

  2. Select settings

  3. Choose Tables (under table settings header)

Here are the following attributions:

  • Icon - The icon of the table. The icon will be used to display in the sidebar. Use a name from https://material.io/tools/icons/?style=baseline

  • Name Singular - The name of the table as singular, for example, sample

  • Name Plural - The name of the table as plural, for example, samples

  • Unique Code - Abbreviation term of a table name. Must be at least 2 characters long and use Uppercase letters only

  • Is Archived - If checked, the table is not available to use.

Simply hover the mouse to any attribution and a pencil icon will appear, click it to edit that particular attribution.

To the left on the table page has the following:

  • Add Table - Click here to add a new table (detailed information on adding a table is covered in the bottom section)

  • Active Tables - All the active tables within the organization

  • Archived Tables - Click here to see if there are any tables within the organization

  • Projects - View all projects within the organization

  • 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

And on the top there is the navbar:

  • “+” - Click to add a new table (same function as the “add table” on the sidebar)

  • Search - Click the “search” icon to quickly find a specific table

  • Menu Drop List - Click on the “Menu” icon:

    • Ability to import and export

    • Links to quickly see all, active, or archived tables, projects, and teams

    • 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

Detail of a table

To see an overview of a particular table:

  1. Click menu icon top left

  2. Select settings

  3. Choose Tables (under table settings header)

Select any table name under “Name Singular.”

For example, click the “experiment table name” and here are the overview fields for the experiment table:

  • Icon - The icon of the table. The icon will be used to display in the sidebar. Use a name from https://material.io/tools/icons/?style=baseline

  • Name Singular - The name of the table as singular, for example, “sample”

  • Name Plural - The name of the table as plural, for example, “samples”

  • Unique Code - Abbreviation term of a table name. Must be at least 2 characters long and use Uppercase letters only

  • Default View - Can choose between Overview or Detail

  • Add Metadata - Can add metadata by providing the label and value properties

  • Is Archived - Ability to archive this particular table and will not be available to use if the box is checked.

  • Updated By - The member within your organization who last updated any of the above fields

  • Date Updated/Date Created - Automatically captured in the background of Labii ELN & LIMS in real-time

You can edit the fields if it has a pencil icon to the right of a field. For example, you can edit the Name Singular field by clicking the pencil icon to the right, update the name and click submit.

Staying within the experiment table overview page, you have the sidebar to the left which contains the following:

  • Columns - 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.

  • 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.

  • Reports - Click here to run reports based on time, personnel, or projects. For example, run a report based on time to see how many new experiments were created within the last three weeks

  • 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 table without having to leave the page (Experiment table overview page)

  • More Drop-Down Menu - quick access links for the following::

    • columns, sections, filters, workflows, reports, experiment list, help, and send feedback

Customize the columns

In Labii, you can customize the columns of a table. Learn more about how to add/update columns here.

Customize default sections

Default section can be defined so that all new records created will have these default sections added. Learn more at here.

Change name of field

The field "Name" and "Description" can be changed to a different value with the following metadata at the table level or organization level.

  • FIELD_NAME_RENAME, use this metadata label to change the name of the "Name" field.

  • FIELD_NAME_HELPTEXT, use the metadata label to provide additional help text to the "Name" field.

  • FIELD_DESCRIPTION_RENAME, use this metadata label to change the name of the "Description" field.

  • FIELD_DESCRIPTION_HELPTEXT, use the metadata label to provide additional help text to the "Description" field.