Value list functions in FileMaker: ValueListItems, FilterValues, UniqueValues

Intermediate

FileMaker has a set of functions specifically for working with return-delimited value lists. Learn ValueListItems for retrieving named value list contents, FilterValues for set intersection, and UniqueValues for deduplication.

What you'll learn

How ValueListItems() retrieves a named value list as a return-delimited string
How FilterValues() performs a set intersection on two value lists
How UniqueValues() deduplicates a return-delimited list

ValueListItems retrieves the contents of a named value list; FilterValues returns only the values from one list that also appear in another; UniqueValues removes duplicates from a return-delimited list.

Stuck is a valid status

Need a second brain on this one?

If this lesson just collided with your real schema, script stack, or deadline, book consulting and turn the confusion into a concrete plan.

Book consulting

1/3

Retrieve a value list with ValueListItems

ValueListItems ( filename ; valueListName ) returns the items in a named value list as a return-delimited string. Pass an empty string for the filename to reference the current file.

FileMaker Script

// Get all items in the "Status" value list
ValueListItems ( Get ( FileName ) ; "Status" )
// Returns: "Active¶Inactive¶Pending"

// Check whether a value is in the list
If [ PatternCount ( ValueListItems ( Get ( FileName ) ; "Status" ) ; status ) ]
  // valid status
End If

JSONListKeys, JSONGetElementType, and iterating JSON in FileMaker GetAsURLEncoded and GetAsText for URL and display formatting in FileMaker