Repeating Fields

[ThomasAq]

Does anyone now how to direct data to a specific position in a repeating field that is dependent on a calculation, or another field, or date, or whatever you decide? Say you need to put data in position 24 in a repeating field and this was based on an independent decision?

[LiveOak]

The only method to designate the destination based upon a calculation is to write a script with one if statement per destination repeat and test the calculation result for each. Using only calculations, there is no way to do what you wish.

The answer here is not to use repeating fields. -bd

[DykstrL]

LiveOak is right - you won't be able to do this with just calculations.

You can do it with a script.

Set Field ("RepeatField"-24,"SourceField")

You could set this up in a loop to look for the next blank repetition, higher value, etc.. It is limited in what you can do with it though.

LiveOak is also correct - for better data manipulation - using repeating fields is not the way to go. Repeating fields is a throw back from version 2 which was not relational. They are very easy to create - as long as you don't plan to do much with the data.