...
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 app. 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.
...
| Macro Body | [{a: 1495020217, b: 1495020217.0}] |
| JSON Table settings > Data settings > Output format | wiki |
| JSON Table settings > Data format > Augments to data row values | , "{groovy}def x='%1%'; print x.substring(0,10){groovy}" |
Column settings > Formatting > Column type (1 2) | MX~YYYY-MM-DD MX~YYYY-MM-DD |
Screenshot
Example Result
...