Column Types

 

 

This article describes available column types in Table Grid Editor for Jira Cloud.

String

The column is used to enter a single line of text. By default the text is aligned left.

Textarea

Use this type to add plain text, including paragraphs. The column is available for JQL search. You can set a maximum number of characters in the column configuration. To add a new paragraph in the table cell, please use Ctrl+Enter hotkey.

By default the text is aligned left.

To add a custom formatting use the Wiki Markup. Check how to format text in textarea column for more details.

Single Select List

Use this type to represent a drop-down list of options with single choice. There are static and dynamic options; you can combine them in one column.

You can configure dynamic options using an external data source

Multi Select List

Use this type to represent a list of options where you can pick multiple choices. There are static and dynamic options; you can combine them in one column.

You can configure dynamic options using an external data source

Integer

Use this type to store plane integer number.  By default the text is aligned right.

Number

Use this type to store number fields with a decimal.  By default the text is aligned right.


Checkbox

Use this type to display a checkbox. By default the checkbox is not set. This type uses boolean values. 

 

Userlist

Use this type to select a JIRA User from a dropdown list.  A cell displays User avatar alongside with the User display name.

Date

Use this type to store date data. You can set custom format or select the predefined presets based on locale. The default format is set to 'L'.  


DateTime

Use this type to store date and time data. You can set custom format or select the predefined date and time presets based on locale. The default format for is set to 'L' for date and 'hh: mm A' for time.

Time

Use this column to store time data. You can set custom format or select the predefined presets based on locale. The default format is set to 'hh: mm A'.

Formula

Allows executing formula expression written in JavaScript.  Displays a result of the formula specified in the column configuration. 

Sequence

Use this type to set an auto-countable column. Usually used to count the table rows. You can set a step size in the column configuration.

Default step is set to 1. You can use this column type in JQL search. 

Attachment

Use this column type to add various types of attachments to your grid.

To upload a file in the grid press → Upload.

Uploading is not available when you configure the grid.

The file name and format are displayed in the cell after uploading.

Attached files appear in the Attachments section of your Jira issue and in the drop-down list of attachments after saving the grid.

If you delete the attachment from the Attachments section, the attachments will not be available in the grid.