Confluence has been updated to version 6.15.9

Page tree
Skip to end of metadata
Go to start of metadata

This page contains information about the grid configuration its properties and features.  Find all details about the functionality here. 

Column Types

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. 

Filterable options

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

Use formula as a separate column or as an aggregation option within other column types. You can input formula inside embedded JavaScript Editor and get results on the grid view. The grid can process formula logic and display formula results.

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.

Data sources

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. 

Dynamic list

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

You can execute different operations using formulas in the grid. the formula is based on JavaScript.

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.

Retrieving option attribute values from list columns