Help

Creating a database
F
ILEMAKER PRO HELP 201
You can also use the Let function to specify variables in calculations.
The scope of local variables is limited to the current script. The scope of global variables is limited to
the file in which the global variables are defined, for as long as the file remains open.
Examples of using variables in file paths
Assume the following variables:
$fileName = "test.xlsx"
$username = "JohnSmith"
$targetDir = "Documents/Clients"
$chosenType = "filewin"
$$source = "file:Documents/2014/demo files"
$driveLetter = "G:"
$searchList = "file:old results.txt
file:../archived/old results.txt"
Notes
• File paths can be edited as text.
• To create a generic, cross-platform file path, begin the file path with the word file.
• 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.
To Path list entry Resolved path list
Specify a filename
only
file:testing/$fileName file:testing/test.xlsx
Specify one or more
directories in a path
file:$username/$fileName file:JohnSmith/test.xlsx
Specify absolute
paths or relative
paths, with various
path type prefixes
filewin:/$driveLetter/
$targetDir/contacts.txt
filemac:../$targetDir/contacts
filewin:/G:/Documents/
Clients/contacts.txt
filemac:../Documents/
Clients/contacts
Specify a path type
prefix dynamically or
as part of a longer
path
$chosenType:/$driveLetter/
$targetDir
$$source/$fileName
filewin:/G:/Documents/
Clients
file:Documents/2014/demo
files/test.xlsx
Specify one or more
complete paths
$searchList file:old results.txt
file:../archived/old
results.txt
Specify a directory
(not a file)
file:$targetDir/
$$source/
file:$targetDir/$username/
file:Documents/Clients/
file:Documents/2014/demo
files/
file:Documents/Clients/
JohnSmith/