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
  • Use cases
  • Settings
  • Interface
  • Add records
  • Update field value
  • Show gantt chart
  • Open list view
  • Reload
  • Execute workflows
  1. Widgets
  2. Section Widgets
  3. Data Display
  4. Record List

Record List by ForeignKey

Exhibit a list of records linked to the current record through a ForeignKey or ForeignKeys column

PreviousRecord List by ColumnNextRecord List by Query

Last updated 4 months ago

Overview

The "Record List by ForeignKey" widget is designed to exhibit a list of records linked to the current record through a ForeignKey or ForeignKeys column. Users have the flexibility to customize the displayed fields, enabling a personalized view of relevant information. Not only does this widget allow users to update the values of existing records seamlessly, but it also empowers them to create new records that reference the current record via the ForeignKey or ForeignKeys column.

Use cases

  • Display list of contacts associated to an account.

Explore to find comparisons between this widget and other similar widgets.

Settings

For the widget to operate, users must configure both the table and the column that references the current record. Once this configuration is set up, the widget will automatically display a list of records. Additionally, users have the flexibility to customize which fields are shown and specify the fields used for scanning, providing a tailored and user-controlled display of information.

  • Table - Select a table that has columns referred to this record as the value of ForeignKey or ForeignKeys.

  • Column Referenced - the ForeignKey or ForeignKeys column referenced to this record. When the table changes, the column options changes automatically.

  • Query - Further refine the displayed records by adding supplementary query criteria.

  • Fields to display - other fields to display. On default, the name of the record will be displayed.

  • Fields to copy - Select the fields that you want to copy from the current record. Default to projects.

    • Copy from

    • Copy to

  • Workflows - Choose one or more workflows for execution.

  • Scan - Set up scan configurations so that you can add records by scanning barcodes or QR codes.

    • Columns scannable - Please provide a list of ForeignKey columns that can be included through barcode/QR code scanning. The scannable fields can not be the ForeignKey that referenced to this record.

    • Column (Quantity) - Choose the quantity field requiring a numerical value. Once selected, conducting multiple scans will increment the item quantity.

  • Gantt Chart

    • Column (Appointment) - Choose the Appointment column for the Gantt chart.

    • Should Show Gantt Chart - If checked, the Gantt chart will be displayed.

Interface

The widget interface displays a list of records from a specific table and column that refer to the current record.

Add records

Add blank record

Add records in bulk

Add from template

Import records

To import lists of records in bulk, click "Import records". Imported records will be assigned directly to the current record.

Add records via scan

Labii has introduced a new feature to streamline the process of adding records. Users can now add records by simply scanning barcodes or QR codes, which proves especially useful during experiments where samples need to be documented for consumption or usage purposes. Instead of manually adding each sample, users can easily scan the barcode or QR code associated with the samples.

To enable this feature, you must first set up the scannable fields in the settings. Please note that only ForeignKey columns are scannable, and you can define these fields under the scannable fields settings.

When you are ready to scan, click on the Scan dropdown and choose the specific field you want to scan. The widget will then be activated and ready to receive signals from the barcode or QR code scanner. It's important to mention that the feature supports scanners and does not support camera.

Once you scan a code, the results will be displayed in a list format. In case of any errors or mistakes, you have the option to remove the scanned results individually by clicking on the Remove button.

Once all the relevant results have been scanned, click on the Submit button to initiate the record creation process.

After completing the initial record creation, you may find it necessary to update other values. This can be achieved by clicking on the edit icon or by using the bulk edit option available under the list view. This ensures that all necessary information is accurately recorded and documented.

In summary, Labii now supports effortless record addition via barcode or QR code scanning, simplifying the data entry process, especially in experiments involving sample tracking and documentation.

Update field value

With Edit permissions, you have the ability to update one or multiple fields of the displayed records by clicking the edit icon next to the respective field.

Show gantt chart

When you select a column of appointments, you can easily view a Gantt chart to see the scheduling and timeline of your records. Simply click the "Gantt Chart" button to display the chart, and when you're done, click "Hide Gantt Chart" to close it. This feature helps you manage your appointments more effectively and gain better insights into your schedule!

Open list view

Utilize the "Open List View" button to present the records in a list view, where you can access various functions such as export, bulk edit, bulk print, and more.

Reload

Occasionally, the list may be refreshed in alternative locations, and you can select the Reload button to update the record list.

Execute workflows

If one or more workflows are chosen in the settings, a list of workflows will appear, and you can initiate each workflow by clicking the "Execute Workflow" button.

You can add a new record directly linked to the current record by clicking "Add [Table Name]". This form is identical to the one for .

You can add multiple records simultaneously using the "Add records in bulk". .

Use the "" function to add records from predefined templates.

this resource
adding a record
Learn more
Add from template