# Datatable setup

**You can control which fields appear in the List view.**

<figure><img src="/files/GbBvcBsAwpzodQ0x1sEU" alt=""><figcaption></figcaption></figure>

* [**Basic settings**](#basic-settings)\
  Control basic settings, such as allowing multiple selections in a data table, summary view, etc.
* [**Adding and editing columns**](#adding-and-editing-columns)\
  Add and edit the columns that appear in your data table.
  * [**Adding columns**](#adding-columns)
  * [**Editing columns**](#editing-columns)
    * Editing default properties
    * Image settings
    * Summary field settings
* [**Virtual fields**<br>](#virtual-fields)Create a virtual column to temporarily hold and display data pulled from an internal or external data source

***

### Basic settings

Control basic settings, such as allowing multiple selections in a data table, summary view, etc.

<figure><img src="/files/Tnps6HcxqWYczC6uJsi0" alt="" width="343"><figcaption></figcaption></figure>

<table><thead><tr><th width="161">Field name</th><th width="412">Description</th><th>Req.</th></tr></thead><tbody><tr><td>Where</td><td>Additional filter conditions to control the results displayed in the data table.</td><td></td></tr><tr><td>Order By</td><td>Control how to sort the displayed results.</td><td></td></tr><tr><td>Records by Page</td><td><p>Select the number of records to display per page.</p><ul><li>20</li><li>50 (default)</li><li>100</li><li>200</li></ul></td><td><mark style="color:red;">✔️</mark></td></tr><tr><td>Multi Selectable</td><td>Displays a checkbox in the first column of the list to allow the user to select multiple records.</td><td></td></tr><tr><td>Show Summary</td><td>If selected, this field will be included in the summary at the bottom of the list.</td><td></td></tr></tbody></table>

### Adding and editing columns

How to a add and edit the columns that appear in your data table.

#### Adding columns

Columns can be added based on the fields in the List target object. If you want to also display data from other Salesforce objects or an external data source, you can create a virtual column in your data table without having to create a field in the target object itself.

<figure><img src="/files/aRoF7U2uTxTF0ZN32ByH" alt=""><figcaption></figcaption></figure>

1. Click the `Add Columns` button.
2. Choose the field you want to add from the popup list.
3. When you have finished adding columns, click the `Add` button.

#### Editing columns

* **Setting default properties**

<figure><img src="/files/8oqf4qENSqkoa9bZV3oY" alt=""><figcaption><p>Editing a Text-type column</p></figcaption></figure>

<table><thead><tr><th>Field name</th><th width="329">Description</th><th>Req.</th></tr></thead><tbody><tr><td>Field</td><td>Shows the API Name of the field used by this column.</td><td><mark style="color:red;">✔️</mark></td></tr><tr><td>Label</td><td>The label displayed in the column header.</td><td><mark style="color:red;">✔️</mark></td></tr><tr><td>Column Align</td><td><p>The alignment of the values in the column.</p><ul><li>Left (default)</li><li>Right</li><li>Center</li></ul></td><td></td></tr><tr><td>Column Width(px)</td><td>The width of the column in pixels.</td><td></td></tr><tr><td>Link</td><td>Clicking a value in the column will redirect the user to this link.<br>You can use <code>{$Current.FieldName}</code> to pass values from the List target object.</td><td></td></tr><tr><td>Image</td><td>Enable this if you want to display an image in this column.</td><td></td></tr></tbody></table>

* **Image settings**

Set the height and width of images, if they are enabled.

<figure><img src="/files/Q0iO30yiXvlr8MVGQi5Y" alt="" width="368"><figcaption></figcaption></figure>

<table><thead><tr><th width="205">Field name</th><th>Description</th></tr></thead><tbody><tr><td>Image Width</td><td>Sets the width of the image in pixels.</td></tr><tr><td>Image Height</td><td>Sets the height of the image in pixels.</td></tr></tbody></table>

* **Summary settings**

If the column type is numeric, you can include a sum total, or an average, at the bottom of your data table.

<figure><img src="/files/1PBWPbTWbWomWu5RxM0N" alt="" width="367"><figcaption><p>Editing a numeric-type column</p></figcaption></figure>

<table><thead><tr><th width="209">Field name</th><th>Description</th></tr></thead><tbody><tr><td>Summary</td><td><p>Enable this to include this column in the summary row at the bottom of your data table.</p><p>💡 'Show Summary' must be enabled in your data table settings.<br><img src="/files/vMwvCvBgK2MdemyC96KV" alt="" data-size="original"></p></td></tr><tr><td>Summary Label</td><td>The label to diplay on the summary.</td></tr><tr><td>Summary Type</td><td><p>Select a summary type.</p><ul><li>Sum: displays the sum total of the values in this column.</li><li>Average: displays the mean average of the values in this column.</li></ul></td></tr></tbody></table>

{% hint style="info" %}
The field type is either Text, Number, Currency or Image

The summary type is either Sum, Average or Count
{% endhint %}

### Virtual fields

Creates a virtual column that can temporarily hold and display data pulled from an internal or external data source.

Your object table will not really contain this column, but it can still be displayed. This is useful when you want to display values from other Salesforce objects or external systems.

<figure><img src="/files/BVuP7u2qLKxhCwy5gEn0" alt=""><figcaption></figcaption></figure>

<table><thead><tr><th width="138">Field name</th><th width="409">Description</th><th>Req.</th></tr></thead><tbody><tr><td>Virtual Type</td><td><p>Select the data type for the virtual column.</p><ul><li>Text</li><li>Number</li><li>Currency</li></ul></td><td><mark style="color:red;">✔️</mark></td></tr></tbody></table>


---

# 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://help.smallbuilder.com/smallbuilder-lists/setup/datatable-setup.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.