Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Can I set reference between tables in Confluence?

Nishant Tekhre
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 24, 2013

I have multiple teams and they feed their data in their team page's table. I wish to have a summary table in which I can fetch required data from multiple other tables. The way you do it in excel by putting an "=" in the cell and giving reference to the other cell.

Is this possible in Confluence?

5 answers

1 accepted

0 votes
Answer accepted
Stefan Eike
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 24, 2013

Yes. You need a few bucks to buy CustomWare Scaffolding and CustomWare Reporting.

Nishant Tekhre
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 28, 2013

Thanks for the answer Stefan!

Is there no other option than buying the plugin? My requirement is just getting data from different tables into one. The tool offers many other functionalities that I will never really use.

Are there any default macors that I can use?

Thanks again for the help!

1 vote
Andrey Khaneev _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 22, 2020

Hi Nishant,

You can do it with the help of Table Filter and Charts for Confluence.
The Table Excerpt (Include), Table Transformer macros are appropriate for your use case.

Here's an example of how to use them:

First, you need to wrap all required teams' tables with the Table Excerpt macro.
image.png 2.png



Then add the Table Excerpt Include macro on a separate page with a summary table and configure it.

3.png 4.png

Now wrap this Table Excerpt Include macro with Table Transformer and enter the following SQL query:

SELECT 'Project ID:','Project Status:' FROM T*
5.png 6.png

Finally, you need to wrap it all with one more Table Transformer and choose the 'Lookup tables' preset.
7.png 8.png

Result:
9.png


Please use our documentation to get more info about our app.

0 votes
Katerina Rudkovskaya _Stiltsoft_
Atlassian Partner
May 22, 2020

Hi Nishant,

You can do it with the help of Table Filter and Charts for Confluence.
The Table Excerpt (Include), Table Transformer macros are appropriate for your use case.

Here's an example on how to use them:

First, you need to wrap all required teams' tables with the Table Excerpt macro.

Screenshot_1.png Screenshot_2.png

Then add the Table Excerpt Include macro on a separate page with a summary table and configure it.

Screenshot_3.png Screenshot_4.png

Now wrap this Table Excerpt Include macro with Table Transformer and enter the following SQL query:

SELECT 'Project ID:','Project Status:' FROM T*

Screenshot_5.png Screenshot_6.png

Finally, you need to wrap it all with one more Table Transformer and choose the 'Lookup tables' preset.

Screenshot_7.png Screenshot_8.png

Result:

Screenshot_9.png

Please use our documentation to get more info about our app.

Katerina
StiltSoft

0 votes
Katerina Rudkovskaya _Stiltsoft_
Atlassian Partner
May 22, 2020 edited

Hi Nishant,

You can do it with the help of Table Filter and Charts for Confluence.
The Table Excerpt (Include), Table Transformer macros are appropriate for your use case.

Here's an example on how to use them:

First, you need to wrap all required teams' tables with the Table Excerpt macro.

Screenshot_1.png Screenshot_2.png


Then add the Table Excerpt Include macro on a separate page with a summary table and configure it.

Screenshot_3.png Screenshot_4.png

Now wrap this Table Excerpt Include macro with Table Transformer and enter the following SQL query:

SELECT 'Project ID:','Project Status:' FROM T*

Screenshot_5.png Screenshot_6.png

Finally, you need to wrap it all with one more Table Transformer and choose the 'Lookup tables' preset.

Screenshot_7.png Screenshot_8.png

Result:

Screenshot_9.png

Please use our documentation to get more info about our app.

Katerina
StiltSoft

0 votes
CelesteCS
Contributor
June 3, 2016

Hello, Nishant!

For any calculations in Confluence, including referencing table data, you may use CelesteCS Math for Confluence. For referencing the cell on the table on another page, specify the page name in macro parameters and reference table cell like here:

Table1.A1

There is a plenty of other functions in the macro, so you may perform any calculations using formulas in EXCEL style.

Thanks!

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, atlassian community events, ace, engineering, confluence feed, power of feed, atlassian ask me anything, atlassian confluence answers, ace rsvp, atlassian community events rsvp, atlassian magic

“How We Built This” ft. Atlassian Confluence Engineers

Meet the engineers who are making the Confluence magic happen at Atlassian ✨

RSVP now!
AUG Leaders

Upcoming Confluence Events