Shopping Cart
FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.
|
||||||||||||||||||||||||||||||||||||||||
ValueExists ( Value ; ValueList ) Rate this function:   Discuss this Custom Function Caleb Ruth, Data Performance LLC A recursive function that returns a 1 if a value is found in the supplied list
Description:The same results can be had using the native FilterValues function, but I find this to be more logical. Recursion limits apply to the size of the list. 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:Alternative single line code: F. Osman Cabi, Turkey Dave Graham's code works correctly. Osman's code will fail for partial matches. Bruce Robertson, Redmond Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post: |
|
|||||||||||||||||||||||||||||||||||||||
There's no need for recursion for this function. This does it in a single line of code:
not IsEmpty( FilterValues ( valueList ; filterBy) )
Dave Graham, San Diego, CA
June 09, 2010 1:51pm