table lookup

Craig Beaubien September 23, 2020

We have Confluence Server with the following installed:

  • Adadtavist scriptrunner for confluence
  • Oomposition
  • Confluence source editor
  • Viewtracker – analytics for confluence

We use Confluence for a Wiki type system for information on our products. Most of the pages have tables and I want to have a column to indicate whether a particular product is under warranty or not based on a separate spreadsheet.  Can I do this with these products or would I need something else?

 

Thanks,

2 answers

5 votes
Sven Schatter _Lively Apps_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
September 24, 2020

Hi @Craig Beaubien,

It sounds a bit to me like this is more of a manual process for you, but do you have this data available in a database or via a REST API? If yes, you could use our app PocketQuery to dynamically pull in the data for a given product.

For example, you could create a Query called "warranty_check" which has a "product_id" parameter. You can then insert the PocketQuery macro into your pages and have it render the warranty status of your products, based on the product_id (which you can specify in each macro). Going further, you could even use PocketQuery to pull in the whole table containing your product information from an external datasource - given that it's available in a database or REST API of yours.

Cheers,
Sven

1 vote
Katerina Kovriga {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.
September 24, 2020

Hi @Craig Beaubien,

We can recommend our app - Table Filter and Charts for Confluence.

If I've got your case right, you have the following situation: there are many small tables related to the special types of products on different pages in your Wiki.

1.png

The Product name (the first column) is a unique value.

Then you have one big table with all the products listed that you use to display the warranty status.

8.png

The case is to lookup the warranty statuses with the products in your small tables automatically.

The first step is to reuse your big table with the Warranty Status column on the every page containing a small table. It is very convenient - all the changes made to the source table will be automatically reflected in the reused tables. Let's use the Table Excerpt/Table Excerpt Include macros for this purpose.

2.png

The second step is to lookup every small table with the reused big one. Let's use the Table Tranformer macro and its default Lookup preset.

 3.png4.png5.pngThe third step is to hide extra table rows that we don't need to show - we'll use the Table Filter macro for this task.

6.png7.pngNow, as you see in the macro preview, your case is fully accomplished.

Feel free to try out the app - there is one month of free usage. You'll see that the app is very flexible and allows you to nest macros in different combinations so that to filter tables, modify them, perform calculations, create pivots and different charts.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events