Skip to main content
Version: 2.43.0

Columns

Whenever data is loaded into a Table, the columns are automatically generated. You can add, remove, or modify columns by accessing the table properties under the column section. You can also rearrange the columns by dragging and dropping them.

ToolJet - Component Reference - Columns

Use dynamic column

The Use dynamic column toggle allows users to dynamically set the columns of the Table using a JSON value.

For example, if you enter the below JSON, the table will display a column labeled "Name" where the data entries are editable strings, restricted in length between 5 and 20 characters, displayed in white text on a black background.

{
"name":"Name",
"columnType":"string",
"key":"first_name",
"cellBackgroundColor":"#000",
"textColor":"#fff",
"isEditable":true,
"regex":"",
"maxLength":20,
"minLength":5,
"customRule":""
}
ToolJet - Component Reference - Dynamic Columns

Types of Columns

The table component supports the following column types:

String

This column type is used for columns with text values. Unlike the text column type, string type doesn't support multi-line text.

Properties

PropertyDescriptionExpected Value
Column NameSpecify the name to be displayed on the table column header.String (e.g., Product Name).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., product_name).
TransformationAllows you to transform the data of a cell value. The default value will be {{cellValue}}.Use JavaScript for dynamic value generation, e.g., {{cellValue > 4.5 ? 5 : 4}}.
Make EditableThis option is disabled by default. Enabling it allows the column to be edited by app users.Enable/disable the toggle button or dynamically configure the setting by clicking on fx and entering a logical expression.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right, which can be specified using the switch.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

Number

Selecting the column type as number will load numerical data in the column cells.

Properties

PropertyDescriptionExpected Value
Column NameSpecify the name to be displayed on the table column header.String (e.g., Quantity).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., quantity).
TransformationAllows you to transform the data of a cell value. The default value will be {{cellValue}}.Use JavaScript for dynamic value generation, e.g., {{cellValue > 4.5 ? 5 : 4}}.
Decimal placesSpecifies the number of decimal places for numerical values.Integer (e.g., {{2}}).
Make EditableThis option is disabled by default. Enabling it allows the column to be edited by app users.Enable/disable the toggle button or dynamically configure the setting by clicking on fx and entering a logical expression.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right, which can be specified using the switch.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

Text

The text column type can be used for multi-line text.

Properties

PropertyDescriptionExpected Value
Column NameSpecify the name to be displayed on the table column header.String (e.g., Product Description).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., product_description).
TransformationAllows you to transform the data of a cell value. The default value will be {{cellValue}}.Use JavaScript for dynamic value generation, e.g., {{cellValue > 4.5 ? 5 : 4}}.
Make EditableThis option is disabled by default. Enabling it allows the column to be edited by app users.Enable/disable the toggle button or dynamically configure the setting by clicking on fx and entering a logical expression.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right, which can be specified using the switch.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

Datepicker

The datepicker type can be used to display dates.

Properties

PropertyDescriptionExpected Value
Column NameSpecify the name to be displayed on the table column header.Date (e.g., 13/09/1990)
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., listing_date)
TransformationAllows you to transform the data of a cell value. The default value will be {{cellValue}}.Use JavaScript for dynamic value generation, e.g., {{cellValue > 4.5 ? 5 : 4}}.
Make EditableThis option is disabled by default. Enabling it allows the column to be edited by app users.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Date format

PropertyDescriptionConfiguration Options
Enable dateEnables the option to change the formatting of the date.Use the toggle button or click on fx and enter a logical expression.
Date formatConfigures the display format for date values within the column.Use the drop down with common formats (Default: DD/MM/YYYY) or click on fx and enter a logical expression.
Enable dateEnables the option to change the formatting of the time.Use the toggle button or click on fx and enter a logical expression.
Enable 24 hr time formatEnables the option to change the formatting of the time to 24 hours.Use the toggle button or click on fx and enter a logical expression.
Enable 24 hr time formatEnables the option to change the formatting of the time to 24 hours.Use the toggle button or click on fx and enter a logical expression.
Time zoneAllows the selection of timezone.Use the drop down to select the time zone.

Parse format

PropertyDescriptionConfiguration Options
Parse in unix timestampEnables parsing and display of date, time, and time zone data.Use the toggle button or click on fx and enter a logical expression.
Unix timestampSelect between s or ms as the format.Use the drop down to select the desired unix timestamp format.

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right, which can be specified using the switch.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

Select

The select column can be used to display or select a single item from a list.

Properties

PropertyDescriptionExpected Value
Column NameSpecify the name to be displayed on the table column header.String (e.g., Category).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., category).
TransformationAllows you to transform the data of a cell value. The default value will be {{cellValue}}.Use JavaScript for dynamic value generation, e.g., {{cellValue > 4.5 ? 5 : 4}}.
Make EditableThis option is disabled by default. Enabling it allows the column to be edited by app users.Enable/disable the toggle button or dynamically configure the setting by clicking on fx and entering a logical expression.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Options

