resolve ( name )
Easy way to resolve names to values inside scripts. Can be used from any context without creating relationships
Average rating: 4.6 (25 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
There should be a "table" with fields ID,name,value. ID is of type number with auto enter serial enabled. Other fields are text type.
valuelist.names is a value list based on field "names" from "table". Settings: display values from second field "ID", Sort values using second field.
valuelist.values is a value list based on field "values" from "table". Settings: display values from second field "ID", Sort values using second field.
I came up with this function because I wanted to have parameters in scripts that resolve to values contained in a table and hate creating new relationships for every reference from different table instances the scripts are running from.
So far I tested it with no problems. I copied part of the code of this function http://www.briandunning.com/cf/1300
Nov 12, 2013
See a more generalized version here:
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.