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

GetNumberRepetitionsInMultivalue ( _Multivalue)

Rate this function:  

  Average rating: 4.3  (31 votes)
  Discuss this Custom Function

Maryse Charbonneau, ACA

returns the number of not empty repetitions in a multivalue

Sample Input:
GetNumberRepetitionsInMultivalue ( multivalue)
Sample Output:

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


Returns the number of not empty repetitions in a multivalue field. Useful if you have a script that must add values inside a multivalue and you want to know right away in which repetition to add it.

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


Why not simply:

Count ( repeatingField )

"... you want to know right away in which repetition to add it."

You are assuming (a) that the non-empty repetitions are consecutive, and (b) that the field has at least one more repetition.

comment, VR
May 01, 2010 4:09am

Yes, you must first test if this function isn't equal to the max of your multivalue. If it is, you show a dialog to the user saying he cannot add because maximum number of values is already reached, if not, you add.
In the code, I give a special button to remove values, if the value isn't the last one, the script move all the values inside previous repetition in order to not have a "hole" inside the multivalue.

Maryse Charbonneau, quebec
May 01, 2010 4:39am

Why not just valueCount( List( _Multivalue )) ?

Bruce Robertson, Redmond
May 02, 2010 12:37pm

Also note that if you are dealing with repeating text fields, it is possible for the cell contents to have return in it. So you could have two filled cells but 10 returns.

Bruce Robertson, Redmond
May 02, 2010 12:45pm

"Why not just valueCount( List( _Multivalue )) ?"

Well, sure: why use only one function when you can use two?

comment, VR
May 02, 2010 4:15pm

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 2 + 3 =
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