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 |
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, 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! |
||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.