nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to link tables from one page to another page for training traceability

Naveen Basar

Would like to trace the training progression/status for all individuals from their respective pages (employee's pages), which contains table of training programs and I would like to track status of each training program for each employee into single table in a single page (will treat this page as all-employee training traceability). The time when an employee recieves new training program in his/her training page/table, traceability page should automatically get updated with this new program as well as status of this program. Note that employee training page contains table with column headings: Training Name and Status (done or in progress). Your help is highly appreciated.

Accepted answers

Katerina Kovriga {Stiltsoft}

Hi @Naveen Basar ,

If your employees create and update one-row tables on their local pages, you may collect the combined table using the standard Page Properties/Page Properties Report macros (these macros are native Confluence macros).

If you need to collect multiple-row tables across your Confluence instance, we can suggest using our app - Table Filter and Charts for Confluence.

Our Table Excerpt/Table Excerpt Include macros will do the trick and other macros (such as Table Filter, Pivot Table and Chart from Table) will further help you to filter, aggregate and visualize your data.

All comments

Magdalena Zhisheva

Hi @Naveen Basar

I think you may try the following:

Create a search filter, including all respective projects and issue types and statuses you need.
Save the filter
Create a board in your project, where you want the new board to be and go to -> Board settings
In General -> Filter select the new created filter
Then go to swimlanes and there you may create a different swimlane for each employee with JQL (ex. Project = "X"
Go back to the board and see if it's what you need.

Hope this will be helpful for you!

BR,

Magdalena Zhisheva

Katerina Kovriga {Stiltsoft}

Hi @Naveen Basar ,

If you need to collect multiple-row tables across your Confluence instance, we can suggest using our app - Table Filter and Charts for Confluence.

Naveen Basar

Hi @Katerina Kovriga _Stiltsoft_ I tried page properties and Page properties report and also tried Tabe excerpt/Table excerpt include, but it is bringing what was there in employee's page (same table information), and it was the same table in 'traceability' page with employee name on the top of the table. If I follow the same procedure, i will get all the tables from each employee's page into Traceability page. However, one useful thing observed is the tables in the traceability page gets autoupdated if I add anything extra in the employee's page. I am afraid what if I have 200 employees and I need to track their training progression in a single page from their individual pages? I will give you the scenario, your help will be highly appreciated: Each employee of our company should undergo training activities, lets say, initially there will be 10 programs when they join, each employee should complete all the training activities within one month and report the status to manager, manager will approve their training status, and manager should maintain training traceability for all the employees in a single sheet (consolidated) and also he should add status for all the newly added training programs from employee sheets. I would like this to be automated. Please provide your suggestions.

Thanks

Naveen

Katerina Kovriga {Stiltsoft}

Maybe I didn't get your case, so let me rephrase it once more:

Every employee has several training programs
He/she creates a new page for every program with a standard one-row table at the top of the page: Employee / Training name / Status
Each table is wrapped into the Page Properties macro
Your manager has his/her own page with the Page Properties Report macro and sees the big multiple-row table for all the employees (with the same columns: Page Title / Employee / Training name / Status)
To filter this big table and search for the specific employee and training program, use the Table Filter macro
If the employee updates his/her table (status, I mean) the big table for the manager will be updated automatically as well
If the manager wants to update the status him(her)self, he/she clicks the page title links of the Page Properties Report, goes to the employee's page and updates the original mini-table
If this step is too time consuming, you may use our Handy Macros app and its Handy Status macro and change the statuses directly from the Page Properties Report macro (such changes will be passed to the original mini-table as well)

So, that is all I could come up at the moment.

Naveen Basar

Thanks for your time in replying. Point#4 was not the case in my case with table excerpt include, it is creating individual tables with employee name, like if i have 4 employees, i will get 4 tables in traceability page along with training programs and status (with employee name on the top of each table). With page properties, I will get all employee names in a single table, but I will get only first row of their table, which indicates first training program and status, rest all cannot be seen in my traceability sheet tables.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

filter

atl-gruland

table

table-filter

table-excerpt

table-filter-and-charts

table-filter-charts-spreadsheets