Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

table lookup

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

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

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
Community showcase
Published in New to Confluence

Fast-track your Confluence onboarding with the Confluence product guides!

Hey there! New in town? Check out the new Confluence product guides! They are chock-full of helpful tips, tricks, and best practices to get you and your team started.  Here’s a quick overview...

1,096 views 3 9
Read article

Community Events

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

Events near you