Brian Dunning's FileMaker Custom Functions

FirstBlankRepetition ( RepeatingField ; StartingRepetition )

Finds the first blank repetition in a repeating field.

  Average rating: 4.1 (35 votes) Log in to vote

Brian Dunning   Brian Dunning - Show more from this author

Share on Facebook Share on Twitter

  Sample input:
FirstBlankRepetition ( MyRepeatingField ; 1 )
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Use this to find the first blank repetition in a repeating field. The first parameter ("RepeatingField") is the name of the repeating field, and the second parameter ("StartingRep") is the repetition where you want to start looking. You'll probably almost always want the second parameter ("StartingRep") to be 1, unless for some reason you want to skip the first 5, or whatever.



Jim   Jim, NY
Mar 20, 2014
Will not find a 'Blank' repitition.
Will find a 'Null' repitition.
Jim   Jim, NY
Mar 20, 2014
Also, does not work if basing your repeating field on another repeating field calculation.
Recursion will not work, as the other field has not yet finished calculation yet!

Log in to post comments.


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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: