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

GetNumberRepetitionsInMultivalue ( _Multivalue)

Rate this function:  

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

Maryse Charbonneau, ACA
http://-

returns the number of not empty repetitions in a multivalue

Sample Input:
GetNumberRepetitionsInMultivalue ( multivalue)
Sample Output:
3


 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

Description:

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

This is my Custom Function and I want to edit it

Discuss:

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:
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 5 + 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. decFromHex ( hexValue )
  (Mon, Oct 16, 12:34pm)
2. MonthYearList ( startmonth ; startyear ; numbermonth ; short )
  (Mon, Oct 16, 3:38am)
3. ErrorDescription ( errorNumber )
  (Wed, Sep 27, 2:51am)
4. decodeEntities (text)
  (Wed, Sep 27, 1:22am)
5. HexidecimalToNumber ( HexidecimalValue ; counter )
  (Mon, Sep 25, 12:39pm)
6. FixedFieldConverter ( Fieldname ; f1 ; f2 ; f3 ; f4 ; f5 ; f6 ; f7 ; f8 ; f9 ; f10 ; f11 ; f12 ; f13 ; f14 ; f15 ; f16 ; f17 ; f18 ; f1
  (Fri, Sep 15, 12:34pm)
7. ShannonEntropy ( text )
  (Thu, Sep 07, 5:59am)
8. LetterCount ( text ; summary )
  (Thu, Sep 07, 5:53am)

RSS Feed of Custom Functions