The most basic concept in Datablist is the item. Each item is represented with a row in the data table. An item can represent anything: a contact, a lead, an employee, a website, etc.

Items are either created manually, by API, or by importing an external file.

Create items manually

Create a new item with the New button in the collection header.

Warning: Your collection must have properties before adding items manually.

New item
New item

It opens the drawer on the right. Save your item quickly by pressing the Enter key or cancel and close the drawer with the Esc key.

New item drawer
New item drawer

Keyboard Shortcut
The fastest way to create an item is with the keyboard shortcut C which will open up the new item drawer in your current collection.

Data validation

Before creating an item, Datablist ensures the item's data validates all its property data types and data constraints.

Property Validation
Property Validation

Edit an item

To edit an item, you can open the detail view in the drawer or edit it directly in the table view with our spreadsheet-like interface.

Edit directly

On a cell, press Enter to edit an item and Enter or Tab to submit the changes. Press Esc to cancel them.

Edit by pressing Enter

Edit item in drawer

Sometimes, having a form view to edit your items is more convenient. For example, if some of your collection properties have been hidden from the data table. In the drawer, all item properties are shown.

Open Drawer
Open Drawer

Select items and top bar

On the left of the items, you can find a checkbox to select items. When at least one item is selected, buttons appear in a top bar.

Available buttons:

  • Delete items - Will permanently delete selected items
  • Export items to CSV - Generate a CSV file with the selected items
  • Merge items - Open Datablist Merging Assistant
  • Unselect - Cancel selection
Top bar buttons
Top bar buttons

Quick select

To quickly select items, you can use your mouse by clicking and holding it while moving over other checkboxes. Another solution is to check one checkbox and click on another one while pressing the Shift key. All items in between will be selected.

Quick select items

Tip: Use the keyboard shortcut Ctrl + a to select all items

Items count on search term or filtered listing

Datablist doesn't calculate the data table count when you use a search term or filtered conditions by default (for performance reasons).

But you can ask Datablist to run a count operation by clicking the "Select all" checkbox and then on the "All items selected" label.

Count all items
Count all items

Search and sort items

Searching through your items is simple. Datablist performs a full-text search on all of your item property values in seconds.

The search input is located in the collection header. A fast way to start a search is using the keyboard shortcut Ctrl + f.

Full text search
Full text search

Items can be sorted on any visible property by clicking on the property column. Property values can be sorted in ascending or descending order.

Sort items by property
Sort items by property

Filter items

Full-text search looks for a term in all available properties. To filter your data on specific properties, use Filter Conditions.

Filtering is useful to:

Filtering works by creating filter conditions on one or several properties.

Add a filter condition

Add a filter condition by clicking the "Change filters" button in the collection header.

Open Filters modal
Open Filters modal

A filter condition is made of 3 elements:

  • A Property - Any property in your collection.
  • An Operator - The filter operator specifies how to compare the data with your filter value. Depending on the property data type, operators can be: contains, is, is empty, is not empty, numerical operators, date comparators, etc.
  • A Value - The value to compare your item's property' data against.

Note
Operators "is empty" and "is not empty" do not require a value.

Click the "Apply" button to run your filter condition against your collection items.

Filters modal
Filters modal

Combining several filter conditions

Filter conditions work in AND mode. Only items matching all filter conditions are displayed in your data table.

Use the "Add another filter" to add another filter condition.

Combine several filter conditions
Combine several filter conditions

Feedback Wanted!
Do you need more complex filtering? Please share your use case with us.

Remove filter conditions

The filtering button is renamed "Filtered" and the icon is full when the collection is filtered.

DataTable with filters conditions
DataTable with filters conditions

To remove a filter condition, open the filter modal, click the "trash can" button and submit with the Apply button.

Remove a filter condition
Remove a filter condition

Filtering on built-in properties

Datablist comes with built-in properties (createdAt, updatedAt) which can be filtered as any other property. To be able to create filter conditions on your built-in properties, you must add them to your collection properties. See our documentation on built-in properties.

Filtering and data export

The export button in the collection header exports the full collection items. To export only your filtered items, use the Select all checkbox and click the "Export items to CSV/Excel" button.

Export filtered items
Export filtered items

Delete items

To delete one or several items, select them with the left checkbox and use the Delete items top bar button.

Warning: While it's possible to undo delete item operations while on the page, deleted items are not moved to trash but are permanently deleted. Please export your data before clearing a large amount of data.