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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: