Overview

This page shows how to use Augments for field manipulation or calculations when using the JSON Table macro, which is part of the Advanced Tables for Confluence add-on. In this example, we use Groovy scripting to do field modification based on the field data. This is just a simple example of the technique.

Scripting is expensive, so make sure you surround the json-table macro with the Cache Macro and/or the Future Macro to minimize response time for the page.

Reference: Using Augments with JSON Table.

Macro Browser Input

Select this Macro

Macro Name	JSON Table
Macro Syntax	{json-table}

Define these Parameters/Values

Body	[{a: 1495020217, b: 1495020217.0}]
Output format	wiki
Augments to data row values	, "{groovy}def x='%1%'; print x.substring(0,10){groovy}"
Column types	MX~YYYY-MM-DD, MX~YYYY-MM-DD

Example Result

A	B
2017-05-17	2017-05-17

Other Examples

Visit our full list of product examples for additional inspiration!

Advanced Tables for Confluence

JSON Table Field Manipulation or Calculations

On this page