how to use filemaker pro custom function

NEWLIST = LeftValues( OLDLIST ValueCount( OLDLIST ) - 1) THISVALUE = GetValue( OLDLIST ValueCount( OLDLIST ) ) modified to preserve the original order of values and to drop empty values cleans up a value list, leaving only unique values If you modify the code slightly, it will return the values in the same order/sequence. I forgot to use the List function within the brackets.īut it would be nice to modify the function in a way that this step is included.

But instead of listing all values that are unique just the first value of the relation is displayed. I want to list the values of a field in a related table. If( ValueCount(FilterValues(l v)) > 1 '' v & If(newL '¶') ) & uniqueValues( newL ) Both are here on Brian's site.Īn smaller alteration to remove the final ¶ is changing: Ted, check out the custom functions 'SortArray' and 'SortArray_Merge'. UniqueValues ( List(relatedField) ) = b¶a. For example, List (relatedField) = a¶b¶a.

I am using UniqueValues combined with List, and the unique values are returning in a different order than the values produced by List alone. However, I would like the function to always return the values in the same order that they appear in the original list. ValueCount( FilterValues( startlist line1 )) > 1 Newlist = RightValues( startlist ValueCount( startlist ) - 1) 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. 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.Įrik Wegweiser, Intelligent Database, LLC Takes a return-seperated list as parameter and outputs a list of the unique values from this list. If( ValueCount(FilterValues(l v)) > 1 '' v & '¶' ) & UniqueValues( newL ) V = '' UniqueValues( newL ) // Eliminate null values here NewL = RightValues( l ValueCount( l ) - 1) Function definition: (Copy & paste into FileMaker's Edit Custom Function window) Let([

How to use filemaker pro custom function