How to create a summary table?

[kb at donovanhill]

Hi,

I have a simple InfoPath 2007 form designed for recording meeting notes. One
repeating table records attendees, another repeating section records the
minutes and has an 'action by' drop-down list box linked to the attendees. I
would like to create a summary table that shows the attendees name and all
minute items that he/she needs to action. In other words all the minute items
that need to be actioned are grouped together for each attendee.

Any ideas on how to get this to work?

Thanks

 

[Clay Fox]

Hey KB.

I have a very similar form.

If this is all in one repeating group then I would think you would just use
conditional formatting to hide everything but the action item values you
wanted to see.

You can have multiple repeating tables on the same view or different ones.

 

[kb at donovanhill]

Hi Clay,

Thanks again for your answer, this solved the problem, although some agenda
items require 'action' from 2 or more people, InfoPath seems to only find the
first entry in a repeating section, so I think I will need to use code to
loop through the entries. I was hoping to have a 'code free' solution with
this one! Maybe next time.

Regards

 

[Clay Fox]

You should be able to setup your query for multiple cases.
It sounds like you are maybe setting some information which then you either
need a filter or possibly the current() function to get the correct row
rather then the first record.

I think you can probably do it without code.