InfoPath Dev

Hello everybody ,

I'm a dummies with infopath (also english),
on my work is infopath installed but not with the function
to create a new form.
I use one of the sample form and reform him.

I use the "absence request" form.
tis is the same wat i need to work,

I change all the name of string and recall the binding.
the calculation was no prob's ( i have experience with exell)

Only with the repeating table when i need to calculate the
sum of a different naam .

i use a drop down list box at the first column with a few name,
in a secondary column are the numbers
It's a repeating table and can insert row below or above.
if i work like tis

for sample;

dropdown..........column 2
name1 .............24
name2 .............10
name3 ..............2
name1 ..............24
name2 ..............10
name3 ...............2

i can all of this name sum and average ...

into a optional section , i need to sum the number only with the name

sample ;

name1 (is now equal to ) 48
name2 (is now equal to ) 20
name3 ( is now equal to) 4

now is my realy question ...

wat is the formule to do tis

thank you very mutch to help me
(i hope that my english understandable is)

bye bye
marcellino

Hi Marcellino,

Welcome to the forum. Are you trying to multiply the values from your drop down list and display them in your optional section? Forgive me if I didn't understand you correctly.

Hello again ,

i forgot to tell that i have looking on "help"
on the web ,i have learning with the learn program on the web ,
i have looking by microsoft "support".
i print out all the form to calculate, sum ,avg ...
but never see wat i need to make tis calculation ..

tis on 3 languish , french,dutch, english,but no find or (maybe)
not "understand" ..So like i said ..i'a dummie

thanks
marcellino

quote:

---

Originally posted by scantwell

Hi Marcellino,

Welcome to the forum. Are you trying to multiply the values from your drop down list and display them in your optional section? Forgive me if I didn't understand you correctly.

---

hi stephanie ,

thanks to welkcome me ..

i dont want to multiplie ..only sum the value on each name
into the optionnal section

i forgive you , because my english is poor

marcellino

You can look at the code in the Absence Request sample
1. Tools -> Programming ->Microsoft Script Editor
2. The updateLeaveBalance() is called to calculate the value.

Hope this helps you!

quote:

---

Originally posted by scantwell

You can look at the code in the Absence Request sample
1. Tools -> Programming ->Microsoft Script Editor
2. The updateLeaveBalance() is called to calculate the value.

Hope this helps you!

---

thanks ..

i 'm gonna loocking for ..

i let jou know the result

bye bye
marcellino

hi stephanie ,

so , i recall all the name that i needed into the script editor .. change the binding,

and .......nothing changed ..

i look again ,maybe i did somthing wrong ..

bye bye
marcellino

hi stephanie ,

i find this following text above the texteditor

""// The following line is created by Microsoft Office InfoPath to define the
// prefixes for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be autmatically updated."""

thats maybe the cause that my changing does not working

"i did wrong "

i dont give up !

bye bye
marcellino

Hi Marcellino,

Can you please post the code that are not working (or the changes you made)? I will need more information to figure out why it is not working.

Thanks.

hi everybody

i think that i not understandable was .
my english is poor..sorry

i did my calculation before with exel..
here the formule

sumif(a1:a5;"name";b1:b5)

if a 1 case or more between "a1" and "a5" are called "naam"

one case named "total" sum the column "b1 to b5 "

thats wat i try to do with infopath
in a repeating table

Marcellino

Hi Marcellino,

I got your email and I think I understand what you are trying to accomplish. However, not having enough information, I can not tell why your code is not working. Maybe you can rename your source file and resend it.

quote:

---

Originally posted by scantwell

Hi Marcellino,

I got your email and I think I understand what you are trying to accomplish. However, not having enough information, I can not tell why your code is not working. Maybe you can rename your source file and resend it.

---

Ok i do it ..

;)