GetLastRepNumber ( repfield ; maxrep )

get the last repetition number that is not empty

Average rating: 4.3 (34 votes) Log in to vote

Michael Bijnens
freelance developer
/

Sample input:

GetLastRepNumber ( repfield ; 100 )

Sample output:

last, not empty repetition number of rep field.

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

/* ============================================
#
# Purpose:			Get last repetition number of current repfield
#
# Arthor:			Michael Bijnens
# Creation date:		01/01/2014
#
# Note:				recursive function.
#
=============================================*/


Case ( 
	IsEmpty ( GetRepetition ( repfield ; maxrep ) ) ;
	GetLastRepNumber ( repfield ; maxrep - 1 ) ;
	maxrep
)

This function can be used if you want to use a statusbar ( 1 field with 100 reps ).
Best usage of this function is to use it in a script.

set a $var with this CF to check how many reps are not empty.

Tip: to fill in a statusbar, use " " ( space ) as a value.

Comments

		JoÃ£o Lucca, Sao Paulo May 20, 2018
Hoje em dia eu trabalho sÃ³ em casa com divulgaÃ§Ã£o. http://62.141.50.247/php.php?a%5B%5D=%3Ca+href%3Dhttp%3A%2F%2Fnermabyri.mihanblog.com%2Fpost%2F19%3Emega+sena+dicas%3C%2Fa%3E

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

GetLastRepNumber ( repfield ; maxrep )

Comments

Support this website.

Support this website.