View and Edit Data

Once a table has columns and rows, you can browse, search, filter, add, edit, and delete data directly in the table view.

Open a table

Click on a table name in the Tables list to open it. The data is displayed in a spreadsheet-like grid showing all rows and columns.

A table with data

Toolbar overview

The toolbar above the table provides quick access to all table actions:

Button	What it does
Search	Opens a search box to filter rows by keyword
Filter	Opens the filter panel to apply column-level rules
ADD	Dropdown with three options: Add Column, Add Row, Import Data
Export	Opens the share and export options
Analyse	Opens the analysis script generator
Refresh	Reloads the latest data from the server
Settings	Opens the table settings page

Search

1. Click the Search button in the toolbar.

2. Type your search term in the box that appears.

3. The table updates to show only rows that match.

4. Click the X to clear the search, or Close to dismiss the search box.

Filter

1. Click the Filter button in the toolbar.

2. The filter panel opens. Click Add filter rule.

3. For each rule, choose a column, an operator (such as equals, contains, or starts with), and a value.

4. Add more rules if needed - multiple rules are combined to narrow the results further.

5. Click Apply to filter the table.

6. To remove a rule, click the trash icon next to it.

7. To clear all filters, open the filter panel and remove all rules, then apply again.

Add a row

1. Click the ADD button in the toolbar.

2. Select Add Row from the dropdown menu.

3. A form appears with a field for each column (the primary key is filled in automatically).

4. Fill in the values.

5. Click Save to add the row.

The ADD dropdown with Add Row selected

The add row form

Edit a row

1. Click the pencil icon at the left side of the row you want to edit.

2. The row edit form opens with the current values pre-filled.

3. Make your changes.

4. Click Save.

You can also delete the row permanently from this form using the Delete Row button.

Lock a row

Locking prevents a row from being edited further. To lock or unlock a row:

• Click the lock icon on the row in the grid, or

• Open the row edit form and use the Lock row toggle.

Locking a row is useful when a record has been verified and should not change. Only users with the appropriate permission can lock or unlock rows.

Select rows

• Use the checkbox at the start of each row to select individual rows.

• Use the checkbox in the column header to select or deselect all visible rows at once.

Selected rows can then be deleted in bulk.

Delete rows

Select one or more rows using the checkboxes, then use the delete option to remove them.

Deleting rows is permanent and cannot be undone. Consider exporting your data before deleting rows.

Sort data

Click on a column header to sort the table by that column. Click again to toggle between ascending and descending order.

Special cell types

JSON cells

If a column stores JSON data, clicking the cell opens a JSON preview popup showing the formatted JSON content. This is read-only.

Image cells

If a column stores images, clicking the cell opens an image gallery showing all images attached to that row. Click any image to open it in a new browser tab.

Pagination

Use the Previous and Next arrows at the bottom of the table to move between pages. Use the rows per page dropdown to control how many rows are shown at once (for example, 10, 25, 50, or 100 rows per page).

Refresh

Click the Refresh button in the toolbar to reload the latest data from the server. This is useful if other team members are adding data at the same time.

Audit log

The audit log shows the full change history for your table's rows.

1. Click the Settings button in the toolbar.

2. Navigate to the Audit Log section.

3. Each entry shows what was changed and when.

4. Expand an entry to see the individual field changes.

Administrators can roll back a row to a previous state by clicking Rollback next to any history entry.

The audit log is a useful tool for tracking data quality, resolving disputes, and recovering from accidental changes.