> For the complete documentation index, see [llms.txt](https://docs.ninox.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.ninox.com/user-hub/common-tasks/work-with-data.md).
# Work with data
## Search records in a table view
Use **Search in records** when you want to find records that contain specific values in the current table view.
1. Click **Search in records**.
2. Type a part of the value you are looking for.
3. Ninox shows matching records in the grid.
This is useful for quick lookups without setting up a full filter.
## Bundle results of multiple searches
You can collect results across multiple search runs in one view. This is useful when you want to, for example, bookmark or delete several selected records at once.
{% hint style="info" %}
Only users whose role allows deleting records in this table can see the checkbox column in table view.
{% endhint %}
1. Start your first search.
2. In the first column of the table, select the checkbox for each record you want to keep selected.
3. Clear the current search by clicking the :circle-x: in the search field and start your next search.\
This keeps the selected records highlighted.
{% embed url="" %}
To select or deselect all records, use the checkbox in the column header or use :xmark: **Clear selection** in the top bar.\
Selecting all visible records with the checkbox in the column header ends the current search cycle. If you start a new search afterwards, Ninox clears the current selection.
## Bulk delete records
Use bulk deletion to delete a group of records or a selected set at once.
{% hint style="info" %}
This function is only available to users whose role allows deleting records in this table. Admins can manage this permission in the table settings.
{% endhint %}
{% stepper %}
{% step %}
### Open the table
Choose the table that contains the records you want to delete and open a table view.
{% endstep %}
{% step %}
### Find and select the records to be deleted
Use filters and **Search in records** to find the records you want to delete.
Then select them with the checkbox in the first column.
{% endstep %}
{% step %}
### Execute the bulk deletion
Click the red trash bin in the top bar above the table.
Ninox shows the number of selected records. Click the red **Delete** button to delete them permanently.
{% endstep %}
{% endstepper %}
## Bulk edit records
Use bulk edit to save time when you need to update the same fields across many records at once.\
You can apply a fixed value, clear existing values, or generate new values with logic.
{% stepper %}
{% step %}
#### Open the table and limit the records
Open the table you want to update.
Optionally use :bars-filter: **Filter** to show only the records you want to update.
{% hint style="info" %}
Bulk edit only changes records that are currently visible in your table.
{% endhint %}
{% endstep %}
{% step %}
#### Open the bulk edit dialog
In the table toolbar, click **Import/export**. Then select **Bulk edit**.
{% endstep %}
{% step %}
#### Create rules
Click **+ Add rule**.
Select the **Field** you want to update.
You can only update fields in the current table that store data. You can't bulk edit logic fields, control elements, or layout elements.
Under **Update with** choose the type of change:
* **Constant value** enters the same value for all displayed records
* **Clear** removes the current value from the field
* **Calculated value** uses logic to generate the new field value
Enter the **Value** you want to apply.
For **Calculated value**, enter the logic that should generate the new value.
Add more rules if you want to update more fields in the same table.
{% endstep %}
{% step %}
#### Review the result
Click **Preview changes** to check the result.
{% endstep %}
{% step %}
#### Apply or discard the changes
Then choose one of these actions:
* **Apply changes** confirms the update
* **Back** returns to the rules so you can adjust them
* **Cancel** closes the process and lets you start over
{% endstep %}
{% endstepper %}
---
# 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, and the optional `goal` query parameter:
```
GET https://docs.ninox.com/user-hub/common-tasks/work-with-data.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
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.