Get functions generally pull information from a given user's current state, be it from within FileMaker, from one's computer, or from a given network.
Syntax |
Data Type Returned |
---|---|
Get ( AccountName ) |
Text |
Get ( ActiveFieldContents ) |
Text, Number, Date, Time, Timestamp, Container |
Get ( ActiveFieldName ) |
Text |
Get ( ActiveFieldTableName ) |
Text |
Get ( ActiveModifierKeys ) |
Number |
Get ( ActiveRepetitionNumber ) |
Number |
Get ( ActiveSelectionSize ) |
Number |
Get ( ActiveSelectionStart ) |
Number |
Get ( AllowAbortState ) |
Number |
Get ( AllowToolbarState ) |
Number |
Get ( ApplicationLanguage ) |
Text |
Get ( ApplicationVersion ) |
Text |
Get ( CalculationRepetitionNumber ) |
Number |
Get ( CurrentDate ) |
Date |
Get ( CurrentHostTimestamp ) |
Timestamp |
Get ( CurrentTime ) |
Time |
Get ( CurrentTimestamp ) |
Timestamp |
Get ( CustomMenuSetName ) |
Text |
Get ( DesktopPath ) |
Text |
Get ( DocumentsPath ) |
Text |
Get ( ErrorCaptureState ) |
Number |
Get ( ExtendedPrivileges ) |
Text |
Get ( FileMakerPath ) |
Text |
Get ( FileName ) |
Text |
Get ( FilePath ) |
Text |
Get ( FileSize ) |
Number |
Get ( FoundCount ) |
Number |
Get ( HighContrastColor ) |
Text |
Get ( HighContrastState ) |
Number |
Get ( HostIPAddress ) |
Text |
Get ( HostName ) |
Text |
Get ( LastError ) |
Number |
Get ( LastMessageChoice ) |
Number |
Get ( LastODBCError ) |
Text |
Get ( LayoutAccess ) |
Number |
Get ( LayoutCount ) |
Number |
Get ( LayoutName ) |
Text |
Get ( LayoutNumber ) |
Number |
Get ( LayoutTableName ) |
Text |
Get ( LayoutViewState ) |
Number |
Get ( MultiUserState ) |
Number |
Get ( NetworkProtocol ) |
Text |
Get ( PageNumber ) |
Number |
Get ( PortalRowNumber ) |
Number |
Get ( PreferencesPath ) |
Text |
Get ( PrinterName ) |
Text |
Get ( PrivilegeSetName ) |
Text |
Get ( RecordAccess ) |
Number |
Get ( RecordID ) |
Number |
Get ( RecordModificationCount ) |
Number |
Get ( RecordNumber ) |
Number |
Get ( RecordOpenCount ) |
Number |
Get ( RecordOpenState ) |
Number |
Get ( RequestCount ) |
Number |
Get ( RequestOmitState ) |
Number |
Get ( ScreenDepth ) |
Number |
Get ( ScreenHeight ) |
Number |
Get ( ScreenWidth ) |
Number |
Get ( ScriptName ) |
Text |
Get ( ScriptParameter ) |
Text |
Get ( ScriptResult ) |
Text, Number, Date, Time, Timestamp, Container |
Get ( SortState ) |
Number |
Get ( StatusAreaState ) |
Number |
Get ( SystemDrive ) |
Text |
Get ( SystemIPAddress ) |
Text |
Get ( SystemLanguage ) |
Text |
Get ( SystemNICAddress ) |
Text |
Get ( SystemPlatform ) |
Number |
Get ( SystemVersion ) |
Text |
Get ( TextrulerVisible ) |
Number |
Get ( TotalRecordCount ) |
Number |
Get ( UserCount ) |
Number |
Get ( UserName ) |
Text |
Get ( UseSystemFormatsState ) |
Number |
Get ( WindowContentHeight ) |
Number |
Get ( WindowContentWidth ) |
Number |
Get ( WindowDesktopHeight ) |
Number |
Get ( WindowDesktopWidth ) |
Number |
Get ( WindowHeight ) |
Number |
Get ( WindowLeft ) |
Number |
Get ( WindowMode ) |
Number |
Get ( WindowName ) |
Text |
Get ( WindowTop ) |
Number |
Get ( WindowVisible ) |
Number |
Get ( WindowWidth ) |
Number |
Get ( WindowZoomLevel ) |
Text |
: 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