Brian Dunning's FileMaker Custom Functions

NamedRepetition ( theValue ; theList ; theSource )

Select from a repeating field based on a match position in a list

  Average rating: 4.6 (27 votes) Log in to vote

Geoff Wells   Geoff Wells
DataIsland Software LLC
http://www.dataisland.com

Share on Facebook Share on Twitter

  Sample input:
NamedRepetition ("Dark blue";TheList;RepeatingContainer )

TheList contains
Red
Orange
Yellow
Green
Aqua
Light blue
Dark blue
Violet
Pink
Black

RepeatingContainer contains graphics in colors matching TheList and in the same order.
  Sample output:
A dark blue graphic picked from the 7th repetition of the RepeatingContainer

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

This function uses my custom function "PositionValue" to select the contents of a repetition based on the position of a search string in a specified value list.

 

Comments

alix   alix, holland
Oct 27, 2010
good
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.