> For the complete documentation index, see [llms.txt](https://docs.informationhub.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.informationhub.io/project/tables/view-edit-data.md).
# 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.
{% hint style="info" %}
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.
{% endhint %}
## 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.
{% hint style="warning" %}
Deleting rows is permanent and cannot be undone. Consider exporting your data before deleting rows.
{% endhint %}
## 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.
{% hint style="info" %}
The audit log is a useful tool for tracking data quality, resolving disputes, and recovering from accidental changes.
{% endhint %}
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.informationhub.io/project/tables/view-edit-data.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.