ValueListItems and dynamic value lists in calculations

Expert

Use ValueListItems() and related functions to read, filter, and construct value list content from within calculations.

What you'll learn

  • How ValueListItems() reads a named value list
  • How to check whether a field value is in a value list
  • How to build a conditional value list using a relationship

ValueListItems() returns the contents of a named value list as a return-delimited text value. This lets calculations and scripts read, count, search, and dynamically filter value list items — enabling cascading dropdowns, validation against a list, and dynamic popups.

1/3
1

Reading a value list with ValueListItems()

ValueListItems(fileName; valueListName) returns the items as a return-delimited list. Pass "" for the file name to reference the current file.

FileMaker Script
ValueListItems ( Get ( FileName ) ; "Status Values" )
// Returns:
// Active
// Inactive
// Pending
// Archived
Designing reusable custom functionsSubstitute() patterns for text transformation

Sign in to track your progress and pick up where you left off.

Sign in to FM Dojo