Labii Documentation
HomeFree SignupFree DemoContact Us
  • Getting Started
    • Introduction
    • Quick Start
  • User Guide
    • Interface
      • Side Menu
      • Views
    • Add Record
      • Add a project
      • Add a blank record
      • Add records in bulk
      • Add a record from a template
      • Add record(s) from file(s)
      • Add a template
    • Record List View
      • Table List View
      • Project List View
      • Row List View
      • ❗Import Records
      • Export Records
      • Bulk Operations
        • Bulk Edit Columns
        • Bulk Edit Sections
        • Bulk Print Detail
        • Bulk Print Labels
        • Bulk Print Barcodes
        • Bulk Print QR Codes
        • Bulk Download
        • Use Selected to Add Blank Record
        • Use Selected to Bulk Add Records
    • Record Detail View
      • Columns
      • Sections
      • Notes
      • Signers
      • Versions
      • Activities
      • Visitors
      • Permissions
      • Section
      • Actions
        • Sign
        • Print
        • Share
    • Navbar
      • Search
        • Global search
        • Search at list view
        • Search query
      • Scan
    • Side Menu
      • Dashboard
      • Calendar
      • Notifications
      • Reload Organization
      • Switch Organization
      • Change Data Center
    • Accounts
      • Authentication
      • Setup an account
      • Create an account
      • My Profile
    • AI Integration
      • Prompt box
      • Prompt template
      • ProtocolGPT
      • AI in Widgets
      • Use cases
  • Admin Guide
    • Organization
    • Backups
    • Personnel
    • Certifications
    • Teams
    • Projects
      • Members
    • Applications
    • Tables
      • Columns
      • Sections
      • Filters
    • Workflows
    • Widgets
    • Subscriptions
    • Credits
    • Invoices
    • Single Sign On
      • Google G Suite
      • Okta
      • OneLogin
      • Microsoft Azure
    • API Keys
  • Widgets
    • Overview
    • Column Widgets
      • Form
        • Text inputs
          • Text
          • MultilineText
          • RichText
          • Number
          • RangeUnit
          • Email
          • Phone
          • Secret
          • Link
          • Address
        • Boolean
          • Checkbox
          • Switch
        • DateTime
          • Date
          • Time
          • DateTime
          • Appointment
          • TimeStamp
          • Timezone
        • Dropdown
          • Select
          • MultiSelect
          • ForeignKey
          • ForeignKeys
          • Member
          • Members
        • File
          • Files
          • Image
          • File Path
          • File Size
          • File Antivirus Status
      • Barcode
        • Barcode
        • QR Code
      • Calculation
        • Formula
        • Numbering
        • RowCount
        • Consumption
      • Integration
        • API
          • API
        • Dropdown
          • API ForeignKey
          • API ForeignKeys
      • Column
        • Record Citation
        • Column Citation
        • Column Data
        • Column Addition
      • Regulation
        • Signature
          • Signature
          • Open Signature
          • Signature Status
      • ❗Chemistry
      • ❗PubMed
      • ❗Device
      • ❗Integration
      • Advanced
        • Subtitle
        • Rating
        • Nested Fields
        • Storage
        • Storage Coordinates
    • Section Widgets
      • Office
        • Text
          • Plain Text
          • CKEditor Classic
          • CKEditor Balloon
          • CKEditor Document
          • CKEditor Restricted
          • CKEditor Classic Controlled
          • Code Editor
        • ❗Table
        • File
          • Files
          • File Preview
        • Google Drive
        • Drawing
        • G Suite
        • Microsoft Office
      • Data Display
        • Columns
          • Columns
          • Metadata
        • Sections
          • Section Display By Record
          • Section Display By ForeignKey
        • Record List
          • Record List
          • Record List by Column
          • Record List by ForeignKey
          • Record List by Query
      • ✅Regulation
        • Signers
        • ✅Audit Trail
          • ✅Activities
          • Versions
          • Visitors
      • Process Management
        • Flowchart
        • Steps
      • Diagram
        • Mermaid
        • Gantt Chart
        • Stage Flowchart
        • Relation Flowchart
      • Reference Manager
      • Biology
        • Molecular Biology Suite
          • Plasmid Editor
          • Open Vector Editor
        • Microplate
          • 6-Well Plate
          • 12-Well Plate
          • 24-Well Plate
          • 48-Well Plate
          • 96-Well Plate
          • 384-Well Plate
          • Flexible Well Plate
        • Sample Aliquoting
        • Assay
          • ELISA Standard Curve
          • ELISA Qualitative
          • Dose Response Curve
        • Protein
          • MolStar
          • RCSB Saguaro
        • Bioinformatics
          • QUiCKR Analysis
          • CRISPResso2
      • Chemistry
        • Chemical Formats
        • Chemical Drawing
        • Chemical Analysis
        • Chemical Reaction
      • Combination
        • Clinical Genomicist Workstation
      • Productivity
        • ✅Calendars
          • Calendar
          • Scheduling
        • Automation
          • Workflows
        • Ungrouped
          • Storage Map
        • Table of Contents
        • Communication
          • Email Template
          • Notifications
          • Comments
        • Barcode
        • ToDo
        • Timer
      • Report
        • Record Summary
          • Record Summary
        • Data Driven Charts
          • Chart By Category X
          • Chart By Numeric X
        • Custom Input Charts
          • Data Visualizer
    • Dashboard Widgets
      • Labii
      • Shortcut
        • Applications
        • Links
        • Filters
      • Productivity
        • Office
        • Flowchart
        • Section
        • Project Management
          • ✅Tasks
        • Summary
      • ✅Reports
        • Record Summary
          • Record Summary By Date
          • Record Summary By Tables
          • Record Summary By Projects
          • Record Summary By Users
        • Data Driven Charts
          • Chart By Category X
          • Chart By Numeric X
        • Matrix
          • Record Count By Filter
        • Audit
          • Storage Audit
      • Integration
        • Quickbooks
          • Quickbooks Customers
          • Quickbooks Accounts
          • Quickbooks Items
          • Quickbooks Invoices
  • API
    • Concepts
      • How to get token from Labii ELN & LIMS
      • How can I load Labii data from API into DataFrame
    • Methods
      • Authentication
      • Notification
      • Organization
      • Personnel
      • Team
      • Organization Widget
      • Statement
      • Backup
      • Project
      • Member
      • Table
      • Column
      • Filter
      • Row
      • Cell
      • Section
      • Activity
      • Version
      • Visitor
      • Workflow
      • Step
      • Widget
    • Variables
    • SDK
      • API Client (python)
      • API Client (javascript)
      • SDK (python)
      • SDK (javascript)
      • Examples
  • Applications
    • Electronic Lab Notebook
      • ELN for Research and Development
      • ELN for Production
      • ELN for ELISA Data Analysis
      • ELN for Dose Response Curve
    • Process Management
      • ❗Report creating process in diagnosis testing
      • ❗Email follow up process in CRM
      • ❗Management of the purchasing, approval, and ordering processes.
    • Sample Management
      • Sample Receiving
      • Track sample consumption
      • Aliquots Management
    • Equipment Management
      • ❗Equipment Scheduling
      • ❗Equipment Maintenance
    • Inventory Management
      • Barcode System
      • Stock Checkin and Checkout
      • Storage Management
      • ❗Purchase Management
    • Laboratory Information Management System
      • LIMS for Sample Testing
      • LIMS for NGS
    • Customer Relationship Management (CRM)
      • Quickbooks Integration
    • Document Management
    • Chemical Registration
    • Mouse Colony Management
    • Diagnostic Testing
    • Diabetes Tracker
    • Project Management
      • Task Management
      • How to manage research goals
    • Reference Management
    • Training Management
  • Support
    • Overview
    • Documentation
    • YouTube
    • Videos
    • Tickets
    • Chat with us
    • Schedule a meeting
    • Take a survey
    • Resources
    • Download
    • Blogs
    • FAQ
    • Other
      • Guidelines for Preparing Documents on Research Needs for Labii Configuration
