Using calculated applescript in FM Pro 5.5 on Mac OSX to move a folder

[admreece]

I have created the following script that runs within FM Pro 5.5 to move a folder from one location to another.

tell application "Finder"

move folder "folder to move" of folder "test scripts" of folder "Desktop" of folder "adamreece" of folder "Users" of startup disk of application "Finder" to folder "To Archive" of folder "job_folders" of disk "XSERVER" of application "Finder"

end tell

This works if run as a straightforward script step, but I want to be able to use a calculated field as I want to use a database field to specify the 'folder to move' name etc.

We use FM to book in design jobs and invoice them when complete. The aim of this script will be to automatically move a job folder based on its unique job reference number (ie. 060378) when we run a script to invoice the job.

Sorry in advance if I've not explained myself clearly, but I need help to get this working.

Thanks!!

[Lee Smith]

Automatic message

This topic has been moved from "FileMaker Product Family → FileMaker Legacy → FileMaker.fp5" to "Database Schema & Business Logic → Managing Scripts".