Newest functions Upload a function Leave a tip My account

There are 2,521 functions in this library.

FirstBlankRepetition ( RepeatingField ; StartingRepetition )

Finds the first blank repetition in a repeating field.

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

Brian Dunning - Show more from this author BrianDunning.com https://www.briandunning.com

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

If ( IsEmpty ( GetRepetition ( RepeatingField ; StartingRepetition ) ) ; StartingRepetition ; Let ( StartingRepetition = StartingRepetition + 1 ; FirstBlankRepetition ( RepeatingField ; StartingRepetition ) ) ) Click to copy

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, NY Mar 20, 2014
Will not find a 'Blank' repitition. Will find a 'Null' repitition.

		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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 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: