Is it possible to create a script to populate all repitions of a repeating field? I am creating a bid sheet for an auction and need to create bid value increments based on a Value field. Example 30 is value. Rep 1=30, Rep 2=(Rep1+10), Rep 3 = (Rep2+10), etc.

Thanks

Novine in NC

Version: v6.x

Platform: Mac OS X Panther

Define fields called BidValueBase and BidIncrement so you have more flexibility.

First script step: Set Field [""BidValueBase", "BidAmount"]

For each repeat n, where n > 1, define a script step:

Set Field ["BidValueBase"-n, "GetRepetition(BidValueBase, n-1) + BidIncrement"]

When you define Specify the field for Set Field, change the Repetition: box at the bottom appropriately.

Is this what you wanted?

There is a way to do this using calculations. Keep the two fields BidValueBase and BidIncrement. Define a new global number field named g.Index with the 3 of reps you'll need. Enter integer values in this field from 0 to (# repetitions -1).

Create a number calculation field named BidValue with the same # of repetitions. The calculation is:

Extend(BidValueBase) + (g.Index * Extend(BidIncrement))

Now BidValue will automatically start at BidValueBase and increment with BidIncrement

Is this understandable?

"with the 3 of reps" should be "with the # of reps"