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
BrianDunning.com
https://www.briandunning.com

Share on Facebook Share on Twitter

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

  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.

 

Comments

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 BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.