MiddleRepetitions ( repeatingField ; startRepetition ; endRepetition )

Returns specified repetitions of repeatingField.

Average rating: 4.1 (35 votes) Log in to vote

Michael Horak - Show more from this author
*COMMENT Visual Realisation

Sample input:

MiddleRepetitions ( repeatingField ; 3 ; 4 )

-----
repeatingField contents:
1
2
3
4
5

Sample output:

3
4

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

 /*
MiddleRepetitions function

Author
*COMMENT Visual Realisation

Format
MiddleRepetitions ( repeatingField ; startRepetition ; endRepetition ) 

Parameters
repeatingField - any repeating field, or an expression that returns a reference to a repeating field.
startRepetition - any numeric expression or field containing a number
endRepetition - any numeric expression or field containing a number

Data type returned
text

Description
Returns the values in specified repetitions of repeatingField, starting with startRepetition and ending with endRepetition (inclusive).
Returned values are text items followed by carriage returns.
*/

GetRepetition ( repeatingField ; startRepetition ) & "¶" & 
If ( 
(startRepetition+1 ) <= endRepetition;
MiddleRepetitions ( repeatingField ; startRepetition +1; endRepetition ) 
)

Returns the values in specified repetitions of repeatingField, starting with startRepetition and ending with endRepetition (inclusive).

Returned values are text items followed by carriage returns.

Comments

		mamourmb, FMH Jan 22, 2020
Hi and thanks for this function. It sounds like something is missing in the calculation.

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

MiddleRepetitions ( repeatingField ; startRepetition ; endRepetition )

Comments

Support this website.

Support this website.