FieldMaxRepetitions ( Field )

Returns the number of Repetitions of the field maximum.

Average rating: 4.5 (29 votes) Log in to vote

HAZI
none
http://hazisarashi.com

Sample input:

FieldMaxRepetitions ( data table::repetition field )

Sample output:

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

/*
FieldMaxRepetitions ( Field )
Returns the number of Repetitions of the field maximum.
*/

Let([
  FieldName = GetFieldName ( Field );
  NameOnly = Middle ( Field ; Position( FieldName ; "::" ; 1 ; 1 ) + 2 ; Length ( FieldName ) )
];
  GetAsNumber ( MiddleWords ( FieldType ( Get ( FileName ) ; NameOnly ) ; 4 ; 1 ) )
)

1. The return value is the number of Repetitions that are configured in the field definition.

2. With this, you do not need to modify the script even if you change the name of the field.

Comments

		HAZI, Tokyo, Japan Dec 24, 2012
There was a waste of this function. Mr.Steven Sanders gave me a feedback. Thank Mr.Steven Sanders. Let([ FieldName = GetFieldName( Field ) ]; GetAsNumber( MiddleWords( FieldType( Get( FileName ) ; FieldName ) ; 4 ; 1 )) )

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

FieldMaxRepetitions ( Field )

Comments

Support this website.

Support this website.