STAGIL Tables for Jira provides the following column types, which are described in the following:
Settings Available for All Column Types
Read-only/Mandatory
For all column types that are listed below you can choose to make columns mandatory and/or read only by checking the checkboxes:
Single Issue Picker
Allow to lookup an issue via key or text search and display it in the column.
Add Translations
To add a translation to a column, please click on "Translate", type translation and choose language:
Simple Text
This is a text field where you can insert text and numbers. By clicking on Manage you can define the properties of your simple text column type, such as the max. or min. length.
Regular expression: Use this field, if the user's input should be checked with a RegEx validation. If desired you can add an regular expression error message as well.
User Picker
Choose this column type, if you want to select an existing Jira user. If you want the mentioned user to receive a notification mail go to → Manage and check the checkbox:
Select List
Here you can create a drop-down select list. To manage and create options, click on → Manage. The following screen will appear and will let you define the possible amount of selections and of course to add new options to choose from:
Unique Values: By selecting this checkbox it is not possible to select any value twice in your table.
Number
In this field, you can fill in numbers. If you want to sum up all the numbers in the column, select → Sums.
To limit the input and set a range between a minimum and a maximum value, click → Manage and choose minimal and maximum value:
Date Picker
This column type works like a normal Jira date picker field. Useful for setting deadlines or organizing events.
Decimal Number
In this field, you can insert any decimal number and also sum them. The separator will be chosen according to your selected user language (. vs ,).
Formula
With the formula column, you are able to calculate values based on other columns of type number or decimal number. Note that the calculated value will be read-only and will only show up to 5 characters after the comma. To see an example of the usage of the formula column, please check this example.
Issue Picker
Allows you to choose any issue as a value for your column. Currently, only one issue per row is available for selection. Control the issues available in the drop-down search either via JQL or configuring the searching user permissions. Go to the Table Configuration → Manage row. Set the Searching User field:
if Current User is selected - the search will be populated with issues available per view according to the Jira permissions of the searching user. Note, that even without the permissions current user will see the issue key, but not the summary.
if User is selected - the searching user will be able to have access to issues according to the permissions of the selected user.
