Software Venture Consulting

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

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


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:  

RatingRatingRatingRatingRating
  Average rating: 4.5  (30 votes)
  Discuss this Custom Function

Kevin Frank, Kevin Frank & Associates
http://www.kevinfrank.com

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.

Description:

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 BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

Discuss:

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.

Regards,
Kevin

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

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:
City/Location:
Comment:
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 2 + 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. HexUUIDToNum_cf (_uuid)
  (Sat, Jun 16, 1:55pm)
2. httpResponseCode ( responseHeaders )
  (Tue, Jun 12, 10:40pm)
3. FindDuplicateCharacters ( string )
  (Fri, Jun 08, 5:01pm)
4. FieldRepetitionLast ( field ; maxRepetition )
  (Wed, Jun 06, 6:05pm)
5. CountModifiedRecords ( NameTimestampField ; StartTimestamp ; EndTimestamp )
  (Mon, May 28, 8:23am)
6. JSONArrayLength ( JSONArrayStr )
  (Fri, May 25, 7:46am)
7. interpolation (y1; y2; y3; x1; x2; x3; x1y1; x2y1; x1y2; x2y2; rnd)
  (Sat, May 19, 3:55am)
8. @JSONFormatElements ( json )
  (Tue, May 15, 3:31am)

RSS Feed of Custom Functions