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

Pablo Bacherer
Itekpro
http://itekpro.net

Sample input:

resolve ("wheather1")

Sample output:

rain

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

Let ( [

v	= ¶ & ValueListItems ( "file" ; "valuelist.names" ) & ¶ ;
p	= Position ( v ; ¶ & name & ¶ ; 1 ; 1 )

] ;

GetValue ( ValueListItems ( "file" ; "valuelist.values" ) ; ValueCount ( Left ( v ; p ) ) )

Aditional details:

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

Comments

		comment, VR Nov 12, 2013
See a more generalized version here: http://www.briandunning.com/cf/908

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

resolve ( name )

Comments

Support this website.

Support this website.