Creating file pathsFor information on adding a FileMaker data source and specifying file paths, see Connecting to data sources.
The network path to a shared FileMaker Pro file
• Example 1: In this example, a FileMaker Pro database must work on two different operating systems: a Windows system that accesses local Windows files, and an OS X system that accesses local OS X files. On both platforms, the database must access a local file named test.xlsx.
• Example 2: In this example for a scripted record import, a FileMaker Pro database should access a file that is hosted. However, because the host may not be available, you also reference two alternate files, one hosted by a different server, the other stored locally on your hard drive. If the first network file is unavailable, FileMaker Pro will search for the second network file. If the second network file is also unavailable, FileMaker Pro will search for the local file.You can use variables in file paths. Variables let you specify file or folder paths dynamically for many scripts, for example, the Export Records script step. See Using variables.Use the Set Variable script step to create local and global variables.You can also use the Let function to specify variables in calculations.
• To create platform-specific file paths, begin the file path with either filemac or filewin. FileMaker Pro only searches the platform-specific file path that corresponds to the operating system on which the FileMaker Pro application is running.
• To create a file path for use with the Insert PDF script step or the Insert Picture script step, begin the file path with image, imagemac, or imagewin.
• To create a file path for use with the Insert Audio/Video script step or the Insert QuickTime script step, begin the file path with movie, moviemac, or moviewin.
• FileMaker does not recommend using an asterisk (*) as a wildcard character in network file paths as it slows FileMaker network traffic. When possible, replace an asterisk with the appropriate IP address or use variables in file paths. If you have converted a database from a previous version of FileMaker Pro, review the converted data sources and replace any asterisks with known IP addresses or network file paths.
•