InfoPath Dev

Hi folks,

I am quite a newbie to InfoPath 2010 designer. I have been asked to generate a questionnaire form and have it published in SharePoint. The form has several sections and each section having several questions with only responses Yes, No, N/A. Later, I have to get total Yes count for each section. I have entered a rule for each textfield QF (question field) to check for Yes and if the condition is met update the SectionTotalField=SectionTotalField+1. Is there a better way to achieve the result?

Hi Sushil,

Yes, you should use a repeating group node with a question field underneath it and a default value on a totals field (above the repeating group) that calculates the total number of questions answered. You can use the count function that is built into InfoPath with a condition check inside to see if an answer was set.

To use a repeating group, you will have to add multiple rows and question values to the default values dialog.

Here's an example xpath that calculates count for all fields in your form:

 Thanks a lot Patrick. I'll definitely give it a try. I would like to know significance of repeating group node in this. Would the schema be:

myfields:

   - Group

       -TotalSectionField

            -Repeating Group

                -group1 

                 -Questionfield1 

                 -Questionfield2