> For the complete documentation index, see [llms.txt](https://docs.avonnicomponents.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.avonnicomponents.com/flow/tutorials/components/data-table/tips-and-tricks/data-table-editor.md).

# Data Table editor

Build and tune the columns of a screen flow Data Table right on the Component Builder preview: drag fields, rename, reorder and use each header menu.

An admin building a deal review screen spends most of her time on the columns: which fields, in which order, under which labels, drawn as what. The table preview in the Component Builder is where all of that happens. You drag fields onto it, drag headers to reorder them, and set each column from the menu on its header, without opening the **Data Mappings** list.

<figure><img src="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FSd8hgQQhw5mqSOwkWlML%2Fdata-table-tutorial-data-table-editor-canvas.png?alt=media" alt="The Component Builder with the Fields list on the left, the table preview in the middle and the Properties tab on the right"><figcaption><p>The preview is the editor: fields on the left, columns in the middle.</p></figcaption></figure>

## Before you start

* A Data Table on a screen, with its data source set to **Variable** (a Get Records collection) or **Query**. [Learn the Basics](https://docs.avonnicomponents.com/flow/tutorials/components/data-table/learn-the-basics.md) sets one up.
* Select the component on the screen, then click **Open Component Builder**. The preview shows the columns without your records ("Preview does not include data."): the rows arrive when the flow runs.

## Steps

{% stepper %}
{% step %}

### Drag fields to create columns

The left panel has two tabs. **Fields** lists the fields of the collection or the queried object, with a search box. **Templates** holds ready-made table layouts.

* Drag a field from **Fields** and drop it on the preview where the column should go. The column type follows the field type: a Currency field gives a **Currency** column, a Date field a **Date** column.
* Drag a header to move a column. Drag the edge of a header to resize it (unless **Resize Column Disabled** is on).
* Hover a header and click the pencil (**Edit Column Label**) to rename the column. Use the words your users say: Deal, Stage, Close date.
  {% endstep %}

{% step %}

### Open the column menu

Click the chevron on a column header. The menu only lists what applies to that column, and toggles show their current state: a column you made editable offers **Disallow Cell Edit**, one you have not offers **Allow Cell Edit**. A long menu scrolls: **Hide Default Actions** and **Remove Column** sit at the bottom.

| Option                                              | What it does                                                                                                                                                 | When it appears                                                                    |
| --------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------------------------------------------------------------------------------- |
| **Hide Label** / **Show Label**                     | Hides or shows the column's header text.                                                                                                                     | Query or Variable data source.                                                     |
| **Type Attributes**                                 | Sets the column type (Badge, Progress Bar, Currency...) and its options, such as **Linkify** on a text column.                                               | Always.                                                                            |
| **Select Icon**                                     | Adds an icon next to the header label.                                                                                                                       | Always.                                                                            |
| **Allow Cell Edit** / **Disallow Cell Edit**        | Lets users edit the cells. See [Making a field editable](https://docs.avonnicomponents.com/flow/tutorials/components/data-table/making-a-field-editable.md). | The field can be edited and **All Columns Editable** is off.                       |
| **Allow Sort** / **Disallow Sort**                  | Lets users sort by this column.                                                                                                                              | **All Columns Sortable** is off and, on a Query source, the field is sortable.     |
| **Allow Search** / **Disallow Search**              | Includes the column in the search box.                                                                                                                       | **All Columns Searchable** is off and, on a Query source, the field is filterable. |
| **Allow Filtering** / **Disallow Filtering**        | Adds a filter for this column. See [Adding filters](https://docs.avonnicomponents.com/flow/tutorials/components/data-table/adding-filters.md).               | **All Columns Filterable** is off and, on a Query source, the field is filterable. |
| **Wrap Text** / **Unwrap Text**                     | Wraps long values on several lines.                                                                                                                          | Column types that can wrap, and **All Columns Wrappable** is off.                  |
| **Hide Default Actions** / **Show Default Actions** | Hides or shows the header's built-in actions for this column at runtime.                                                                                     | **Hide Default Actions** is off for the whole table.                               |
| **Remove Column**                                   | Deletes the column.                                                                                                                                          | Always.                                                                            |

<figure><img src="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2F1mLTNBQgjzgUqESuA5cW%2Fdata-table-tutorial-data-table-editor-result.png?alt=media" alt="Column header menu of the Data Table in the Component Builder" width="320"><figcaption><p>Every column setting opens from the chevron on its header.</p></figcaption></figure>
{% endstep %}

{% step %}

### Change a column type

1. In the column menu, choose **Type Attributes**.
2. Pick a **Type**. The list only offers types that fit the field: a Text field can become **Badge**, **Rich Text**, **QRcode** or **Url**, a Number field **Progress Bar**, **Rating** or **Slider**.
3. Fill in the options of that type, then click **Save** in the popover.

The [Column Types Gallery](https://docs.avonnicomponents.com/flow/tutorials/components/data-table/column-types-gallery.md) shows what each type looks like.
{% endstep %}

{% step %}

### Add a column that is not a field

A button, a row menu or a file upload has no field behind it. In the **Properties** tab, under **Data Mappings** > **Columns**, add a column, choose **Custom** instead of **Object Field**, then set its **Type**.

With the **Manual** data source, the **+** that appears between two headers (**Insert New Column**) also adds a column. With **Variable** or **Query**, use **Data Mappings**.
{% endstep %}

{% step %}

### Set the default sort from the preview

With a **Variable** or **Manual** data source, click the sort arrow of a header in the preview. The table now opens sorted by that column, descending first; click again for ascending. This writes **Sort By** and **Default Sort Direction** for you. With a **Query**, the order comes from the query: set it there.
{% endstep %}

{% step %}

### Apply a setting to every column

The toolbar's **All Columns Settings** menu applies one setting to every column: **Display as Input**, **Editable**, **Searchable**, **Filterable**, **Sortable**, **Wrap Text** and **Hide Default Actions**. While one is ticked, the matching option leaves the column menus. With a Query or Variable source, **Editable** and **Display as Input** appear only when the object can be edited.

<figure><img src="https://27923732-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1FUd4apB9YHgCEMUFbVb%2Fuploads%2FLuAX5K4vS2r1xp55JCQm%2Fdata-table-tutorial-data-table-editor-all-columns.png?alt=media" alt="All Columns Settings menu in the Component Builder toolbar" width="480"><figcaption><p>All Columns Settings applies one setting to every column.</p></figcaption></figure>
{% endstep %}

{% step %}

### Save and test

Click **Done**, save the flow and run it with **Debug**. The columns appear in the order of the preview, with the labels, icons and types you set. Sorting, search and filters show only on the columns where you allowed them.
{% endstep %}
{% endstepper %}

## Troubleshooting

<details>

<summary>Allow Cell Edit is missing from the menu</summary>

The field cannot be updated (a formula or roll-up field, for example), the object is read-only for you, or **All Columns Editable** is already on.

</details>

<details>

<summary>There is no + between the headers</summary>

Inserting a column from the header only works with the **Manual** data source. With **Variable** or **Query**, drag a field, or add a **Custom** column in **Data Mappings** > **Columns**.

</details>

<details>

<summary>A dragged column stays blank when the flow runs</summary>

With a **Variable** source, the Get Records element did not store that field. Add it to the fields the Get Records keeps.

</details>

## Related tutorials

* [Learn the Basics](https://docs.avonnicomponents.com/flow/tutorials/components/data-table/learn-the-basics.md): add the table to a screen and pick its data.
* [Column Types Gallery](https://docs.avonnicomponents.com/flow/tutorials/components/data-table/column-types-gallery.md): every type you can pick in **Type Attributes**.
* [Making a field editable](https://docs.avonnicomponents.com/flow/tutorials/components/data-table/making-a-field-editable.md): editable cells and how the edits get saved.


---

# 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.avonnicomponents.com/flow/tutorials/components/data-table/tips-and-tricks/data-table-editor.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.
