Concatenating field in repeating table

[Janie]

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]

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.

 

[renee rieser]

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

 

[renee rieser]

c/sum/concat/g

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

 

[_bizon]

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