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 - Show more from this author

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)

// GetObjectNames ( nameOfFile ; nameOfLayout ; nameOfField )

Let ( 
[ 
// ------ BEGIN VARIABLE DECLARATIONS BELOW -----
file = nameOfFile ; 
layout = nameOfLayout ; 
field = Case ( PatternCount ( nameOfField ; "::" ) = 0 ; Get(LayoutTableName) & "::" & nameOfField ; nameOfField ) ;
objList = LayoutObjectNames ( file ; layout ) ; 
objCount = 
  Case ( $$GetObjectName.count  = "" ; 
            Let ( $$GetObjectName.count = ValueCount ( objList ) ; 
                    $$GetObjectName.count 
                  ) ; // END LET 
            $$GetObjectName.count 
            ) // END CASE
  ; // END objCount
valObj = Substitute ( GetValue ( objList ; objCount ) ; "¶" ; "" ) ; 
fieldVal = GetLayoutObjectAttribute ( valObj ; "source" ) ;
obj = Case ( fieldVal = field ; valObj & "¶") 

]; // 
----------- FUNCTION RESULTS BELOW -----------
//   RECURSION INSIDE

Case ( 
         objCount > 1 ; 
         Let ( $$GetObjectName.count = objCount - 1 ; 
                 GetObjectNames ( nameOfFile ; nameOfLayout ; nameOfField )
               ) ;  // END LET
         Let ( $$GetObjectName.count = "" ;"" ) // END CLEANUP
         ) // END CASE
& obj 

) // END LET

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

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

GetObjectNames ( nameOfFile ; nameOfLayout ; nameOfField )

Comments

Support this website.

Support this website.