Data table

The data table is a panel at the bottom of the 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 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, 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 — for example, a date picker for Datetime properties, and a dropdown listing object IDs for reference properties.

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 configured on reference properties, the same way as deletes from an app, service, or flow.

Generating records with Appfarm AI

When Appfarm AI 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.

Good to know

Generating records uses AI credits.

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 and file object classes.

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 in an app or a service.

Time series object classes are not shown in the data table.