InfoPath Dev

Just starting to play with InfoPath, being a newbie and just joined this form.  Hope that someone can help.

I have designed an questionnaire to ask people what they know about IT.  I am using radio buttons which are Yes No example below.

Can you use a mouse?  Yes  No (with radio button next to each)

My problem is there are about 50 questions and I want to be able to total how may Yes and how many No buttons have been selected in each section.  I then want an overall total displaying how many Yes/Nos have been checked, depending on what score the user gets will determin what level of IT course they need to undertake.  Ideally using conditional formatting to display a message like, "You have scored less than 40 and therefore will need to attend training".

This is a form I have made on the fly and I will be using the Publish to Outlook function to circulate it to hundreds of staff.

Am I doing this right and how would I do the calculation.

Thanks

Shirl

Hi,

Can you please verify the following links:

http://www.infopathdev.com/forums/p/675/2690.aspx#2690
http://www.bizsupportonline.net/infopath2003/avg-function-infopath.htm

Hi,

How is your schema designed for questions and radio buttons?

Not sure what you mean being a newbie, is there any way I can post a copy of form which might explain things?

Shirl

Hi,

Place the cursor on one field. You will see one Window with name (Design Tasks) right side of your form. In that click on 'Data Source'. In that you will see some thing like 'myFields -> Group1 -> Group2(Repeating)-> etc'.

What is that pattern in your form?

 In the myFields I have the question names which are bound to the Yes No radio buttons, there are about 40 questions relating to IT, the other fields are about the member of staff.  At the end of the list are two empty folders named group1 and group2

myFields 
 CreateFoldersInYourNetworkArea
 ReNameAFileOrFoder
 SaveFilesToAMemoryStickOrCDDVD
 FirstName
 LastName
 Status
 Campus
 Job_Title
 Deparment
 group1
 group2

Hi,

Field4 -> No. of ‘no’ Radio buttons

MatchPath = "/my:myFields/my:Field1 | /my: myFields/my:Field2"

Thanks for doing all this but I really do not have a clue what the above means?

Shirl

Hi --

This can be done without code. First, make sure that you look at the values for each of the option buttons you've added to be sure that when they are totalled up, you'll have the scoring you want. For example, you may want to make all 'no' values 0 and give 'yes' values a non-zero amount (some skills are worth '1', some worth '2', etc.). Then, add a field to your data source for Score. You don't have to show it on the form if you don't want to.

Set the default value of Score -- use a formula. You'll want to use the Sum function if you have any repeating fields, but from the sounds of things, you'll just be able to insert each field and use '+' to add them together. Then, you have sections with the information like "Your score is too low, we are taking your mouse away" that show or hide based on the Score field. Does that make sense? Let me know if you need more info....

Thanks that sounds the sort of thing I want to do, I have just had a go and got this error message

Argument 1 must return a node-set.

-->sum(my:CreateFoldersInYourNetworkArea + my:ReNameAFileOrFolder + my:SaveFilesToAMemoryStickOrCDDVD + my:CopyFilesOrFoldersToAnotherLocation + my:CreateZipFiles + my:SearchForFilesOnYourNetwork)<--

I have pasted in a copy of how my form looks.  Each of the Yes No boxes is bound to the question

I don't think you need Sum, since I don't believe anything is repeating. Try removing Sum and the parenthesis and just leaving the fields and the plus signs.

Thanks, yes it works I expect I will have more posting as I play with Infopath - really useful forum.

Regards

Shirley

Fantastic! Feel free to post away, we've all been new to InfoPath at one time or another...

Cheers,