Inserting into Repeating Fields

[laker_42]

I have a repeating field that has 17 repetitions. I want to enter numbers from 1 to 17 in those repetitions. Is there any easy way to do this without having to manually enter the numbers? I would like to write a script that would do this for 33 records. Any help would be appreciated.

Thanks,

John

[andygaunt]

Well,

you could do this by simply finding your records and entering a number into the repetition and choose records replace.

Repeat 17 times for each number.

Or you can script it. You will need a global field [number format] as well (called _gNumber).

Create a layout with just your repeating field on.

The your script

Freeze Window

Go to record/request/page [first]

Set Field ["_gNumber", "0"]

Go to field [your repeating field, repetition 1]

Loop

Set Field ["_gNumber", _gNumber +1]

Set Field ["_gNumber"]

## Note the set field above has no field specified, just the calculation]

Go To Next Field

If ["Status(CurrentRepetitionNumber) = 1"]

Go to record/request/page [Exit After Last, Next]

Set Field ["_gNumber","0"]

End If

End Loop

Make sure you find only those records you want to add the numbers to, otherwise you will change all records.

HTH

[laker_42]

Thanks for the script. I knew there had to be a way to do it. I will give it a try.

Thanks,

John