Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages

Shopping Cart
Shopping Cart


Free Newsletter


Privacy Policy

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.


 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

SetRepeatingVariable ( variableName ; valueName ; startIndex ; endIndex )

Rate this function:  

  Average rating: 4.4  (30 votes)
  Discuss this Custom Function

Kevin Frank, Kevin Frank & Associates

Sets a range of variable repetitions to a specified value

Sample Input:
SetRepeatingVariable ( "$$test" ; "green" ; 1 ; 3 )
Sample Output:
"green" in reps 1, 2, and 3 of $$test

 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed


I do a lot of charting using variable arrays, and frequently I need a placeholder value, such as the word "null", in any array rep that doesn't contain data. I used to populate these placeholder reps using a scripted loop, but with this CF, a single line of code is all it takes.

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

This is my Custom Function and I want to edit it


Beautiful! An easy way to reset a global variable.

John Leyman, Loma Linda, CA
November 28, 2011 7:13pm

Fatal flaw; always hits recursion limit.

Original example file posted elsewhere works fine but this part of expression does not match the original.

endIndex = 0 and startIndex = endIndex

In original file it was:

endIndex ≥ 0 and startIndex ≥ endIndex

Bruce Robertson, Redmond WA
December 04, 2011 9:41am

Thanks Bruce. Code has now been updated.

It must have gotten munged when I pasted it in to submit it here, because as you point out, it was correct in the original version.

This time around I'm using ">=" so am optimistic that the problem has been solved.


Kevin Frank, Arcata, CA
December 04, 2011 4:54pm

So If I

SetRepeatingVariable ( "$$test" ; "MyField" ; 3 ; 1 )

It would put the contents of MyField in Rep 3 (only) of the $$test variable?

Bob, east hampton
December 08, 2011 4:30pm

Not exactly... first off, if you only want to set rep 3, then you want "3 ; 3" as the final two arguments... because the starting and ending reps are both 3. The point is to specify a range of reps.

Next, since you've wrapped "MyField" in quotes, it will be treated as a text string, so you would end up with "MyField" in $$test[3], assuming you started with

SetRepeatingVariable ( "$$test" ; "MyField" ; 3 ; 3 )

Hope this helps,

Kevin Frank, Arcata, CA
December 08, 2011 4:58pm

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 9 + 8 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. ExcludeValues(MyList ; Out)
  (Wed, Mar 21, 7:23am)
2. PreviousMonthEndDate ( myDate )
  (Wed, Mar 07, 3:35am)
3. PreviousMonthName (myDate)
  (Wed, Mar 07, 3:33am)
4. FmTableFields ( tableName ; fieldsInclude ; fieldsExclude ; classExclude ; typeExclude ; prefixExclude )
  (Fri, Mar 02, 6:32am)
5. sql.getTable ( fullyQualifiedFieldObject )
  (Thu, Feb 22, 8:36am)
6. sql.getField ( fullyQualifiedFieldObject )
  (Thu, Feb 22, 8:34am)
7. FilterOut ( ListA ; ListB )
  (Wed, Feb 21, 6:11pm)
8. Char0 ( )
  (Sun, Feb 18, 2:35am)

RSS Feed of Custom Functions