Brian Dunning's FileMaker Custom Functions

cf_GetElement ( SearchString ; KeyList ; ElementList )

Find a value from a second list, based on a search of a key field in a first list.

  Average rating: 4.1 (35 votes) Log in to vote

Gary Tate   Gary Tate
TGI Solutions
http://www.tgisolutions.co.uk

Share on Facebook Share on Twitter

  Sample input:
cf_GetElement ( "06" ; "01¶02¶03¶04¶05¶06¶07¶08¶09¶10¶11¶12" ; "January¶February¶March¶April¶May¶June¶July¶August¶September¶October¶November¶December" )
  Sample output:
"June"

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

I wrote this to dynamically build tool tips based on 3 possible values for a specific button. Each tool tip would have 2 values, Full and Minimum. A user preference would specify which level of tool tip to return (ie a user could decide to receive a long or short tool tip, or none at all). The tool tip for the button would then be set to supply the tool tip list (either Full or Minimum) a serias of tool tip headings, and the name of the tool tip to find (eg New Company). The tool tip name would then be looked up in the tool tip heading list and the appropriate tool tip returned.

Note it will fall over if your key list entries can be found in more than 1 place (in the example above "1" appears in 1, 10, 11 and 12)

 

Comments

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.