Brian Dunning's FileMaker Custom Functions

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   Pablo Bacherer
Itekpro
http://itekpro.net

Share on Facebook Share on Twitter

  Sample input:
resolve ("wheather1")
  Sample output:
rain

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

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   comment, VR
Nov 12, 2013
See a more generalized version here:
http://www.briandunning.com/cf/908
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.