Brian Dunning's FileMaker Custom Functions

ListExist ( InList ; InValue )

Does a value exist in a list.

  Average rating: 4.7 (22 votes) Log in to vote

Richard DeShong   Richard DeShong
Logic Tools

Share on Facebook Share on Twitter

  Sample input:
ListExist ( "A¶B¶C" ; "B" )
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Find out if a given value exists in a list. The FM function FilterValues() returns nothing if the value does not exist, so this function just tests for that.

~~~ Design Notes ~~~

This is part of a series of LIST functions.
ListAdd, ListAddUnique, ListExist, ListGet, ListToggle.
Each uses the same name format: List
Each uses the same parameter format: InList; InValue.

They also work in concert with two SET functions:
SetVar and SetField
These are all designed to work with variables and to
keep the variables from being un-set (removed from memory),
by using the string "Empty" to indicate IsEmpty().
If a field, MyField, is empty and I use SetVar(),
MyVariable = SetVar( MyField )
Tnen MyVariable is now = "Empty"




Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.