Options can be used to provide values for the select column as an array. You can click on the Add new option button and enter Option label and Option value to create a new option. You can switch on the toggle for Make this option as default to mark an option as the default value. You can also enable Dynamic option and enter an array of values as shown in the example below:

{{[{ label: "Mobile Phones", value: "mobile-phones" },
{ label: "Smartphones", value: "smartphones" },
{ label: "Compact Cameras", value: "compact-cameras" },
{ label: "DSLR Cameras", value: "dslr-cameras" },
{ label: "Smart Watches", value: "smart-watches" },
]}}

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right, which can be specified using the switch.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

MultiSelect

The MultiSelect column can be used to display or select multiple items from a list.

Properties

PropertyDescriptionExpected Value
Column NameSpecify the name to be displayed on the table column header.String (e.g., Locations).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., locations).
TransformationAllows you to transform the data of a cell value. The default value will be {{cellValue}}.Use JavaScript for dynamic value generation, e.g., {{cellValue > 4.5 ? 5 : 4}}.
Make EditableThis option is disabled by default. Enabling it allows the column to be edited by app users.Enable/disable the toggle button or dynamically configure the setting by clicking on fx and entering a logical expression.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Options

Options can be used to provide values for the select column as an array. You can click on the Add new option button and enter Option label and Option value to set the option values. You can switch on the toggle for Make this option as default to mark an option as the default value. You can also enable Dynamic option and enter an array of values as shown in the example below:

{{[{ label: "Technology", value: "technology" },
{ label: "Apparrel", value: "apparrel" },
{ label: "Jewelry", value: "jewelry" },
{ label: "Furniture", value: "furniture" },
]}}

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right, which can be specified using the switch.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

Boolean

The boolean column type can be used to display boolean values. If the value is true, a green tick will be displayed and for false values a red cross will be displayed.

Properties

PropertyDescriptionExpected Value
Column nameSpecify the name to be displayed on the table column header.String (e.g., Validity).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., is_valid).
TransformationAllows you to transform the data of a cell value. The default value will be {{cellValue}}.Use JavaScript for dynamic value generation, e.g., {{cellValue > 4.5 ? 5 : 4}}.
Make EditableThis option is disabled by default. Enabling it allows the column to be edited by app users.Enable/disable the toggle button or dynamically configure the setting by clicking on fx and entering a logical expression.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right, which can be specified using the switch.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

Image

The image column type can be used to display images.

Properties

PropertyDescriptionExpected Value
Column nameSpecify the name to be displayed on the table column header.String (e.g., Product Image).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., product_image).
TransformationAllows you to transform the data of a cell value. The default value will be {{cellValue}}.Use JavaScript for dynamic value generation, e.g., {{cellValue > 4.5 ? 5 : 4}}.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right, which can be specified using the switch.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

The link column type can be used to create a link to .

Properties

PropertyDescriptionExpected Value
Column NameSpecify the name to be displayed on the table column header.String (e.g., Product Description).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., id).
TransformationAllows you to transform the data of a cell value. The default value will be {{cellValue}}.Use JavaScript for dynamic value generation, e.g., {{cellValue > 4.5 ? 5 : 4}}.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right, which can be specified using the switch.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

Default (Deprecated)

This default column is used to display text.

Properties

PropertyDescriptionExpected Value
Column NameSpecify the name to be displayed on the table column header.String (e.g., Product Description).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., product_description).
TransformationAllows you to transform the data of a cell value. The default value will be {{cellValue}}.Use JavaScript for dynamic value generation, e.g., {{cellValue > 4.5 ? 5 : 4}}.
Make EditableThis option is disabled by default. Enabling it allows the column to be edited by app users.Enable/disable the toggle button or dynamically configure the setting by clicking on fx and entering a logical expression.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right, which can be specified using the switch.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

The Dropdown column type is used to display a dropdown in the column cells using the column data.

Properties

PropertyDescriptionExpected Value
Column NameSpecify the name to be displayed on the table column header.String (e.g., Category).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., category_id).
ValuesProvide the values for the dropdown as an array.Array (e.g., [1, 2, 3]).
LabelsProvide the labels for the values in the dropdown as an array.Array (e.g., ["Option 1", "Option 2", "Option 3"]).
Make EditableThis option is disabled by default. Enabling it allows the column to be edited by app users.Enable/disable the toggle button or dynamically configure the setting by clicking on fx and entering a logical expression.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

Multiselect (Deprecated)

The multiselect column type is used to show multiple selections or display a dropdown in the column cells using the column data.

Properties

PropertyDescriptionExpected Value
Column NameSpecify the name to be displayed on the table column header.String (e.g., Tags).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., tag_ids).
ValuesProvide the values for the dropdown as an array.Array (e.g., [1, 2, 3]).
LabelsProvide the labels for the values in the dropdown as an array.Array (e.g., ["Tag 1", "Tag 2", "Tag 3"]).
Make EditableThis option is disabled by default. Enabling it allows the column to be edited by app users.Enable/disable the toggle button or dynamically configure the setting by clicking on fx and entering a logical expression.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

