# Table settings

> [HTML Version](table-visibility.html)

You can adjust the table design and functions which are available for users when working with the table. To do this, in the [app form settings](360009918011.md#configuringformfields), select the **Table**-type field and click **Table Settings**.**(task_settings_01.png)**

In the window that opens, you can:

- [Set general table parameters](#generalsettings). Adjust row width and height, manage numbering, data grouping, etc.

- [Configure table columns display](#column-settings). Define the order of columns, their width, data visibility, and whether fields are required. For each column, you can specify a title, sorting method, and other parameters.



## General settings

General settings are applied to the whole table. The following options are available:

**(task_settings_02.png)**

- **Fit Table to Window **or** Custom**. Select **Fit Table to Window **if you want the table to stretch across the width of the page. Column sizes will be percentages of the total table’s width. Select **Custom** to set a fixed pixel width for each column. The total width of the table will equal the sum of the column sizes.

- **Minimum row height in pixels (35 or higher)**. To align the table, set the height of its rows. The minimum value is 35 pixels.

- **Show sequential number for rows**. A column for the row’s number will appear in the table. Numbers will be filled out automatically.

- **Allow deleting rows with read-only cells**. Enable this option to let users remove rows even if the table includes read-only columns. Let’s say there are read-only cells in the **Order details** table. These are the cells that data from the **Orders** app is passed to. The rest of the data in the table is entered by the sales rep. If the option is enabled, the sales rep will be able to delete a row in the table, for example, if the data is incorrect.

- **Group table rows**. This option allows structuring data in the table and displaying it in a more convenient way.

	- In the** Group by column **field, specify the column that rows need to be grouped by.

	- Use the **Sort in** option to place groups of cells in ascending or descending order. If you group items based on a **String** type field, items will be sorted alphabetically.   
  
Note that if the [Sorting](#sorting) option is enabled for a column, you are not allowed to group rows. In the notification that appears, select the option that you want to keep.

- **Show new table version**. It allows you to apply the updated table appearance and [advanced functionality](#new-version). Starting with system version 2026.1, this option is enabled by default. In earlier versions of BRIX On‑Premises, enable it. Additional options will become available in the table settings.

- **Disable adding rows**. Enable the option to prevent users from adding rows while filling out the table in the [new version](#new-version).

- **Show number of rows**. Enable this option to display the total number of rows in the upper left corner of the table.

- **Enable pagination**. Enable this option and choose how to display large amounts of data in the table:

	- **Paginated**. Data is spread across multiple pages.

	- **Load on scroll**.** **This option is available when row grouping is disabled. Records are loaded as you scroll down the table.  
  
In the** Rows per page\*** field that appears, specify how many rows will be displayed in the table on each page or per scroll.



## Column settings

For each column, you can set:

- [Width](#width).

- [Design](#design).

- [Visibility](#visibility).

- [Read only and Required flags](#readonlyandrequiredflags).

- [Sorting](#sorting).

### Width

Depending on the **Fit Table to Window/Custom **option, a column’s size is set either as a percentage of the table’s width or in pixels. To set the custom column width, drag the column’s border.

**(table-visibility-4.png)**

A column’s width can also change automatically to match the width of its content. To enable this option, click the value of the column’s width and select one of the following options:

**(table_width_01.PNG)**

- **Set to maximum**. This setting is available when the **Fit Table to Window** option is selected. The column will be as wide as possible, limited by the width of other columns. When you select this option, the width’s value will change to **max**. 

- **Set to minimum**. This setting is available when the **Custom** option is selected. The column’s width will be equal to the size of the longest item in its cells. When you select this option, the width’s value will change to **min**.

### Design

You can apply a background color to columns, change the text’s alignment or font color, and make it underlined, italic, or bold. To do that, click the gear icon next to a column’s name. In the pop-up window that opens, switch between different options to format text the way you want.

**(table-visibility-6.png)**

### Visibility

You can hide the headers and footers of all the columns in the table. To do that, click the **(eye.png) **icon on the left of the table. To make a hidden element visible again, click **(eye-closed.png)**.

**(table_settings_05.png)**

## Read only and Required flags

You can configure how data is added in the table columns using the following options: 

**(table_settings_06.png)**

- **Read only**. Click the **(hmfile_hash_96aa8b20.png)** icon in the row above the column header to prevent users from modifying data in that column.  
  
If the table contains columns that are read-only, users cannot delete rows by default. To change this behavior, enable the option **Allow deleting rows with read-only cells** in the [table settings](#generalsettings).

- **Required**.** **Click the asterisk icon to prevent users from saving changes until all cells in the column are filled in. To remove the requirement, click the asterisk again.

For more details on configuring table display in the advanced mode of form settings, as well as in widget, page, and process task forms, see [Customize table display on different form types](customizing-table-visibility.md).

## Sorting

You can sort data in columns in ascending and descending order, as well as alphabetically. Sorting is only available for the following types of fields: [Number](360009707032.md#number), [Date/Time](360009707032.md#date-time), [Money](360009707032.md#money), [String](360009707032.md#string), [Users](360009707032.md#users), [App](360009707032.md), [Phone number](360009707032.md#phone-number), [Full Name](360009707032.md#full-name), and [Email address](360009707032.md#email).

To enable sorting for a column, check the **Sorting** box when you [create](360010201779.md#addingtabletoappform) or edit it.

**(table-visibility-9.png)**

Note that sorting is not available if you use the [Group table rows](#grouptablerows) option. In the notification that appears, select the option you want to keep.

When you enable sorting, you can open an app item’s view form and click the corresponding column header. Cells will be sorted in the ascending order. If you click the header again, they will be sorted in descending order. Another click will reset the order of cells.

## New table version features

Starting with system version 2026.1, advanced functionality with additional options and an improved appearance is applied by default.

To use changes in earlier versions of BRIX On‑Premises, enable the **Show new table version** option in the [general settings](#generalsettings). The option becomes available after enabling the \[OBJECT\] feature flag. For more details, see [Modify BRIX parameters](change-settings-enterprise.md#enable-feature-flag-enterpeise).

In the new table version, users have access to the following features:

1. While filling out the table, users can open the row context menu to add rows above or below the current one, or delete the row.  
  
In the table settings, you can also [prohibit users from adding new rows](#disable-adding-rows).  
**(table-visibility-13.png)**

2. In columns with the [App](360009707032.md#app) type, users can not only select an item in a cell but also create a new one using the** + Create** button. To enable this, select the **Show a button that allows users to add new items** option in the column settings.  
**(table-visibility-14.png)**

3. You can can change the order of rows within a table using drag-and-drop. To do this, hold the **(table-visibility-15.png)** icon in the row header and drag the row up or down.  
  
If [row grouping](#grouptablerows) is enabled, rows can only be moved within the same group. Moving rows between groups is not available.

4. If a table contains a lot of data, you can view it by switching between pages or scrolling down. The system administrator configures the data display method in the [general table settings](#pagination).

5. By adding a **Table** variable to a form template in the interface designer, you can bind a script to user actions with specific table data. For example, you can automatically fill in certain table cells when an employee enters values in tracked cells. For more information, see the [article on setting up table events](table-events.md).