Anyone know the script to create a new folder usind a FM field as the name?

Basically want to go to HardDriv/Clients/Projects and create a folder with our job number and description and then open in in the finder.

Thanks in advace.

This should do what you want. Just replace the JobNumber and Desc with your job number and description fields and the Jobs.fp5 database name with your database name.

tell application "FileMaker Pro"

Thanks Chuck!!

What about error catching if the folder already exists (I'd hate to wirte over it) or if the drive is not mounted?

Try this:

tell application "FileMaker Pro"

set folderName to (cell "JobNumber" of layout 0 of database "Jobs.fp5") & (cell "Desc" of layout 0 of database "Jobs.fp5")

end tell

tell application "Finder"