Tables
Change table settings to meet your requirement

Overview

Tables serve as individual modules to manage the research data for a particular category. Labii uses a table to keep track of one particular type of data. For instance, an experiment table can be used to keep track of all experimental notes. Depending on your research needs, you can add an unlimited number of tables to manage any type of data you require.
These changes can only be made by Administrators.

List of tables

You can manage a list of tables by clicking Settings at the side menu and then select Tables.

Search tables

You can search tables by typing a keyword into the search bar in the table list view, and then clicking Search. The search results can always be cleared by clicking the Clear button.

Filter tables

With the Filter function, you can limit the number of teams displayed. You can do that by clicking Active tables and then selecting a filter from the dropdown. Here are a list of filters:
  • All tables. Filter to display all tables.
  • Active tables. Filter to display the active tables.
  • Archived tables. Filter to display the archived tables.

Table detail

Click a table name to view the detail of the table.
The detailed view of a table comes with 5 tabs:
  • Detail - the detail fields of the table.
  • Columns - the columns of the table. Learn more here.
  • Sections - the sections of the table. Learn more here.
  • Filters - the filters of the table. Learn more here.
  • Workflows - the workflows of the table. Learn more here.

Table fields

Here is the list of fields for a particular table:
  • sid - The SID of the table. Automatically generated by Labii. This ID cannot be changed once it has been created.
  • icon (required) - Table table icon.
  • name_singular (required) - Table name, in a singular format. Letters and Numbers only, no blanks.
  • name_plural (required) - Table name, in plural format. Letters and Numbers only, no blanks.
  • name_system - This name is used to identify system-specific tables and is automatically generated by Labii.
  • description (optional) - Description of the table. Provide enough information for other users in your organization to understand. This information will appear in the table selection list, the add-a-table description, and in the list when there is no available data.
  • unique_code (Required) - The abbreviation term of a table name. The code must be at least 2 characters long and contain only uppercase letters. The unique_code is used to generate the unique identifications (UID) of records.
  • should_add_form_form (default to true) - If true, a form will be displayed for filling out, otherwise a new record will be created directly.
  • default_tabs - Tabs to be opened by default. You can include one or more tabs that are displayed when a record is opened. By opening these tabs, end users will have the ability to view data directly by switching tabs. It can still be accessed from the overview tab if not specified.
  • default_view - Default tab view when opening a record.
  • order - The order to display the table
  • metadata - the list of metadata with labels and values
  • is_archived - Checking this box will archive the table. Archived tables are not available for use. Make sure no other column/section uses the table, it might break your system if one is archived. The Files table is always required and should not be archived.

Add table

A new table can be added with the following 3 methods:
  • Add a new table at the table list view:
    1. 1.
      Settings -> Tables
    2. 2.
      Click "+ Table"
    3. 3.
      Fill in the required fields and click "Submit"
  • Add a new table at the table detail view:
    1. 1.
      In the detailed view of a table. (Settings -> Tables -> Click a Table)
    2. 2.
      Click "+ Table"
    3. 3.
      Fill in the required fields and click "Submit"

Add table from a template

Labii ELN & LIMS is a complicated system and requires specific training to get everything right. We are simplifying the configuration progress with table templates.
If a template is selected, the system will
  1. 1.
    Autofill all table fields
  2. 2.
    Create the corresponding columns, sections, filters, workflows at the same time
Please always use a table template when creating a new table.

Duplicate table

To create a table similar to the table already created:
  • Settings -> Tables
  • Click a table name
  • Click "...Actions"
  • Select "Duplicate" from the dropdown menu.
  • Change the following fields and click submit:
    • Table Name Singular
    • Table Name Plural
    • Unique code

Import tables

If you already have a list of tables and you would like to create in batch, use the "Import tables" function. To do that:
  1. 1.
    Prepare a sheet with the following fields.
  2. 2.
    Download/Save it as *.tsv
  3. 3.
    Settings -> Tables
  4. 4.
    Click the "...Actions"
  5. 5.
    In the dropdown, select "Import"
  6. 6.
    Select the file you just prepared, click Submit
  7. 7.
    Match each field based on your document header
  8. 8.
    Click Submit button to import
  9. 9.
    Verify the final results
icon
name_singular
name_plural
description
unique_code
should_add_from_form
default_view
order
cloud
test
tests
This is a test
TT
overview
1

Export tables

You can also export a list of tables for later use. To do that:
  1. 1.
    Settings -> Tables
  2. 2.
    Click the "...Actions"
  3. 3.
    In the dropdown, select "Export current page". Only the tables visible on the current page will be exported.
  4. 4.
    Select "Export all pages". This will download all tables and all fields.

System tables

The system tables are the tables with name_system setup and reserved with one particular function. Here is a list of system tables:
  • file - The files table to store the uploaded files
  • workflow - The workflow table to store the workflow details
  • step - The workflow steps
The fields of the system tables can not be changed.

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.
Last modified 3mo ago
Copy link
On this page
Overview
List of tables
Search tables
Filter tables
Table detail
Table fields
Add table
Add table from a template
Duplicate table
Import tables
Export tables
System tables
Change name of field