Shopping Cart
Contact
FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.
|
||||||||||||||||||||||||||||||||||||||||
UniqueValues( values ) Rate this function:    Discuss this Custom Function Jeroen Aarts, ClickWorks Retains only unique values from list
Description:Takes a return-seperated list as parameter and outputs a list of the unique values from this list. This function can be used in conjunction with the FileMaker List() function to mimick the good old value list items behavior, without creating a ValueList. 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:Thanks to both Jeroen and Erik. Vaughan Bromfield, Sydney, Australia Nice function. However, I would like the function to always return the values in the same order that they appear in the original list. I am using UniqueValues combined with List, and the unique values are returning in a different order than the values produced by List alone. For example, List (relatedField) = a¶b¶a. UniqueValues ( List(relatedField) ) = b¶a. Any suggestions? Thank you. Ted Hoagland, Santa Barbara, CA Ted, check out the custom functions "SortArray" and "SortArray_Merge". Both are here on Brian's site. Joan Martensen, Washington, USA Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post: |
|
|||||||||||||||||||||||||||||||||||||||
With thanks to Jeroen, whose elegant, single-parameter function I have used frequently, here is my modification of this formula, producing the same results without an extra return character appended.
Let([
startlist = values;
line1 = GetValue( startlist; 1 );
newlist = RightValues( startlist; ValueCount( startlist ) - 1)
];
Case(
IsEmpty( startlist );
"";
ValueCount( FilterValues( startlist; line1 )) > 1;
UniqueValues( newlist );
List( line1; UniqueValues( newlist ) )
)
)
Erik Wegweiser, Boston, MA
January 09, 2011 11:25am