# Edit Data Tables

Data Tables are the primary interface for editing data.

![A data table.](/files/w3PA6oMVqwsgaanU3ZfF)

## Presentation

Data Tables are organised as follows based on the [Data Model](/editing-data/data-model.md):

* Table are Entity Types
* Rows are Entities
* Columns are Properties
* Data are Cells.
* A Relationship is a Cell under a Relationship Type Column.

## General Usage

Use [Quick Search](/navigation/universal-search.md) to navigate to different Tables and create new ones.

**LeftClick** a Column Heading to sort the Rows based on that Column.

**RightClick** a Column Heading to configure the property, such as:

* Rename column
* Edit description
* View column identifier
* Sort by this column
* Hide the column values from the sidebar
* Change the order of relationships
* Delete column

**RightClick** a Row to configure the entity, such as:

* Delete row
* Move row (currently not supported)

**LeftClick** any Cell, then **CTRL + E** to create a new Row.

## Mark Multiple Rows

You can mark multiple Rows to perform bulk operations such as removing and filling.

**Hold LeftClick + Drag** to mark multiple Rows.

**LeftClick** a Cell, then **SHIFT + LeftClick** another Cell to mark a range of Rows.

**LeftClick** a Cell, then **CTRL + SHIFT + LeftClick** another Cell to unmark a range of Rows.

**LeftClick** the Row Number Cell to mark/unmark a single Row.

## Fill Multiple Cells

To speed up data entry, you can:

1. Mark multiple Rows (see above)
2. Select an unmarked Cell
3. Click "Fill" in the toolbar to update the marked Rows with the value of the selected Cell.
4. Unmark the Rows if you want to.

Note: The selected Cell cannot be among your marked Rows.

For Relationships, filling will add all of the Relationships from the selected Cell to the marked Rows. It won't remove any Relationships.

If a Relationship already exists, Fill will fail to avoid inconsistent updates. This will result in a partial fill as the Rows before the failure will be updated. Use [Changes](/editing-data/making-changes.md#rewind-changes) to unfill those Rows if you want to.

## Drag and Drop Files

Some cells, such as Attachments (Images, Files), support drag-and-drop from your File Manager so you do not need to hunt down files you already have open.

![Adding a Preview Image using Drag and Drop.](/files/-MMM6hupo8LaxkQYKWYB)

## Drag and Drop Files to Multiple Cells

If you want to drag and drop multiple files across multiple rows on the same column to save time, you can. First [#mark-multiple-rows](#mark-multiple-rows "mention") then select your files in the same order and drag and drop to the first cell. The order you marked rows and selected files must match.

When dealing with lots of files select the first item, hold shift, then select the last time. This will select all items in the order they appear between the two items. This is known as Shift-Click. So you can do the following:

1. Sort your table in the same order as the files.
2. Use Shift-Click on the table to select multiple rows.
3. Use Shift-Click on your files to select multiple files.
4. Drag and drop your selected files onto your selected rows.


---

# Agent Instructions: 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.frontiernav.net/editing-data/data-tables.md?ask=<question>
```

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.