|
In brief, the idea is to use a FileMaker utility file and an AppleScript together with Mouseposé to automatically go to the file and layout and then spotlight the error.
I populated the FileMaker utility file using data from MetadataMagic running under FileMaker 6. I have not had occasion to update the utility to run with any of the current tools, but will do so if need arises - unless someone does so first ;)
You can download the FileMaker file here. Mouseposé can be found here. The AppleScript below should be easy to copy and adapt to your use:
To watch the "how to" video in your browser click here.
You can also download the video here (4.6 MB).
The best way to use the AppleScript is to run it from an open script editor window.
Enjoy.
tell application "FileMaker Developer"
activate
tell document "TWDI_MdM_LayoutItems.fp5"
set DBFileName to cell "DBFileName" of current record
set LayoutName to cell "LayoutName" of current record
set LeftCoord to cell "Left" of current record
set TopCoord to cell "Top" of current record
set WidthVar to cell "Width" of current record
set HeightVar to cell "Height" of current record
end tell
end tell
tell application "FileMaker Developer"
activate
go to database DBFileName
go to layout LayoutName
do menu menu item "Layout Mode" of menu "View"
set bounds of window 1 to {7, 44, 1192, 1194}
end tell
set MonitorWidth to 1920 -- change for your display size
set MonitorHeight to 1200 -- change for your display size\
set xCoord to LeftCoord + (WidthVar / 2) + 98 -- adj for FM
set yCoord to MonitorHeight - TopCoord - (HeightVar / 2) - 78 + 21 -- adj FM/menu
tell application "Mousepose"
activate
store settings
set overlay opacity to 25
start effect
set mouse location to {xCoord, yCoord}
stop effect
restore settings
end tell
|
