LastNonEmptyRepNum ( RepField )

Returns the last repetition number that is not empty. (For FM version 18 and later)

Be the first to rate this function Log in to vote

Shoichi Miyamura - Show more from this author
Office Miyamura

Sample input:

LastNonEmptyRepNum ( RepeatingRield )

Sample output:

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

/*
  Returns the last repetition number that is not empty.

  Author : Shoichi Miyamura 
  Creation Date : August 31, 2021 
*/

While ( 

  [ 
    @Max = Count ( RepField ) ; 
    @Inc = 0 ; 
    @Num = 0 
  ] ; 

  GetAsNumber ( @Num ) < GetAsNumber ( @Max ) ; // 条件設定

  [ 
    @Inc = GetAsNumber ( @Inc ) + 1 ; 
    @Num = 
      Case ( not IsEmpty ( GetRepetition ( RepField ; @Inc ) ) ; 
        GetAsNumber ( @Num ) + 1 ; 
        GetAsNumber ( @Num ) 
      ) // Case
  ] ; 
  GetAsNumber ( @Inc ) 

) // While

Returns the last repetition number that is not empty.

Example : For the field named "RepField" that has max 10 repetitions shown as below, this function returns "7".
RepField [1] = "a", RepField [2] = "b", ...... RepField [6] = "", RepField [7] = "g",
RepField [8] = "", Repfield [9] = "", RepField [10] = ""

Only for use with FileMaker version 18 and later because this custom function uses "while" function.

Comments

		Alex Zueiv, Tashkent Jan 5, 2022
The native Last() function actually returns a field reference, so if you just pass its result to the GetFieldName() function, you get the full name of the last non-empty repetition: GetFieldName ( Last ( Table::RepField ) ) // ==> Table::RepField[6]

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

LastNonEmptyRepNum ( RepField )

Comments

Support this website.

Support this website.