Controls

Re: How to calculate total Yes responses from an Infopath DDL with choices Yes, No, N/A in a survey questionnaire

Sushil — Mon, 10 Feb 2014 03:26:02 GMT

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

Re: How to calculate total Yes responses from an Infopath DDL with choices Yes, No, N/A in a survey questionnaire

Patrick Halstead — Sun, 09 Feb 2014 20:51:21 GMT

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:

count((//*[not(*)] | //@*)[not(name() = "xml:lang")][. != ''])

How to calculate total Yes responses from an Infopath DDL with choices Yes, No, N/A in a survey questionnaire

Sushil — Sat, 08 Feb 2014 03:31:59 GMT

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?