Compiling Child Tables into Table on Parent Edited

I’m looking for a way to compile a table on a Parent page that is made up of entries in tables on Child pages.

 

Here is my scenario: I have a Parent page on which I monitor the status of all tasks (in Child pages) via the Page Properties macros. We copy the page format for every new task (potentially hundreds of them, so Excerpt + Excerpt Include isn't feasible).

 

Each Child page also has a table used to track purchases related to the task, sometimes as many as ten rows of individual parts but always the same columns. Unfortunately, when I try to use the Page Properties macros to combine these all on to the Parent page, it only copies the first row of the table and nothing else.

 

Is there a better way to do this? Essentially I’m in need of a way to compile/filter all tables from children into one “summary table” on the Parent page, to track their status the way page project status is tracked with the Page Properties macros.

 

Perhaps I’m looking at the problem incorrectly? Any help is greatly appreciated, thank you!

2 answers

Hello Josh,

You can use Page Include or Excerpt + Excerpt Include macros to show all tables you need on a single page. Also you can use Table Filter or Pivot Table macros to analyse this data.

Excerpt + Excerpt Include macros will require me to place a new macro for every new page created though, right? I want the compiling/merging of tables to happen automatically, as happens when using Page Properties macros....

If you are looking for a tool to excerpt a number of fragments from a number of pages, you could look for a macro that supports multi-transclusion (or multi-excerpt in Confluence lingo).

The solution would be like this: Each table on the child page would be wrapped in a section (that is some kind of macro like the excerpt macro) and the multi-transclusion macro (on the parent page) would select these section(s) from all pages that meet a certain criteria ("being a child page" in your case). New pages would meet the search criteria and are added automatically. The result is a number of tables (probably all with different column widths) on one page. Maybe one of the add-ons Andrey mentions provides a tool to merge those tables (from his answer I would assume that)?

[Edit]: With version 2.1 the projectdoc Toolbox provides two table merging macros:

  1. Table Merger Macro
  2. Table Set Macro

[/Edit]

If the multi-transclusion would be a practical workaround or one step to the solution for your problem, the commercial projectdoc Toolbox provides the Transclude Documents Macro to do this for Confluence Server.

Bias alert: I'm one of the authors of this add-on.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

346 views 20 10
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you