Toggle Switch (Deprecated)

The Toggle Switch column type is used to display a toggle switch in the column cells, providing a clear visual indicator for boolean values.

Properties

PropertyDescriptionExpected Value
Column NameSpecify the name to be displayed on the table column header.String (e.g., Active Status).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., active).
Active ColorSet the color of the toggle switch when it is active.Color code (e.g., #76D7C4).
Make EditableThis option is disabled by default. Enabling it allows the column to be edited by app users.Enable/disable the toggle button or dynamically configure the setting by clicking on fx and entering a logical expression.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

Radio (Deprecated)

The Radio column type is used to show radio buttons in the column cells, offering a single-choice selection from multiple options.

Properties

PropertyDescriptionExpected Value
Column NameSpecify the name to be displayed on the table column header.String (e.g., Membership Type).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., membership_type).
ValuesProvide the values for the radio buttons as an array.Array (e.g., [1, 2, 3]).
LabelsProvide the labels for the values in the radio buttons as an array.Array (e.g., ["Gold", "Silver", "Bronze"]).
Make EditableThis option is disabled by default. Enabling it allows the column to be edited by app users.Enable/disable the toggle button or dynamically configure the setting by clicking on fx and entering a logical expression.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

Badge (Deprecated)

The Badge column type is utilized to exhibit labels or tags on the columns, visually distinguishing the data.

Properties

PropertyDescriptionExpected Value
Column NameSpecify the name to be displayed on the table column header.String (e.g., Status).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., status).
ValuesProvide the values for the badge as an array.Array (e.g., ["new", "in_progress", "completed"]).
LabelsProvide the labels for the values in the badge as an array.Array (e.g., ["New", "In Progress", "Completed"]).
Make EditableThis option is disabled by default. Enabling it allows the column to be edited by app users.Enable/disable the toggle button or dynamically configure the setting by clicking on fx and entering a logical expression.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

Multiple Badges (Deprecated)

Similar to the Badge type, the Multiple Badges type is used to display multiple badges within a column cell, providing a more nuanced display of statuses or categories.

Properties

PropertyDescriptionExpected Value
Column NameSpecify the name to be displayed on the table column header.String (e.g., Features).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., features).
ValuesProvide the values for the multiple badges as an array.Array (e.g., ["wifi", "bluetooth", "gps"]).
LabelsProvide the labels for the values in the multiple badges as an array.Array (e.g., ["WiFi", "Bluetooth", "GPS"]).
Make EditableThis option is disabled by default. Enabling it allows the column to be edited by app users.Enable/disable the toggle button or dynamically configure the setting by clicking on fx and entering a logical expression.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

Tags (Deprecated)

The Tags column type is utilized to display an array of tags within the column cells, providing a flexible way to categorize or tag items dynamically.

Properties

PropertyDescriptionExpected Value
Column NameSpecify the name to be displayed on the table column header.String (e.g., Tags).
KeySpecify the key name associated with the loaded data in the table. Uses Column name if no key is provided.String (e.g., tag_list).
Make EditableThis option is disabled by default. Enabling it allows the column to be edited by app users.Enable/disable the toggle button or dynamically configure the setting by clicking on fx and entering a logical expression.
VisibilityThis option is enabled by default. Disabling it hides the column from the table.Enable/disable the toggle button or dynamically configure the value by clicking on fx and entering a logical expression.

Styles

PropertyDescriptionConfiguration Options
Text AlignmentAligns the text within the column.Set alignment to left, center, or right.
Text ColorModifies the color of the text in the column.Select the color or click on fx and input code that programmatically returns a Hex color code.
Cell Background ColorAdjusts the background color of the cell.Select the color or click on fx and input code that programmatically returns a Hex color code.

Add Column

You can add a new column to the table by clicking on the + Add new column button. On clicking this button a new column will be added to the Table and you can edit it's properties from the column section.

Duplicate Column

On hovering on a column, you can see a clone icon next to delete which can be used to create a duplicate copy of the same column.

Delete Column

On hovering on a column, you can see a delete icon on the right which can be used to delete a column.

Hide columns

You can choose which columns to show or hide in the Table using this option. You also have the option to hide the column selector button in the Table properties.

Make all columns editable

To make all the columns editable in your table, you can enable the Make all columns editable toggle. If you disable the Make editable property of any individual column, Make all columns editable will automatically switch to disabled.

Validation

Under column properties, when you switch on the Make editable toggle, you will be able to see validation options that will be different for each column type. For instance, the a column with string type will have the following validations.

Regex

Use this field to enter a Regular Expression that will validate the content.

Min length

Enter the number for a minimum length of characters allowed.

Max length

Enter the number for the maximum length of characters allowed.

Custom rule

If the condition is true, the validation passes, otherwise return a string that should be displayed as the error message. For example: {{components.table1.selectedRow.id==1&&"This row can't be deleted"}}