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
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.
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.
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.
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 . 🙋♀️ ...
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