# Table List View

## Table list view

### Overview

The Table List view of Labii [electronic lab notebook (ELN)](https://www.labii.com/electronic-lab-notebook-eln) and [laboratory information management system (LIMS)](https://www.labii.com/laboratory-information-management-system-lims) displays a list of records for a table.

You might not be able to see all records depending on your permission settings. All records are visible to administrators regardless of the permission settings at the project level.

The list view is independent for each table and has the following tabs:

* **Dashboard** - Display dashboard data. Only available when `common_check_count=true`.
* **\[Table] records -** Display a list of records for the table.
* [**Properties**](/admin-guide/tables.md) **-** Table settings. Changes can only be made by administrators. Available to Administrator only.
* [**Filters**](/admin-guide/tables/filters.md) **-** Display a list of filters for the table. Available to Administrator only.
* [**Columns**](/admin-guide/tables/columns.md) **-** Display a list of columns for the table. Available to Administrator only.
* [**Default sections**](/admin-guide/tables/sections.md) **-** Display a list of default sections for the table. Available to Administrator only.

## Side Menu

The side menu of the Table List View provides a well-structured interface for streamlined navigation and enhanced functionality. It is divided into four distinct panels:

1. **Navigation Panel** - This panel is designed for quick navigation and table-specific actions. It includes:
   * **Breadcrumbs**: Allow users to easily track and navigate the hierarchical structure.
   * **Table Name and Description**: Clearly displayed to provide context for the current table.
   * **Add Dropdown**: A dynamic menu offering multiple methods to add records, such as manual entry, bulk import, or integration-based input.
   * **Action Buttons**: Enable additional table-specific actions, such as exporting data or managing table settings.
2. **Filters and Dashboard Panel** - This panel focuses on customizing the view and managing filters. It includes:
   * **Default and Custom Filters**: Predefined filters and user-created filters for narrowing down the displayed records.
   * **Dashboard**: Offers an overview of table-related metrics or visualizations for quick insights.
   * **Save as Default View**: Allows users to save their current filter and layout configuration as the default view.
3. **Related Tables Panel** - This panel facilitates access to other tables within the same application. It includes:
   * **List of Related Tables**: A navigable list of tables within the same application, making it easy to switch between tables and access records seamlessly.
4. **Projects Panel** - This panel helps users manage and limit the scope of records by project. It includes:
   * **Project List**: A list of available projects for the application.

Together, these panels make the Table List View a powerful and efficient interface for managing and interacting with records across various contexts.

### Open table list view

Table list view can be opened by clicking the **Application** from the side menu and then click the table name. For example, to open a list of experiments, click the **ELN** from the side menu and then click the **experiments**.

![](/files/td89sWa2CxjBKkBxgpiF)

### [Add record](/user-guide/add-record.md)

Click **+ \[table name]** from nav bar to add a new record. Depending on your needs, you can:

* [Add a blank record.](https://docs.labii.com/eln-and-lims/add-record/add-a-blank-record)
* [Add a record from a template.](https://docs.labii.com/eln-and-lims/add-record/add-a-record-from-a-template) To reduce repetitive work, a template can be used to create a similar record. The created record will contain the same data (columns, sections, notes, signers) as the template.
* [Add a record template.](https://docs.labii.com/eln-and-lims/add-record/add-a-template) The template can be used to create records with similar content.

### Search records

Learn more about [Search at list view.](/user-guide/navbar/search/search-at-list-view.md)

### Filter records

Filters can be applied to the table list view to specify a subset of the results. When a filter is selected, the button name changes to the filter name and the text color changes to teal.

![](/files/fgtyAjhT5c66pgd4NPmr)

#### Predefined filters

6 predefined filters are provided for quick access:

1. All records.
2. Active records (default).
3. Archived records.
4. My records.
5. My unsigned records. All records requiring your signature, whether you are the author or witness.
6. Record templates. A list of records that have been set as templates.

#### Custom filters

In addition to the predefined filters, you can also create custom filters for later use.

* **Apply a custom filter.** To apply the filter, click the filter dropdown and select one of the custom filters.
* [**Create new filter**](/admin-guide/tables/filters.md#add-filters)**.** Create a new filter by selecting **Create new filter** from the filter dropdown. Learn more from Settings -> Table -> Filters.
* **Save current query as new filter.** Select **Save as new filter** from the filter dropdown to create a new filter with the current query. This function will not be available when all records are displayed.
* **Delete current filter.** To delete the current filter, select **Delete filter \[filter name]** from the filter dropdown. This option is only available when a custom filter is applied.
* **Manage filters.** Click **Manage filters** from filter dropdown to update the existing filters.

#### Default filter

If you want to save a query and have it open automatically when the list view loads, use **Save as my default filter** function. A default filter is specific to each table and each user, so each user can save their own filters without interrupting the view of others.

* **Save as my default filter** to save the current filter as your default filter.
* **Clear my default filter** to delete any saved default filter.

#### Filter by project

The records can be filtered by projects. Click **All my projects** and select a project from the dropdown. Depending on your permissions, only the projects you have at least **read** permission will be displayed.

![](/files/45f5Owd0elAD6o6RQA3D)

### Save as default

If you would like a different view to be loaded when clicking on the table, you can use the **Save as default** feature.

<figure><img src="/files/aLSIdGml8qt4C3hSfgxM" alt=""><figcaption></figcaption></figure>

* Save as my default
* Save as table default
* Save as organization default

In the event that multiple default data are saved for a person, the personnel default data will be used first. Click **Clear all default** to clear all defaults.

### Sort records

Click the title to sort the records.

### Edit mode

Labii allows you to edit records in bulk. In order to do that, click "Edit mode".

All fields are displayed once you are in edit mode. By clicking the edit icon, you can edit a field.

<figure><img src="/files/97g5eVlnNYn5Iuka9Dxg" alt=""><figcaption></figcaption></figure>

### [Batch operations](/user-guide/list-view/bulk-operations.md)

A batch operation is a function or a method that processes multiple experiments in a single operation. Labii supports the batch operations for Editing, Printing, and Downloading. Select one or more experiments to get started.

![](/files/eW7oZaDi5XaKEw14jDM7)

### Upload

You can use this method to upload files and create a record at the same time. The uploaded files will be inserted directly into the record's sections/notes.

### Import

Using the import function, you can create multiple experiments at once. The import function can also be used to update multiple existing records.

### [Export](/user-guide/list-view/export.md)

Labii allows exporting data in the list view to a \*.tsv file. Two exporting options are supported:

* **Export current page.** Export data that is same as the current list view.
* **Export with customization.** Customize the number of records, the columns to be exported

<img src="/files/5kHdK8YXbnFFpRzEakZg" alt="" data-size="original">


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.labii.com/user-guide/list-view/table-list-view.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
