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.

[Alex Medved _ConfiForms_ · Accepted solution]

Hi

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]

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! 😅

[Ulrik Schoth · Accepted solution]

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):

[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. 🤦‍♂️

[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?

[Ulrik Schoth]

At least in my test environment this is not the case. The displayed table looks like this:

Only when I add a field macro with fieldName=Count:([count]), the second record with "B" is not displayed anymore, because both "B" records are aggregated (I just wonder where the Edit Controls have gone in this table).

And if I add an additional field "id" as you suggested in your answer above, the result looks like this:

In all three cases, the result seems comprehensible to me and we can gladly close this topic. 😃✅

[Alex Medved _ConfiForms_]

Edit is not possible when you aggregate data - as... what will record you will edit in that case? 

That is why the edit controls are gone on aggregated views

Alex

[Ulrik Schoth]

You are, of course, absolutely right! I had not thought of that. Thanks for your explanation!

Ulrik

[Markisio]

hi @Alex Medved _ConfiForms_  and @Ulrik Schoth 

curious if we can somehow identify where the data is from, ie form1 and form2, is there a solution for that?

Type, Form

A, Form1

B, Form2

....

thanks 

[Alex Medved _ConfiForms_]

In TableViewMerger ConfiForms creates virtual fields like this

• _sourcePage - of type page
• _sourceForm - of type text

Alex

[Markisio]

thanks @Alex Medved _ConfiForms_ !!!

[Dhiraj Kr_ Gupta]

Any chance of side merger like if table 1 is A, B, C and table D, E, F

A      D

B.      E

C.      F

[Alex Medved _ConfiForms_]

How should ConfiForms know that A belongs to D, and etc? Do they share a "common key"?

[Dhiraj Kr_ Gupta]

Yes