Hi All,

A little question about a repeating field.

I have field A, B (normal text fields) and C a calculation field with a repeating field of 2.

In C I want to calculate that in C (1) (the 1st of the repeating fields) comes the txt value of A and in C (2) (the 2nd of the repeating C field) comes the content of B.

How do I get this to work (if possible at all)

Anyone?

Cheers

Koen

Case(gIteratore, extend(A), extend(

Result repated field with 2 reps, and gIteartor is global repated numeric field with values 1|0 (1 in first rep and 0 in second rep.

You'll find more complex example

in this thread

Dj

djgogi,

Thanks for the quick reply.

But it's not really clear to me yet.

What i tried was :

A is a repeating text field of 2 - containing A and B

B

forgot the file

if the attachement does not work try this link : http://members.chello.nl/k.keevel/test.fp5.zip

test.fp5.zip

For all data types except containers the following will work:

text type: Set Field ["repeated field"-rep number,GetRepetition(repetedField,number]& ""]

numeric type: Set Field ["repeated field"-rep number,GetRepetition(repetedField,number]+ 0]

data type: Set Field ["repeated field"-rep number,GetRepetition(repetedField,number]& TextToDate("")]

time type: Set Field ["repeated field"-rep number,GetRepetition(repetedField,number]& TextToTime("")]

the above will be valid also inside calculations (and not only thru set field script step)

Since containers could not be manipulated (no ops on them) you need to use scripted workaroun to achieve the same thing

You'll need also and temp container global field:

Set Field [tempContainer, GetRepetition(containerReps,num]

Set Field ["repeated field"-rep number, tempContainer]

Dj

I've modified it to work.

Dj

test.fp5.zip

Thanks Dj!

This is way cool.

Cheers

Koen