This page contains information about the grid configuration its properties and features. Find all details about the functionality here.
You can use different data types in grid with the help of available column types.
Data import into a grid
Import from CSV and Excel (.xlsx and .xsl) files is available. Moreover, it's possible to import several files into the grid, predefined with some data.
You can filter data within the grid using available filtering options.
Static data in a grid
You can pre-populate the grid with some static data. It should be added in the grid configuration page.
Formulas in a grid
Lists in a grid
Searching data with a JQL query
You can search issue by grid data.
Multi Cell Copy support
In Table Grid Cloud you can copy your data to multiple cells at the same time.
The data sources allow to specify how to connect the grid to an external database, located on a remote server. You can reuse a connection in multiple grids.
Add a drop-down list with options into a grid. Use the dynamic list to select options from the previously connected data source.
Data source HTTP basic authentication
The data source is stored on a web-server. If the web server with your data source supports HTTP basic authentication, you will need to configure it in the data source configuration.
Predefined date and time presets based on locale
Table Grid for Jira Cloud provides a set of date and time presets for Date, DateTime and Time column types. These presets are based on locale.
Data storage in Table Grid Cloud
We use Atlassian Connect Framework to integrate Table Grid Editor with Jira Cloud. The Table Grid is a web application that operates remotely over HTTP. It appears as a fully integrated part of Jira Cloud.
Date/Time format rules
Date, Time and DateTime column types allow to set the formatting for displayed data in the column. Check available format options in this article.
Export/import grid configuration
You can download the configuration of your grid as a .json file and then import it to another grid.
How to create formula
Jira values placeholders
Get data from Jira objects and use them to populate the grid.
Column values placeholders
Create dependent columns like cascading select lists in a grid using column values placeholders.