My question is:
In a script I want to open a FM file which is not related but the file name is in field. So basically conditional opening file. Can you help me?
Use the FMP URL protocol:
You'll need more than the field name, you'll also need the exact path to file, whether it is hosted or local. Local files can be opened easily enough using the Send Event, Perform AppleScript or Open URL script steps. Hosted files are more difficult.
Thanks will check it out.
Thanks the file is hosted on my filemaker server
You will need a File Reference (File > Manage > External Data Sources...) in your file to each of the possible target files.
Then you can test the file name field and use If/Else If script test steps to pick which filepath to open based on the field content.
Files.LaunchFile should open FileMaker database:
Retrieving data ...