> For the complete documentation index, see [llms.txt](https://docs.appfarm.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.appfarm.io/reference/data-model/data-table.md).

# Data table

The data table is a panel at the bottom of the [data model designer](https://docs.appfarm.io/reference/data-model.md#data-model-designer) that shows the records stored for an object class in the Development environment. You can read, add, edit, and delete records directly in the panel without leaving the data model. All operations follow the data [permissions](https://docs.appfarm.io/reference/security/permissions.md#object-classes) of the developer who is logged in.

## Usage

Click the data table icon in the toolbar of the data model designer to show or hide the panel. The panel state is stored per user in your browser and is preserved when you switch between solutions. The records shown in the panel reflect the currently selected object class. The panel header shows the object class name, the number of records, and a **Development data** badge.

## Reading records

Records are displayed 50 per page, with page navigation in the bottom-right corner of the panel. Each column corresponds to an [object class property](https://docs.appfarm.io/reference/data-model/object-class-properties.md), and the **ID** column shows the unique identifier of each record.

To sort by a column, click the column header. To find a specific record, use the **Search records** field in the top-right of the panel.

## Editing records

Click a cell to edit its value inline. The control shown depends on the property's [data type](https://docs.appfarm.io/reference/data-model/object-class-properties.md#data-types) — for example, a date picker for `Datetime` properties, and a dropdown listing object IDs for [reference properties](https://docs.appfarm.io/reference/data-model/object-class-properties.md).

Read only properties, and cells of type Rich Text, Resource File, Blob and Secret, can't be edited in the table.

Edits are persisted to the database when you confirm the change, and go through the same validation as updates from an app, service, or flow.

## Adding a record

Click **Add object** in the bottom-left of the panel to create a new record in the selected object class. You can then set the property values using inline cell editing.

## Deleting records

Select one or more rows using the checkboxes in the leftmost column. While rows are selected, a delete button with the number of selected rows appears in the panel header, for example **Delete 1 object**. Click it and confirm to permanently delete the selected records from the database. This cannot be undone.

Deletes respect the [Delete Rule](https://docs.appfarm.io/reference/data-model/object-class-properties.md#data-validation) configured on reference properties, the same way as deletes from an app, service, or flow.

## Generating records with Appfarm AI

When [Appfarm AI](https://docs.appfarm.io/reference/appfarm-ai.md) is enabled in your solution, a **Generate objects** button is shown alongside **Add object**. Click it to generate 10 records in the selected object class. The generated records include values for reference properties that point to existing objects in other object classes.

{% hint style="info" %}
**Good to know**

Generating records uses [AI credits](https://docs.appfarm.io/reference/appfarm-ai/ai-credits.md).
{% endhint %}

Appfarm AI creates the records and looks up the IDs of existing records in the Development environment using the logged-in developer's data permissions. If [**Development data access**](https://docs.appfarm.io/reference/appfarm-create/settings.md#appfarm-ai) is turned on, Appfarm AI also reads the values of existing records, so that the generated records match their style and formats. Without it, Appfarm AI only reads record IDs.

## Supported object classes

The data table supports [object classes](https://docs.appfarm.io/reference/data-model/object-classes.md) and [file object classes](https://docs.appfarm.io/reference/data-model/object-classes.md#file-object-class).

For file object classes, the panel shows the existing records but does not support adding new file records. To add a new file, use the [Create file object action node](https://docs.appfarm.io/library/action-nodes/create-file-object.md) in an app, a Flow, or a service.

[Time series object classes](https://docs.appfarm.io/reference/data-model/time-series-data.md) are not shown in the data table.


---

# 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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.appfarm.io/reference/data-model/data-table.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
