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; } } }

Can I dynamically populate the fields of a table, based on values introduced on another table?

Marina Culeasca_asco6g

Hi,

Lets say I have two separate tables in which I keep different information regarding same items (Jira tickets) - table 1 with info about the team, start/end date, etc, and table 2 with issues encounter working with/on that ticket.

1. Can I dynamically populate some fields from table 2, with info from table 1, based on values introduced on a certain column in table 1?

I mean, if in table 1 I have a column in which I introduce YES/NO based on if I had issues or not when working with that ticket, and if the answer is YES, to dynamically populate Ticket NO from table 2, with the number of the ticket introduced in table 1

Thanks!

Accepted answers

Katerina Kovriga {Stiltsoft}

Hi @Marina Culeasca ,

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

Wrap your Table 1 in the Table Excerpt macro:

Issues 1.png Issues 3.png Then reuse your Table 1 with the help of the Table Excerpt Include macro and wrap it and your Table 2 first in the Table Transformer and then in the Table Filter macro.

Issues 2.png Use the Table Transformer macro to look up your tables by the unique 'Key' field:

Issues 4.png And set the Table Filter macro to show only rows with the 'YES' issue encounter:

Issues 5.png Issues 6.png Now your result Table 2 will look as required when the page is published:

Issues 7.png Note that if your Confluence hosting type is Cloud, you'll need the Table Toolbox macro to nest several macros due to the new editor limitations.

All comments

Katerina Kovriga {Stiltsoft}

Hi @Marina Culeasca ,

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

Wrap your Table 1 in the Table Excerpt macro:

Issues 1.png Issues 3.png Then reuse your Table 1 with the help of the Table Excerpt Include macro and wrap it and your Table 2 first in the Table Transformer and then in the Table Filter macro.

Issues 2.png Use the Table Transformer macro to look up your tables by the unique 'Key' field:

Issues 4.png And set the Table Filter macro to show only rows with the 'YES' issue encounter:

Issues 5.png Issues 6.png Now your result Table 2 will look as required when the page is published:

Issues 7.png Note that if your Confluence hosting type is Cloud, you'll need the Table Toolbox macro to nest several macros due to the new editor limitations.

Daisy Fischlein Steffensen

@Katerina Kovriga _Stiltsoft_ I am looking to do the same thing.. I think. Only I would like to make a table consisting of data from JIRA and one column that will be filled out manually.

I can't figure out from the example above how to do to that? The example above seems to be all manually entered data?

Can you help me?

Katerina Kovriga {Stiltsoft}

Hi @Daisy Fischlein Steffensen ,

The basic conception is the same: you insert the Table Transformer macro and wrap two tables inside its body - the Jira Issues table and an additional manually created table for your comments.

Wed 1-1.png To lookup the tables, you'll need a unique field. As we don't use any custom fields, I choose the standard 'Key' field to serve this purpose.

Now go to the Table Transformer macro settings and enter the following custom SQL query:

SELECT T1.'Key', T1.'Summary', T1.'Created', T1.'Assignee', T1.'Status', T2.'Manually Added Comment' FROM T1 JOIN T2 ON T1.'Key' = T2.'Key'

As you can see, the query is very simple: you define the columns (and their order as well!) that you want to show in the result table and lookup the two tables by the 'Key' column.

Wed 1-2.png And here is the result when the page is published:

Wed 1-3.png Hope this helps.

Daisy Fischlein Steffensen

Thanks I made it work.. only some of my colleagues has their default browser language set to "Danish".

That means that the JIRA column "Key" is translated to "Nøgle".. this ruins the mapping between the two tables.

It looks correct for me, because my browser language is English.

Do you have any suggestions on how to handle that, so everyone viewing the table will see the table correctly?

sridhar vaidyanathan

Hello,
I followed the instructions on getting an additional column added to JIRA. However, the JIRA issue/filter macro doesn't render cleanly when I am in edit mode. This makes is harder to create a duplicate table with the relevant keys, while I am in edit mode. How do I overcome this?

Screenshot 2023-09-19 143315.png

Stiltsoft support

Hi @sridhar vaidyanathan ,

Unfortunately, this is the way the Jira Issues macro works.

sridhar vaidyanathan

Thanks. I am curious how to get the view that @Katerina Kovriga _Stiltsoft_ response shows:

Wed 1-1.png

Stiltsoft support

The screenshot was taken for Confluence Cloud, that's all - there are no any special settings for the macro.

For Data Center/Server the macro is always shown as on your screenshot:

Tue 3-1.png

Shivani Gour_0q80v7

@Katerina Kovriga _Stiltsoft_

How to merge a Jira snapshot and a manual table together in Confluence page?

Stiltsoft support

Hi @Shivani Gour ,

As far as we understand, you are referring to another 3rd party app that creates snapshots from Jira. Maybe you should apply to their support.

Shivani Gour_0q80v7

Hi I am talking about below element on Confluence and I want to merge a manual table with this

iScreen Shoter - 20240227230551832.png iScreen Shoter - Google Chrome - 240227230526.png

Stiltsoft support

So, visit the link given in the reply above and refer to their support.

Welcome!

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

Quick Links

Find more posts tagged with

confluence

filter

atl-gruland

ms-excel

table

table-filter

table-filter-and-charts

table-spreadsheet

table-filter-charts-spreadsheets