Atlassian Confluence

Table Filter and Charts with dynamic Scaffolding tables

We continue our series of video tutorials that will show you the full scope of features and options that Atlassian Confluence provides to its users. Last time we demonstrated you the way to work with Page Properties Report macro, summarize the outputted data and visualize the received data series with dynamically updated charts.

This time we will show you the method to create dynamic tables with Scaffolding’s Table Data macro and further analyze this data in Confluence.

Scaffolding Add-on

Scaffolding add-on provides a set of macros that allow you to build dynamic tables on Confluence pages. We have build the table for tracking orders of swag items for different locations of the organization.

scaffolding_dynamic_table_in_confluence

The table for orders is comprised of the following columns:

  • Office # – location that makes an order of swag. Here the list of pre-defined locations is used.
  • Employee – person who orders items, usually, this is a manager. Here we used the user-options macro with autocompletion of users’ names from Confluence.
  • Product – specific swag product that is needed in the location. the list of pre-defined swag products is used.
  • Quantity – number of swag items for ordering. Text fields for entry of the number of items for ordering.
  • Priority – priority of the order (low, moderate and high indicated with emoticons).
  • Status – status of the order for the location. It can take four statuses – Opened, In Progress, Rejected and Completed.
  • Deadline – date which the order is desired to be completed. The person who makes an order sets the desired deadline depending on the available number of swag items in the location.
  • Notes – text field for leaving comments for the order.

After saving the page, employees can proceed to placing their orders in the Edit Contents mode that Scaffolding add-on provides.

scaffolding_dynamic_table_edit_contents_mode

In the opened pop-up form, each user can enter the required order details and save it.

After saving the dynamic table with orders, it’s rendered as a normal table for viewing in Confluence. But having quite enough orders within each quarter it becomes quite difficult to sum up all the data in the table to get the total number of swag items for ordering.

confluence_scaffolding_dynamic_table

As a possible solution, this table can be copied to Excel, but it becomes a real problem when someone adds a new order, so the order can fall behind the schedule, which is not acceptable.

Table Filter and Charts add-on can become a real alternative to MS Excel. With all the available tools, it allows you to filter all kinds of data typessummarize data series or aggregate the whole table against the specific parameter, and further visualize this data with the dynamically updated charts. The cross-compatibility between the macros, makes this add-on a real catch for people dealing with table data.

So, watch the video to see all the actions that you can perform on your Scaffolding table with Table Filter and Charts add-on in Confluence.

If you have any questions, feature requests or problems with add-on configuration, drop an email to vrutkevich@stiltsoft.com and I will contact you.

Recommended Articles