Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How can I set up a synergy between a table on one page and a page properties report on another page?

Gjerda November 21, 2017

Hello Atlassian Community,

I work for a company that produces large amounts of manuals, then hires a translation house to translate our original english manuals in 10-20 different languages. We're using a table on a company-specific Atlassian Confluence wiki page to track the status and estimated costs of translation projects. See screenshot 1 for an example of one of these pages that is tracking the status of Project #1 and the two manuals within the project that are to be translated into a couple different languages. You can also see I've figured out how to use the page properties macro in this screenshot. In screenshot 2 you can see the page properties summary on an overview page which is pulling the data from those project pages and forming a nice summary for readers who don't want to delve in too deep. 

Here's what I want to do:

On the summary page (screenshot 2) I want amounts of money from the project table (screenshot 1) to be totaled into the column "estimated cost." I want to be able to form this final cost amount by adding/subtracting or multiplying/dividing values from the project page. Ideally this would be a formula running in the background that readers don't have to see or mess with, and it can just spit out a final estimation of the translation cost. Can I do this? It would also be nice to do this with text values like Yes or No, or Minor or Major, so changes to a project page would immediately be reflected on the summary page. I'm a novice user and I'm not an administrator and I'm not sure if there are weird restrictions on this page's functionalities because it's some company version of Confluence. That said, I'm happy to learn and I could probably talk to my manager about getting any necessary add-ons or something. 

Advice appreciated!

Thanks,

Gjerda

 

screenshot 1:1.PNG

screenshot 2:2.PNG

1 answer

0 votes
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.
November 23, 2017

Hello Gjerda,

This is not a complete solution, but a possible simplification of your work. You can use Table Filter macro's option Total row in combination with filters to calculate total cost of a project with different options. It will look like this:

2017-11-23_12h00_29.png2017-11-23_12h00_11.png

But you'll still need to copy the total value to the Page Properties macro table.

the same you can do to calculate overall total for all projects on the summary page.

Best regards,

Andrey

Gjerda November 30, 2017

Andrey,

I don't see this "Table filter" option you're referencing, and it doesn't show up in my list of available macros. Do you know how I can get it to work?

Screenshot attached of when I search for filter; doesn't come up when I search table either:

looking for table filter.PNG

Anyway, thanks for the advice! Eventually I'd like to find something that's truly automated, but this is a good start if I can get it to work. Does Confluence really not have anything that can automate table entries? It seems like many users would want this feature but searching the community pages hasn't yielded any answers.

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.
November 30, 2017

Gjerda, forgot to tell that Table Filter is an add-on, you need to install it to your Confluence instance.

And Page Properties Report  macro is the best tool Confluence has for this purpose. Also I don't know any other add-on that can help in this case

Gjerda November 30, 2017

Okay, thanks very much!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events