EmptyRep ( field )
Returns the repetition number of the next empty repetition of a repeating field
Average rating: 4.8 (24 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Recursive function that returns the number of the next empty repetition of a repeating field. Input above assumes the repeating field has 10 repetitions with data in repetitions 1 to 7.
Mar 20, 2014
Way to many 'expensive' calculations for such a simple task.
This will burn up cpu time, if you have hundreds of repititions.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.