Brian Dunning's FileMaker Custom Functions

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

Tom Guise   Tom Guise
Siso Systems
http://www.sisosystems.co.uk

Share on Facebook Share on Twitter

  Sample input:
EmptyRep ( TEST::Repeating_Field_10 )
  Sample output:
8

  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.

 

Comments

Jim   Jim, NY
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.
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.