Are they any macro to combine all table from different pages

[Mos Sepia]

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 

[Natalie Paramonova _Stiltsoft_]

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.

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

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.

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

[Andy Burgess]

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

[Natalie Paramonova _Stiltsoft_]

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_]

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]

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

[Katerina Kovriga _Stiltsoft_]

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.

[Katerina Kovriga _Stiltsoft_]

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.

[Deleted user]

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]

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

[George Ivanov]

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