Skip to main content

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"}}