Send Event to launch external application file path issue
Hello, I'm new to FileMaker. I'm not quite sure on the terminology, but I'm going to refer to the rows as "Records".
I have a table called "Test". In Test, there is a column called, "Illustrator" of the type Container. Every Record of the Layout has an Illustrator file (.ai) in this column which I have manually specified. In the Layout, I've created a button with a script that I intend to launch the Illustrator file for that Record.
Here's the script for that button: Send Event ["aevt"; "odoc"; Test::Illustrator]
If the .ai files are in different folders, then only the one that I've most recently assigned will work. The others result in the following error: "The file "blah blah.ai" could not be found and is required to complete this operation."
If the .ai files are all in the same folder, then they all work. Are these file references supposed to work across multiple folders? Does anybody understand the origin of this problem?
Are the files inserted as references? If so, try to do the following:
Set Variable[ $file; GetAsText( Test::Illustrator ) ]
Send Event[ "aevt"; "odoc"; $file ]
In the Send Event you'll need to specify the $file as file, not as a calculation or text.