I'm sure this is quite easy to do, but since I've never used AppleScript, I thought I'd ask the experts to fill me in and save myself the learning curve.

I need the syntax in apple script that will open a record's file folder in a certain directory. The folder name is dynamic, named Last_First for each record. I'd like a script in FMP that opens the folder, so that user can then see all the associated scanned files connected with the record, and choose to open them or not.

On the PC, the Open URL script step does this, but I think for the Mac I'll need to use AppleScript. Can anyone help me? thanks so much!

Leah Brooks

You could try this, "pathtofolder" is a calculation field.

tell application "FileMaker Pro"

set folder_path to cell "pathtofolder" of current record of database "DB_Name"

end tell

tell application "Finder"

activate

try

open folder (folder_path)

on error

display dialog "This folder can't be opened.

The folder has been moved, deleted or renamed."

end try

end tell

Thanks, this looks like it will work!

I appreciate it.

Leah