I would like to display the contents of two ConfiForms tables with the same structure in a combined view. Example * Both tables have just one field named "Type". * Table 1 has 3 records of "A", "B", "C". * Table 2 has 2 records of "D", "E". * The target table shall display all 5 records in one table and with one column heading named "Type". Although this seems to be a very simple question, I have not been able to achieve this. I'd greatly appreciate if anybody can show me a solution. Thanks.

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 combine two ConfiForms tables of same structure in one view

Ulrik Schoth

I would like to display the contents of two ConfiForms tables with the same structure in a combined view.

Example

Both tables have just one field named "Type".
Table 1 has 3 records of "A", "B", "C".
Table 2 has 2 records of "D", "E".
The target table shall display all 5 records in one table and with one column heading named "Type".

Although this seems to be a very simple question, I have not been able to achieve this. I'd greatly appreciate if anybody can show me a solution. Thanks.

Accepted answers

Ulrik Schoth

Here's what I did: I wrapped two TableView macros with the TableView Merger macro. This would be intuitive in my opinion. Unfortunately, the result was not as expected.

I have tried some of the settings in the TableView Merger macro, but without success.

And just to clarify what I expected (unfortunately only obtained by editing the above image):

Alex Medved _ConfiForms_

It is indeed a quite simple task in our opinion... And the TableViewMerger is the macro to use

However, you need to be careful with ConfiForms Field macros that you have as these are used as "grouping keys"

So, you want to merge the data from different forms and in this case it would be greate to add a field that has a unique value, and that is an "id" field

Add a ConfiForms Field with field name set to id

And mark it to be used as "key"

Alex

All comments

Ulrik Schoth

Here's what I did: I wrapped two TableView macros with the TableView Merger macro. This would be intuitive in my opinion. Unfortunately, the result was not as expected.

I have tried some of the settings in the TableView Merger macro, but without success.

And just to clarify what I expected (unfortunately only obtained by editing the above image):

Alex Medved _ConfiForms_

It is indeed a quite simple task in our opinion... And the TableViewMerger is the macro to use

However, you need to be careful with ConfiForms Field macros that you have as these are used as "grouping keys"

So, you want to merge the data from different forms and in this case it would be greate to add a field that has a unique value, and that is an "id" field

Add a ConfiForms Field with field name set to id

And mark it to be used as "key"

Alex

Ulrik Schoth

A colleague showed me what was wrong in my code: I just had to empty the body of the TableView macros and put the Field and Edit Controls macros directly into the body of the Table Merger macro.

So, instead of using this code:

I just have to use the code below and everything works as expected:

Since I have always used the TableView macro in the past with field and edit control macros in its body, I would never have thought of this! I was not even aware that you could use the TableView macro with an empty body. 🤦‍♂️

Ulrik Schoth

Hi @Alex Medved _ConfiForms_

Thanks a lot for this tip! I will use it in my merged tables in the future.

In the meantime, we found the cause of my problem (see my related comment). And now that I know how to use the Table Merger macro properly, I would say: you are right, it is indeed quite a simple and intuitive task! 😅

Alex Medved _ConfiForms_

Yes, but this way it will aggregate by "type" field - meaning that a record with the same value in the "type" field will be "skipped", counted, but skipped

You will see only the unique results by "type"

Ulrik Schoth

Hi @Alex Medved _ConfiForms_

do you mean that if the table values are as follows

this solution

should result in a table like so

because the second record with "B" will be skipped?

Welcome!

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

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

confluence

server

confluence-server

confiforms