Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / March 2006

Tip: Looking for answers? Try searching our database.

Concatenating field in repeating table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Janie - 20 Mar 2006 22:16 GMT
I have a repeating table.  In that table is "field1".  I would like to add
another field at the bottom of my form that will concatenate the contents of
that field if it repeats in the table.  I know how to concatenate data in
different fields, but not in a repeating field.  Any ideas?
S.Y.M. Wong-A-Ton - 21 Mar 2006 19:43 GMT
I haven't yet found an easy way to do this without custom code. So my only
recommendation would be to do it in code. You can loop through all the
field1-s of the repeating table in code and concatenate them.
---
S.Y.M. Wong-A-Ton

> I have a repeating table.  In that table is "field1".  I would like to add
> another field at the bottom of my form that will concatenate the contents of
> that field if it repeats in the table.  I know how to concatenate data in
> different fields, but not in a repeating field.  Any ideas?
renee rieser - 22 Mar 2006 00:35 GMT
Let's call the field at the bottom of the form FieldX

Rightclick on FieldX and choose Textbox properties.
In the "Default Value" box, click the Fx button, then Functions.
Choose sum.
Doubleclick on the "doubleclick here to insert field" link and find
Field1

Save and test

>I have a repeating table.  In that table is "field1".  I would like to add
>another field at the bottom of my form that will concatenate the contents of
>that field if it repeats in the table.  I know how to concatenate data in
>different fields, but not in a repeating field.  Any ideas?
renee rieser - 22 Mar 2006 00:38 GMT
c/sum/concat/g

:)

>Let's call the field at the bottom of the form FieldX
>
[quoted text clipped - 10 lines]
>>that field if it repeats in the table.  I know how to concatenate data in
>>different fields, but not in a repeating field.  Any ideas?
_bizon - 23 Mar 2006 20:20 GMT
I assume you want to identify duplicates in field1 and create in fieldX (the
one on the bottom) a long string with all the repetitions...
On field1 in the repeating table, set a rule that has as condition the
following expression: . = ../preceding-sibling::*/my:field1  and has as
action: set a field's value: fieldX = concat(../../../my:fieldX, .)
You'll have a long string with all the repeated words;
To identify the rows that triggered the rule, add in Data Validation for
field1 the following expression: . = ../preceding-sibling::*/my:field1 (the
same that triggers the rule). The rows containing the duplicates will have a
red border.
Liviu

> I have a repeating table.  In that table is "field1".  I would like to add
> another field at the bottom of my form that will concatenate the contents of
> that field if it repeats in the table.  I know how to concatenate data in
> different fields, but not in a repeating field.  Any ideas?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.