Playground and DEMO space
This is a playground and demo space for ConfiForms and ConfiDoc addons developed and supported by Vertuna LLC
Most pages provide a storage format for the demo, so you can use the free add-on from Atlassian Confluence Source Editor to import this configuration into your Confluence and see it in action
To import examples from the storage format on Confluence Cloud please see this page
Please note, all the examples here are provided without any obligation and may or may not be incomplete or may have bugs, and we provide NO SUPPORT for these examples and demos.
Merging forms with different structure is very complex area, and really out of the scope of the functionality provided by ConfiForms TableViewMerger, but here is what could be done...
Data in form f1
|
text field will be used as key |
myfield1 |
|---|---|
| test | 2 |
| another | 2 |
| TEST MMM | 23 |
| 112233 | 5 |
| ewqfwef | 12 |
| 4 | 4 |
| test | 24 |
| another field | 22 |
| 333 | 1 |
| ANas | 86 |
| test | 100 |
| jjj | 2 |
| 11 | 12 |
| 555 | 1 |
| test | 200 |
| test | 1000 |
| qwerty | 11 |
| test88 | 88888888 |
| teest | 1 |
| ttt | 123 |
| pat | 001 |
| test | 100 |
| doudou | 10 |
| a | 1 |
| Test_01 | 1 |
| Test_03 | 10 |
| Modus | 1 |
| abc | 12 |
| test | 1 |
| zxxz | 1 |
| Bingo | 1 |
| Apfel | 1 |
| 123 | 2 |
| k | 1 |
| WONDER | 123 |
| psktest1 | |
| test | |
| another | |
| 1 | 1 |
| blob | 1 |
| CDO-100010 | 22 |
Data in form f2
|
text field will be used as key |
myfield2 |
|---|---|
| test | 3 |
| Test MMM | 34 |
| TEST MMM | 20 |
| 112233 | 33 |
| 4 | 4 |
| tester | 24 |
| 331 | 2 |
| ANas | 86 |
| qwerty | 22 |
| ttt | 456 |
| rick | 002 |
| test | 3000 |
| doudou | 5 |
| a | 2 |
| a | 2 |
| Test_01 | 2 |
| Modus | 2 |
| abc | 13 |
| Bingo | 1 |
| Birne | 2 |
| 123 | 4 |
| k | 2 |
| WONDER | 987 |
| test | |
| 2 | 2 |
| blob | 2 |
Merging together, text field (same name) is as the grouping key
Merged column is configured like this
Merged:(ZEROIFEMPTY("[entry.myfield2]") + ZEROIFEMPTY("[entry.myfield1]"))
|
text field will be used as key |
Merged |
|---|---|
| test | 4430 |
| another | 2 |
| TEST MMM | 43 |
| 112233 | 38 |
| ewqfwef | 12 |
| 4 | 8 |
| another field | 22 |
| 333 | 1 |
| ANas | 172 |
| jjj | 2 |
| 11 | 12 |
| 555 | 1 |
| qwerty | 33 |
| test88 | 88888888 |
| teest | 1 |
| ttt | 579 |
| pat | NA |
| doudou | 15 |
| a | 5 |
| Test_01 | 3 |
| Test_03 | 10 |
| Modus | 3 |
| 0 | |
| abc | 25 |
| zxxz | 1 |
| Bingo | 2 |
| Apfel | 1 |
| 123 | 6 |
| k | 3 |
| WONDER | 1110 |
| psktest1 | 0 |
| 1 | 1 |
| blob | 3 |
| CDO-100010 | 22 |
| Test MMM | 34 |
| tester | 24 |
| 331 | 2 |
| rick | NA |
| Birne | 2 |
| 2 | 2 |