I am looking for a plug-in or any kind of solution that will help me accomplish this: I have several confluences pages. One is an overview page with a table containing details such as item name, date created, etc. The names link to another page with an embedded excel sheet which contains more specific details about that item.
I want the overview table to automatically reflect some columns from the embedded excel page. For example, when I change the date created on the excel page of an item, I want the date created under that item to say the same in the overview table.
Is there a plug-in that will help me do this? I will also take alternative solutions.
I think it is possible to do with the help of Table Filter and Charts app:
I can describe those steps in more details if you tell more about your case.
Thanks for the answer. I will look into those things you mentioned. For my case, we have a page that has a table of projects. Here is a sketch of the table that is similar to what I am working on:
Project A, Project B, etc are hyperlinks that leads to another page that contains an embedded excel that goes into more detail about that particular project. Here is a sketch of that excel sheet:
What I'm trying to do is capture some cells of this embedded excel and reflect it to one of cells from the table of projects. For example, lets assume that the excel sheet above is for project A. I want to capture Actual Start Date of Req and output it to Req Date in the first table. If I change that date on the excel sheet, I want the first table to automatically update the new information.
Ignore the discrepancy on the test and dev being empty in the excel project details and the table having dates for it. I was just trying to make a quick sketch.
Here is what I got.
Pages with Excel files:
The report page:
Inner Table Transformer:
Outer Table Transformer
SELECT 'Title' AS 'Project',
FIRST('Creator') AS 'Creator',
ARRAY(T2.'Actual Start Date')->0 AS 'Test Date',
ARRAY(T2.'Actual Start Date')->1 AS 'Dev Date',
ARRAY(T2.'Actual Start Date')->2 AS 'Req Date'
FROM T1 LEFT JOIN T2 ON T1.'Title' = T2.'Project' GROUP BY 'Title'
Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond. A long time favorite, Team Cale...
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