Creating a summary table from a Form made out of tables

[Deleted user]

Hi everyone! I need some help creating a summary page. I have a form that is filled up for every incident, and so there will be 20-30 forms created, and I want it to be summarized into something like a register which would look like:

1. DocumentID1 | Statement | Status
2. DocumentID2 | Statement | Status
3. DocumentID3 | Statement | Status

I've looked around but I don't really see anything for what I want. The form is formatted using tables and it looks something like below. This is just Section A, and there are multiple sections, all formatted differently with a different number of cells per row, as you can imagine a Form would look. I've tried Excerpts but it does not work since it can't be within a cell, and the excerpt window will sit right at the bottom of the whole table, is there any other way to extract data from fixed cells to place it in another page?

Description
Status	I want to be in the summary
Document ID	2022-0001
Statement	I want to be in the summary
Findings
Category

[Katerina Kovriga _Stiltsoft_]

Hi @[deleted] ,

If we talk about standard Confluence tools to collect tables with statuses and descriptions, you may try Page Properties/Page Properties Report macros. The only disadvantage is that they collect one-row tables.

To collect multiple-row tables, you may try our Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros.

But for these options it's better to organize your forms as plain tables with similar headers and without any breaks to form sections (let them have more columns instead). Or you may collect different sections separately.

You may also look here for an example.

[Deleted user]

Thanks Katerina, I'll give it a look, I've seen your recommendation and wasn't sure if that would have helped initially.

[Jason Boyle]

Hi @Katerina Kovriga _Stiltsoft_ 

Is there an alternative to Table Excerpt / Table Excerpt Include to bring data rows from say one table in Confluence to another table on another page?

[Katerina Kovriga _Stiltsoft_]

You may look into the standard Excerpt/Excerpt Include macros. There won't be such flexibility as 3rd party apps provide, but you'll be able to reuse your source table on other pages.

[Jason Boyle]

Thank you @Katerina Kovriga _Stiltsoft_ for the answer, makes me ask another - if I can get a table to display on a different page for a given Source page, is there a way to bubble this up so that the source changes from a given page to many pages that may have a given label?

[Katerina Kovriga _Stiltsoft_]

The changes are pushed only through Excepts to Excerpt Include macros.

I mean that you have one real source table wrapped in the Excerpt macro and all the changes are made to this table. The Excerpt Include macros allow you to reuse this table as many times as you need. But they are not real physical tables, they are not copies. So you can't make any changes to them.