Powered by GitBook
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
  1. Admin Guide

Tables

Change table settings to meet your requirement

PreviousApplicationsNextColumns

Last updated 4 months ago

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.

Table fields

Here is the list of fields for a particular table:

  • Overview

    • sid - The SID of the table. Automatically generated by Labii. This ID cannot be changed once it has been created.

    • updated_by

    • date_updated

    • date_created

  • Detail

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

    • icon (required) - Table table icon.

    • order - The order to display the table

  • Unique ID

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

    • UID_format - You have the option to personalize the UID by specifying your preferred UID format, which by default consists of '{Unique Code}{RID}'.

    • should_support_custom_uid - If true, users must supply their unique identifier (UID) for each record. This works well for reagents where you prefer to utilize the vendor's barcode as the UID. Notes: Users must guarantee the uniqueness of the provided UID, as failure to do so will result in the newly created record replacing the existing one.

  • Name and Description

    • name_display_name - The display name of the 'Name' field.

    • name_help_text - The description of the 'Name' field.

    • description_display_name - The display name of the 'Description' field.

    • description_help_text - The description of the 'Description' field.

  • List view

    • default_list_view - Default tab view when opening the list view.

    • fields_to_display - Select fields to display in the list view.

    • ordering - The ordering to display records in the list view.

    • default_filters - Select the default filters to be included in the list view.

  • Detail view

    • default_detail_view - Default tab view when opening a record.

    • fields_to_display_for_detail - Select fields to display in the detail view.

    • should_enable_section_complete_action - If enabled, each section of a record will include a 'Complete' button. Once a section is marked as complete, it will become read-only.

  • Form view

  • Permissions

    • teams_can_add - Choose one or more teams to have add permission to this table. If you don't choose any team, all teams will have add permission to this table.

    • should_limit_edit_to_owner - If true, only the owner can edit their records, regardless of the permission settings at the project level.

    • required_certifications - Please indicate the necessary certifications needed to add or modify entries in this table. If multiple certifications are required, please list them separated by commas.

  • Settings

    • minimum_number_of_signers - Number of signatories required. This number is set so that the document can only be signed when a minimum number of signers has been added. It defaults to 0.

  • 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 methods:

  • Add a new table at the table list view:

    1. Settings -> Tables

    2. Click "Add Table" and select "Add blank table"

    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.

  • Settings -> Tables

  • Click "Add Table" and select "Add table from template"

  • Choose a template

  • Fill in the required fields and click "Submit"

  • The newly created table will also 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. Prepare a sheet with the following fields.

  2. Download/Save it as *.tsv

  3. Settings -> Tables

  4. Click the "...Actions"

  5. In the dropdown, select "Import"

  6. Select the file you just prepared, click Submit

  7. Match each field based on your document header

  8. Click Submit button to import

  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. Settings -> Tables

  2. Click the "...Actions"

  3. In the dropdown, select "Export current page". Only the tables visible on the current page will be exported.

  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.

Columns - the columns of the table. Learn more .

Sections - the sections of the table. Learn more .

Filters - the filters of the table. Learn more .

name_display_format - The format of the 'Name' field for the name serializer. This field support variables. Discover additional information about the array of supportive variables on . Note: Providing a value for this field will override the default name. Use {{NAME}} to include the original name.

default_add_query - The query meant for adding to the form. Use this function to restrict changes to the append query in the add form. This field support variables. Discover additional information about the array of supportive variables on

printer_header - Customize the header of the print page for the table. Use HTML code for formatting. If provided, the header from organization setting will be replaced. This field support variables. Discover additional information about the array of supportive variables on

here
here
here
https://docs.labii.com/api/variables
https://docs.labii.com/api/variables
https://docs.labii.com/api/variables