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 |
GetObjectNames ( "file1"; "dataEntry1" ; "pk_ContactID" )
(note: uses table of current layout if not fully qualified)
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
 |
Rayco, Spectrum Oct 5, 2025 |
|
| This seems to be exactly what I am looking for but I can't get it to work. Filemaker Pro 19 on Mac. Looking to control the visibility of a group of items on a box demending on the Object_Name. Any tips? Thanks |
||
|
Rayco, Spectrum Oct 5, 2025 |
|
| This seems to be exactly what I am looking for but I can't get it to work. Filemaker Pro 19 on Mac. Looking to control the visibility of a group of items on a box demending on the Object_Name. Any tips? Thanks |
||
|
Rayco, Spectrum Oct 5, 2025 |
|
| This seems to be exactly what I am looking for but I can't get it to work. Filemaker Pro 19 on Mac. Looking to control the visibility of a group of items on a box demending on the Object_Name. Any tips? Thanks |
||
|
Rayco, Spectrum Oct 5, 2025 |
|
| This seems to be exactly what I am looking for but I can't get it to work. Filemaker Pro 19 on Mac. Looking to control the visibility of a group of items on a box demending on the Object_Name. Any tips? Thanks |
||
|
Jonathan Mickelson Oct 6, 2025 |
|
| Hi Rayco, I'm currently not configured to test in FM19. Can you provide details about some inputs you are using and the examples? In my samples, I attempted to demonstrate how the data can be fed into the function in various ways. Keep in mind the function really needs to parse out the text of the values so sometimes if you look through a function and your specific inputs you can determine that the function works in X way, but not Y, thus tweaking your inputs or the function to address this use case. To address your visibility of an object, I'd suggest that refreshing the layout sometimes needs to be very explicit and can also lead to problems with creating that type of responsive design. Perhaps try to decouple the function from the visibility and see if it's a display/refresh issue vs the function itself, which sometimes also needs to be included within a calculation that explicitly references the fields that the visibility dependency is based upon to "tell" FM that it needs to be re-evaluated. Functions like this one are really just text parsers and tend to be a bit static unless you goose them with other field updating calculations. I hope this helps! |
||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.