Returns valuelist with each value prefixed and suffixed with the specified values. If a prefixed-only value list is desired, provide an empty suffix text and vice versa.
Avoids hard-coding in FileMaker by using IDs instead of names. Full documentation here : http://www.1-more-thing.com/FileMaker-Avoid-Hard-coding.html
Retrieve the index of the matching valueString in the valueList with optional case-sensitivity and occurrence restrictions.
Last ID obtained from value list
Used in an always evaluating auto-enter, allows to resort the field based on the value list attached to it.