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.
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.
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.
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.
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.
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.