Confiforms: Combining tables with TableView Merger

[Christian Perry]

Hi, 

Apologies if this is answered somewhere else but I can't seem to find any documentation

I am tracking the scores of students across multiple semesters using individual confiforms forms on different pages. 

I would like to display a table that has the student's name and what their grade was in each semester. The field names themself do not change but the student names sometimes change between semesters (ie a student leaves or joins the class) I want to still display data even if the name changes (ie I want to show studentA grade in Q1 even if they leave in Q2 OR I want to show a blank grade for studentB in Q1 if they joined in Q2)

Is this possible?

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Christian Perry 

What is the problem with using the TableViewMerger macro?

Make it group by student and that's it... :)

Alex

[Christian Perry]

Hi @Alex Medved _ConfiForms_ 

I can't find any documentation talking about the setup. The end goal is to have the table with multiple quarters worth of scores and then have another field to track deltas. 

[Christian Perry]

The main problem I have is that all of my forms are on different pages. I dont see a clear way to reference them 

[Alex Medved _ConfiForms_]

There are 2 options

• Specifying TableViews as sources for the TableViewMerger
• Use dynamically discovered sources - for example having a specific label on these pages and then providing a CQL to search by that label the sources for the TableViewMerger

[Alex Medved _ConfiForms_]

Hi

Little video to illustrate the approach with using the dynamic sources in the TableViewMerger

Hope it helps

Alex

[Christian Perry]

Hi @Alex Medved _ConfiForms_ Thank you so much for the video. The labels are what I was missing. So sorry if I missed the documentation somewhere but this is exactly what I needed. 

Thanks again!

[Valerie Knapp]

Hi @Christian Perry , thanks for your post. 

I would imagine you've already checked but if not, please check out the product documentation here https://wiki.vertuna.com/spaces/CONFIFORMS/pages/1212428/Documentation , which has some implementations they've done.

If that doesn't help, you can always open a ticket to the vendor to ask for help - https://marketplace.atlassian.com/apps/1211860/confiforms-data-forms-workflows-for-confluence?hosting=datacenter&tab=support 

Hope this helps you. 

Best wishes