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?