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 - Show more from this author
Smart Wolf
https://www.smartwolf.co.uk

Sample input:

EmptyRep ( TEST::Repeating_Field_10 )

Sample output:

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

// RECURSIVE
// Returns the number of the next empty repetition of a repeating field
// If no repetitions are empty then the result = 0

// http://www.sisosystems.co.uk
// tom@sisosystems.co.uk


Let (
[
$$EmptyRep_exit = If ( IsEmpty ( $$EmptyRep_exit ) ; GetAsNumber ( MiddleWords ( FieldType ( Get ( FileName ) ; GetFieldName ( field ) ) ; 4 ; 1 ) ) ; $$EmptyRep_exit ) ;
$$EmptyRep_recurse = $$EmptyRep_recurse + 1 ;
value = GetRepetition ( field ; $$EmptyRep_recurse ) ;

exit_result =  "Let ( [ x = 0 ; $$EmptyRep_recurse = \"\" ; $$EmptyRep_exit = \"\" ] ; x )" ;
result = "Let ( [ x = $$EmptyRep_recurse ; $$EmptyRep_recurse = \"\" ; $$EmptyRep_exit = \"\" ] ; x )"
]
; If ( $$EmptyRep_recurse  > $$EmptyRep_exit ; Evaluate ( exit_result ) ;  If ( IsEmpty ( value ) ; Evaluate ( result ) ; EmptyRep ( field ) ) )
)

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

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

EmptyRep ( field )

Comments

Support this website.

Support this website.