Category: Get

Syntax: Get ( FileName )

Parameters: None

Data type returned: Text


Returns the filename of the current database file without the file extension.

Get(FileName) is useful in function calls that require a filename, even if the current file is being referenced. This way, if the filename changes, you don't need to change any of your calculation formulas.

If a field in file Alpha.fp7 contains the formula Get (FileName), and that field is displayed on a layout in another file, Beta.fp7, via an external table occurrence, the field value will still return Alpha. Its context is rightly applied.




Get (FileName)

Returns the value Contacts when the current database file is named Contacts.fp7.

GetNextSerialValue (Get (FileName); "Contacts:: PrimaryContactID")

Returns the next PrimaryContactID from the Contacts table in the current file. This function call is far less fragile than hard-coding the filename into the preceding expression. If the filename changes at some point in the future, this expression will continue to work as expected.

: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

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

FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352 © 2008-2020.
If you may any questions please contact us: