Using FileMaker Variable in an AppleScript

Discussion created by emilyraynor on Dec 13, 2017
Latest reply on Dec 13, 2017 by brucewilson

I'm having trouble figuring out how to use variables (from a FileMaker field) to open a corresponding file on a server.

Here is what I have so far but I am getting an error:


Set Variable [ $jobno ; Value: Project File Server Locations::_4_digit_Job_No. ]

Set Variable [$range; Value: Project File Server Locations::Range]


Perform AppleScript [ "tell application "Finder"


     make new Finder window

     set target of Finder window 1 to folder "$jobno" of folder "$range" of disk 'TRG Projects" end tell" ]