ValueListItems and dynamic value lists in calculations
ExpertUse 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.
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.
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.
ValueListItems ( Get ( FileName ) ; "Status Values" ) // Returns: // Active // Inactive // Pending // Archived
Sign in to track your progress and pick up where you left off.
Sign in to FM Dojo