Are they any macro to combine all table from different pages

Mos Sepia January 6, 2019

I found only Table Excerpt Macro and Table Excerpt Include Macro but it can use only in that page.

For now my team confluence have 4 page for booking different 4 room. In each page have a table that can fill the name to book the room in each period of time.

Therefore, the purpose is I would like to show the summary (real  time) in 1 master page then it will easy to see which room is available for them to book 

3 answers

3 votes
Natalie Paramonova _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 8, 2019

Hello,

Page properties report is a great solution when you need to excerpt just one row from every page.

Starting from version 5.0.0, the Table Filter and Charts app provides the abilities to multi-excerpt tables from any pages (current page, specific page, child pages, pages by labels) with the help of the Table Excerpt Include macro and to combine excerpted tables in one master table with the help of the Table Transformer macro.

The steps may be as follows:

1. Insert the Table Excerpt macro, set the Excerpt name parameter, and place the tables (or the macros outputting tables) within the macro body on every page.

2019-03-28_18h09_44.png

2. Add the Table Excerpt Include macro on the summary page, specify Excerpt name and select an appropriate Excerpt source.

2019-03-28_18h22_47.png

3. Wrap the Table Excerpt include macro in the Table Transformer macro, use the default presets or custom SQL queries to merge all the tables in one.

2019-03-28_18h11_16.png

2019-03-28_18h27_21.png

The macros are available in Confluence Server and Data Center for now.

Andy Burgess May 28, 2020

@Natalie Paramonova _Stiltsoft_ When will this be available for Cloud?

Natalie Paramonova _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 28, 2020

Hi @Andy Burgess ,

We've started implementing these macros in the Cloud version recently. I suppose they will be available soon. I'll keep you updated here.

Katerina Rudkovskaya _Stiltsoft_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
August 17, 2020

Hello @Andy Burgess 

I am glad to tell you that the Table Excerpt and Table Excerpt Include macros are now available for Cloud.

You need to update the Table Filter and Charts for Confluence app, then you'll be able to use these macros.

Katerina
Stiltsoft

Dimitar_Shenkov February 8, 2022

Cloud version is not the same and cant resolve the problem !

Katerina Kovriga {Stiltsoft}
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 8, 2022

Hi @Dimitar_Shenkov ,

Please clarify what exactly you want to achieve and where you are stuck.

The Table Excerpt/Table Excerpt Include macros are rather popular among our Cloud customers.

Maybe the problem is that you want to filter/aggregate/visualize the result table coming from the Table Excerpt Include macro? The new Cloud editor doesn't allow to nest several macros directly, so please use the Table Toolbox macro that was developed especially for Cloud macro' nesting.

Like # people like this
Katerina Kovriga {Stiltsoft}
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 8, 2022

Hi there,

As this question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence. You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit modes.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

Like # people like this
1 vote
Deleted user January 7, 2019

Hi @Mos Sepia,

Using page properties and page properties report macro you will be able to merge different table from different space and pages. Hope this helps you.

Thanks,

Sravya

David March 22, 2019

Page properties report only displays the first line of the page properties table so this solution is not feasible for multi row tables.

0 votes
George Ivanov December 15, 2019

another solution would be to use SQL-Powered Table Transformer macro (available only for server instance)

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events