Syntax: Get ( FilePath )
Data type returned: Text
Returns the full path to the currently active database file, including the file extension.
Returns file:/driveletter:/databaseName for local files in Windows.
Returns file://volumename/myfoldername/databaseName for remote files in Windows.
Returns file:/path/databaseName for local and remote files in the Mac OS.
Returns fmnet:/networkaddress/databaseName for FileMaker Pro networked files.
Remember that Get (FilePath) includes the filename and extension. Text parsing functions can be used to extract just the file path from the results returned by Get (FilePath). This can be useful for building dynamic paths to objects that are in the same directory as the current file.
If a field in file Alpha.fp7 contains the formula Get (FilePath), and that field is displayed on a layout in another file, Beta.fp7, via an external table occurrence, the field value will still return the file path for file Alpha. Its context is rightly applied.
Returns the current file path.
Left (Get (FilePath); Position ( Get (FilePath); Get (FileName); 1; 1) -1)
Returns just the path to the current file directory. The Position() function truncates the path before the filename.
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
: Other Resources
Where to Go for More Information