Data Viewer

While logged into a project's workspace, 8base provides an "Admin Panel" like interface for searching and managing table records. This Data Viewer is located within the management console's Data screen, tabbed alongside each table's Schema.

8Base Data Viewer

Adding Records

New table records can be added using the "+" button next to the table name. A form modal will appear which displays all table fields. All validations specified in the schema definition are enforced while using the data viewer.

Adding a new record in the Data Viewer

Filtering Records

When viewing a table's records, filters can be applied to narrow down the list of record desiplayed. Multiple filters can be added and used together. Please note, the Data Viewer's filtering UI does not support filtering based on related tables. Use API Explorer for advanced filtering.

Filtering records in the Data Viewer

Sorting Records

Data records can be sorted by using one or more sortable attributes. Sort attributes are ranked in the order in which they were created. Additionally, the filters can be applied to narrow down the list of records desiplayed. Multiple filters can be added and used together. Please note, the Data Viewer's sorting UI does not support sorting based on related table values. Use API Explorer for advanced sorting.

Sorting records in the Data Viewer

Selected Fields

By default, the id, createdAt, and updatedAt field columns are hidden in the Data Viewer. In order to customize which fields and columns display for a given table, simply click on the [Selected Fields] dropdown and toggle on/off desired fields.

Selecting fields in the Data Viewer

Importing Data

Importing data from CSV files is supported and can be opened by clicking the [Import CSV] option located in the top-right elipsis dropdown menu. The CSV importer supports column mapping and enforces all schema defined validations on create.

Importing records into the Data Viewer