Brian Dunning's FileMaker Custom Functions

GetObjectNames ( nameOfFile ; nameOfLayout ; nameOfField )

Given a field name, search a specifc layout for it's object name(s).

  Average rating: 4.3 (37 votes) Log in to vote

Jonathan Mickelson   Jonathan Mickelson

Share on Facebook Share on Twitter

  Sample input:
GetObjectNames ( "file1"; "dataEntry" ; "People::Age" )

GetObjectNames ( "file1"; "dataEntry1" ; "pk_ContactID" )
(note: uses table of current layout if not fully qualified)
  Sample output:
AgeEntry
GUI_AgeDisplay

goto_PrimaryKey

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

Description: Given a field name, search a specific layout for it's object name(s).

Output Format: A return delimited list of Object Names assigned to this field on the layout specified.

Parameters:
~~~~~~~~
nameOfFile - Text representing the Name of the File to query.

nameOfLayout - Text/Time/Date etc. value representing the 2nd parameter.

nameOfField - Text representing the field name to find.

NOTE: This function is designed to use a fieldname that is fully qualified ( meaning "TableName::FieldName" ). The function will add the current layout's underlying Table to create a fully qualified field name if not supplied.

REQUIRES FILEMAKER PRO 8.5 +
-----------------------------------------------------------

Some reasons to do this:
- Another course toward field and layout indirection
- Querying layouts for object names for a specific field
- It seems a logical companion to the object functions that ship with FM 8.5
- Because recursion is wickedly fun...

 

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.