Hello, I'm looking for similar assistance with Passing Applescript results to a Filemaker script.
I have an Applescript that asks a user for a HiRes Image and makes a thumbnail with padding and copies the Thumbnail and the HiRes to specified folders. What I'm missing is how to pass this image name to FM and have the thumbnail inserted into the "Picture" filed.
Here is the FM section:
set mac_path to (LoRes_Path) as text
set FM_path to "filemac:/" & my ConvertPath(mac_path)
set FM_fullpath to FM_path & "/" & new_image
on ConvertPath(mac_path)
set AppleScript's text item delimiters to ":"
set x to mac_path's text items
set AppleScript's text item delimiters to "/"
set z to x's text items as text
set AppleScript's text item delimiters to ""
return z
end ConvertPath
tell application "FileMaker Pro Advanced"
tell database "Inventory.fp7"
tell current record
set cell "Picture" to file FM_fullpath
end tell
end tell
end tell
Here are the error results:
tell application "FileMaker Pro Advanced"
set cell "Picture" of current record of database "Inventory.fp7" to file "filemac:/Macintosh HD/Users/Shared/DatabaseImages/LoRes/Macintosh HD:Users:Shared:DatabaseImages:LoRes" of current record of database "Inventory.fp7"
--> error "Object or property is the wrong type." number -10001
any help would be appreciated.
Ben