> 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/dynamic-components/tutorials/components/data-table/tips-and-tricks.md).

# Tips & Tricks

Short answers to the Data Table questions admins ask support most often, each with a link to the tutorial that covers it in full.

{% embed url="<https://www.youtube.com/watch?v=acf2qNSkWpA>" %}

The tips below answer questions admins have asked our support team. Each one uses a setting that already exists.

## Show the record name as a link

Map the column to the Name field, set **Type** to **Text** and turn on **Linkify** under **Type Attributes**. The name opens the record. Do not use the **Url** type for this: it expects a web address or a record Id, not a name. On a **Lookup** column, the same **Linkify** toggle links to the related record.

<figure><img src="https://2532358799-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FODPvvv7Cx9Z9RECLn3oV%2Fuploads%2F2SS7RrQ3NsGAHYEv2CIN%2Fdata-table-tutorial-use-rich-column-types-result.png?alt=media" alt="A Data Table titled Deal review with six open deals: linked opportunity names, the owner as a round photo with the name, Probability as a blue bar with 20% to 90%, and Deal Health as two to five filled stars out of five"><figcaption><p>Linked deal names, an owner avatar, a probability bar and star ratings in one deal review table.</p></figcaption></figure>

Go further: [Use Rich Column Types](https://docs.avonnicomponents.com/dynamic-components/tutorials/components/data-table/use-rich-column-types.md).

## A date shows the day before

Check the column **Type**. **Date** displays a Date field exactly as stored. **Date Time** converts the value to the user's time zone, so a date stored at midnight can move to the previous day for users west of UTC. The builder offers Date for Date fields, but a configuration written by hand or by an AI assistant can carry Date Time.

Go further: [Data Table](https://docs.avonnicomponents.com/dynamic-components/components/data-table.md).

## Show each amount in its own currency

On a **Currency** column, open **Type Attributes**. In a multi-currency org, bind **Currency Code** to the record's `CurrencyIsoCode` field so each row shows its own currency. **Currency Display As** chooses between the **Symbol**, the **Code** and the **Name** of the currency.

Go further: [Data Table](https://docs.avonnicomponents.com/dynamic-components/components/data-table.md).

## Export Ids without showing them

To reimport an export, you need the record Ids in the file, not on screen. A **Hidden** column is left out of the export. Add the fields to **Export To Fields** in the **Data Mappings** section instead (**Query** data source only): they are exported after the visible columns.

Go further: [Enable Data Export](https://docs.avonnicomponents.com/dynamic-components/tutorials/components/data-table/enable-data-export.md).

## Search a field the table does not show

Add the field to **Search Fields** in the **Data Mappings** section. Keep at least one displayed column with **Searchable** on, or the search box does not appear.

Go further: [Set Up Search](https://docs.avonnicomponents.com/dynamic-components/tutorials/components/data-table/set-up-search.md).

## Open the table already filtered

In the **Filters** collection of the **Data Mappings** section, set a **Default Value (Optional)** on a filter. The table loads filtered, and users can still change or clear the value.

Go further: [Add User Filters](https://docs.avonnicomponents.com/dynamic-components/tutorials/components/data-table/add-user-filters.md).

## Send the clicked row to a panel

When a row action opens a panel, map the panel's input variable to the row's Id from the **Record** entries (for example `Record: Opportunity ID`). That is the row the user clicked. **First Selected Row** follows the selection checkboxes, so it stays empty when nobody ticked a row.

Go further: [Open Dynamic Component Panel](https://docs.avonnicomponents.com/dynamic-components/component-builder/interactions/open-dynamic-component-panel.md).

## Apply a setting to every column at once

The advanced options of the **Content** section hold **All Columns Editable**, **All Columns Filterable**, **All Columns Searchable**, **All Columns Sortable** and **All Columns Wrappable**. One toggle replaces opening each column in **Data Mappings**.

Go further: [Data Table](https://docs.avonnicomponents.com/dynamic-components/components/data-table.md).


---

# 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/dynamic-components/tutorials/components/data-table/tips-and-tricks.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.
