Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,294,619
Community Members
 
Community Events
165
Community Groups

Are they any macro to combine all table from different pages

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

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.

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

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.

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

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

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

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 Jan 07, 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

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

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
Community showcase
Published in Confluence

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

793 views 7 21
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you