Brian Dunning's FileMaker Custom Functions

MatchExist ( SourceTable.Field ; DestTable.Field ; ReturnField )

Returns a list of matching (ReturnFields)

  Average rating: 3.0 (1 vote) Log in to vote

Dick Impens   Dick Impens
MaltaCode
https://maltacode.com

Share on Facebook Share on Twitter

  Sample input:
MatchExist("Table1.Phone";"Tabl2.Phone"; "ID" )
  Sample output:
1
3

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

A handy function to check matching fields from one table to another table, returning the result fields of the destination table. Very useful for checking if a particular value exists in a destination table without having to set a filemaker relationship.

I use it to match import tables against existing tables based on unique criteria in order to decide if an record should be created or updated.

This function uses the SQL syntax to define the table.field. The function will split the table and field for Filemaker SQL to create the correct query. All the values should be given as text "table.field"

 

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.