InfoPath Dev

Thanks Jimmy, it worked like a charm, although for some reason now my web form is lagging a bit when a user makes a dropdown selection.

Jimmy/Scott, just a final quick question that I've come across, using this attached form as an example. For instance I will have 2 critical questions with a score of either '0' or '2', would it be possible to use that formula in the total? So basically, the user would go through and select the values from the other dropdowns ...

Thanks Jimmy, that formula works great, also thanks Scott for your help in this issue too.

The attached is basically what I'm trying to do, so basically even if a user selects a 'n/a' it still keeps calculating, so for example, if you have 3 questions and the user selects a score of 2 for 2 of the questions and a n/a for the 3rd the score total still equals 100% this will be the same if all 3 questions are n/a, ...

Speaking of getting a little tricky, its managed to get me confused in the process. So now there are 3 fields: 1) The dropdown with options (n/a, 0, 1 & 2) 2) The numberField 3) hiddenField Rules: 1) Dropdown not equal to "n/a" (set field value: numberField = number(.) + numberField) 2) hiddenField is blank (set field value: ...

Hi Scott, Thanks so much for your prompt reply and yes it did work to provide me what I needed although now it has another problem, the score in the new numberField won't refresh, it simply keeps adding onto the previous calculation if the dropdowns are changed more than once. Also on the new numberField, I've set it as a Decimal data ...

Hi, just wondering if anyone has any idea's for the following issue. I have 5 drop-down fields each with the following: n/a, 0, 1 & 2. I then have a text box calculating these drop-downs and because the text box is trying to calculate numbers, the 'n/a' is just throwing out the calculation, does anyone have an idea how I would be ...

Thanks for that Patrick, worked like a charm!

Hi, I'm wanting to create an IP form which has a data connection which will be able to display all SP child sites under a SP parent site, from this based on what site the user selects I would like to create a link to that child site. E.g. ABC (Parent Site) A1 (Child Site) A2 (Child Site) A3 (Child Site)

Hi just been trying to do some reaseach on this but can't seem to find a solution that works. 1) I've created a custom sharepoint list with custom columns, html coding & javascript (this is the top webpart and used as the 'Titles' webpart) 2) I've added a webpart to the list which is connecting to another custom list ...