Using Page property report and table toolbox together

Lisa.Kohlstrung

I am trying to use several macro's together to create a readable table with about 20 columns and as much rows. 

Within that I want to:

- fixate the first row of the table so that the titles of the table stay above the cells when scrolling

- the modified date should be shown displaying Date and time, not the friendly date (so "1/1/11, 15:30" over "yesterday at 8:12 AM")

- use the Table transformer within the toolbox to display the page properties report as a normal table so the table is easier to read. 

I have tried combining those macros (Page property report in table filter in table transformer) however, the macro's seem to conflict with each other/filter each other out. 

I can't get the last modified date to be displayed as date and time (this might be related to space settings, I am still looking into this with my Confluence administrator). 
Also, even though I have specifically added that the first row needs to be fixed the setting seems to be ignored.

Any idea on how to fix this is welcome. 
Thank you in advance!

Katerina Kovriga {Stiltsoft}

Hi @Lisa.Kohlstrung ,

Your idea seems to be right, Confluence Cloud doesn't support macro nesting and you need to wrap your Page Properties Report macro in the Table Toolbox macro - the latter is a shell for macro wrapping. Inside its settings you will be able to create different sequences of other macros.

If you are stuck with smth, you may book a live demo for us to see what exactly is happening on every step. Or you may refer to our support (our portal is based on the Jira Service Desk and it's confidential). Give us a screenshot of your Page Properties Report macro (in a published state with visible headers and some examples of the dates to understand what we have and how we need to transform them), we'll recreate your table and guide you through other steps.

P.S. For the starters try to switch places for the Table Filter and Table Transformer macros. I mean, at first you transform your table and then freeze rows, not vise versa.