InfoPath Dev

I am using Infopath 2007

thank you!

 Vicki

Hi Vicki,

The best way to do this is to have the data for each of those questions be in a repeating field.  Then you could use the functions in InfoPath such as min(), max(), sum(), etc. to do your calculations.

If you're constrained to your current data source/schema, you'll need lots of rules and maybe a few temp variables to accomplish what you want.  I would recommend the repeating approach since that will make things neater for you.

Thank you Anson.  Being a newbie, I think I need to review how to do repeating fields.  Do you have a link that would show me how to do this in my situation?  thank you again!!

Sure!  Here is an article describing how to sum a column in a repeating table: http://office.microsoft.com/en-us/infopath-help/sum-a-column-of-numbers-in-a-repeating-table-HP010081939.aspx

You'll want to use the min() function in your case.

 I would like to ask for some further help.

I looked at the instructions you sent me and also search the internet for more info on adding a repeating table.  When adding a repeating table it only gives me one row and as many columns as I need.  I'm pasting in this message below what I orginally came up with and I would like to know how to create this with a repeating table.  Its seems from what I've read in the link you gave me that the end user would add more rows but I want to set up the form with the rows already there as each row has a row header.  The last field which you can't see (6th column) is populated if the  Error check box is checked in any row, the number in the 5 column is just a placeholder for the user to know what that error would be worth.  I hope I'm explaining myself and my confusion. Thank you once again!

 Please see below:

Sounds like repeating tables aren't the way to go for your solution :)  You can still do what you want with rules, but will require a more leg work on your part.

Count of non-blank fields

• You could do this one of two ways:
• Create a variable for the count and set default value to 0.  Then for each of the option fields, create a rule that says if value changed then set a field's value count = count + 1 OR
• For each of your Error fields, if you had these all set to 1 you could simply add up all these fields to get your count.

Lowest number

• This one is a little trickier.  One method I thought of is to create a temp string variable.  Then concat all of the values into this one variable each time one of the option value changes.  Then you can do create rules to try and find '1'.  If that fails then find '2', and so forth.  There's probably a better way of doing this, but this is the best I came up with right now :)

Please take my suggestions lightly since I didn't actually try any of these out in practice.  They just work based on what I'm thinking in my head :)  But hopefully it will get you started and on the right track.  Good luck!