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.
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.
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.
Before creating an item, Datablist ensures the item's data validates all its property data types and data constraints.
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.
On a cell, press Enter to edit an item and Enter or Tab to submit the changes. Press Esc to cancel them.
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.
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.
- 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
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.
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.
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.
Items can be sorted on any visible property by clicking on the property column. Property values can be sorted in ascending or descending order.
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:
- Find items that meet certain conditions
- Have a clean listing by excluding items
- Filter a CSV file to extract specific rows
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.
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.
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.
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.
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.
To remove a filter condition, open the filter modal, click the "trash can" button and submit with the Apply button.
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.
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.