Merging nonrepeating fields? Please help!

[astrujic]

Can I merge fields in nonrepeating secrions? For example if i have "number of loans" box on form (in non repeating section),... on merged form, I wanna in same "number of loans box" box show a summary value from from all merged documents

 

[Jerry Thomas [MSFT]]

One way is to put the Number of Loans in a Repeating section but then set
the section properties so that the user cannot Insert or Delete sections.

Then you can have another field or an expression box with the expression:
sum(my:NumberOfLoans).
As you merge the forms, this will total the values in the repeating node.
This can be done in a seperate view so that the repeated (merged) fields
aren't seen.

--
Jerry Thomas
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

Can I merge fields in nonrepeating secrions? For example if i have "number

of loans" box on form (in non repeating section),... on merged form, I wanna
in same "number of loans box" box show a summary value from from all merged
documents

 

[astrujic]

This will do it. Thank you

One way is to put the Number of Loans in a Repeating section but then set
the section properties so that the user cannot Insert or Delete sections.

Then you can have another field or an expression box with the expression:
sum(my:NumberOfLoans).
As you merge the forms, this will total the values in the repeating node.
This can be done in a seperate view so that the repeated (merged) fields
aren't seen.

--
Jerry Thomas
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.



of loans" box on form (in non repeating section),... on merged form, I wanna
in same "number of loans box" box show a summary value from from all merged
documents