ListExist ( InList ; InValue )
Does a value exist in a list.
Average rating: 4.7 (22 votes) Log in to vote
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"
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.