> 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](/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](/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 persisted per user and is preserved when you switch between solutions. The records shown in the panel reflect the currently selected object class. 

## 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](/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](/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](/reference/data-model/object-class-properties.md).

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 record** 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. A **Delete** button appears while one or more rows are selected. Click **Delete** to remove the selected records from the database.

Deletes respect the [Delete Rule](/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](/reference/appfarm-ai.md) is enabled in your solution, and the **AI-generated development data** setting is on, a **Generate records** button is shown alongside **+ Add record**. 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](/reference/appfarm-ai/ai-credits.md).
{% endhint %}

To turn on **AI-generated development data**:

* In the top-left menu, click **Settings**.
* Open the **Appfarm AI** section.
* Toggle **Enable** **AI-generated development data**.

This setting grants Appfarm AI permission to read and create data in the Development environment using the logged-in developer's data permissions. Appfarm AI only has access to read object IDs.

## Supported object classes

The data table supports [object classes](/reference/data-model/object-classes.md) and [file object classes](/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](/library/action-nodes/create-file-object.md) in an app or a service.

[Time series object classes](/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 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.appfarm.io/reference/data-model/data-table.md?ask=<question>&goal=<endgoal>
```

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