Functions Reference
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Aggregate functions
- Chapter 3 Date functions
- Chapter 4 Design functions
- Chapter 5 External functions
- Chapter 6 Financial functions
- Chapter 7 Get functions
- Get(AccountName)
- Get(ActiveFieldContents)
- Get(ActiveFieldName)
- Get(ActiveFieldTableName)
- Get(ActiveLayoutObjectName)
- Get(ActiveModifierKeys)
- Get(ActiveRepetitionNumber)
- Get(ActiveSelectionSize)
- Get(ActiveSelectionStart)
- Get(AllowAbortState)
- Get(AllowToolbarState)
- Get(ApplicationLanguage)
- Get(ApplicationVersion)
- Get(CalculationRepetitionNumber)
- Get(CurrentDate)
- Get(CurrentHostTimestamp)
- Get(CurrentTime)
- Get(CurrentTimestamp)
- Get(CustomMenuSetName)
- Get(DesktopPath)
- Get(DocumentsPath)
- Get(ErrorCaptureState)
- Get(ExtendedPrivileges)
- Get(FileMakerPath)
- Get(FileName)
- Get(FilePath)
- Get(FileSize)
- Get(FoundCount)
- Get(HighContrastColor)
- Get(HighContrastState)
- Get(HostApplicationVersion)
- Get(HostIPAddress)
- Get(HostName)
- Get(LastError)
- Get(LastMessageChoice)
- Get(LastODBCError)
- Get(LayoutAccess)
- Get(LayoutCount)
- Get(LayoutName)
- Get(LayoutNumber)
- Get(LayoutTableName)
- Get(LayoutViewState)
- Get(MultiUserState)
- Get(NetworkProtocol)
- Get(PageNumber)
- Get(PortalRowNumber)
- Get(PreferencesPath)
- Get(PrinterName)
- Get(PrivilegeSetName)
- Get(RecordAccess)
- Get(RecordID)
- Get(RecordModificationCount)
- Get(RecordNumber)
- Get(RecordOpenCount)
- Get(RecordOpenState)
- Get(RequestCount)
- Get(RequestOmitState)
- Get(ScreenDepth)
- Get(ScreenHeight)
- Get(ScreenWidth)
- Get(ScriptName)
- Get(ScriptParameter)
- Get(ScriptResult)
- Get(SortState)
- Get(StatusAreaState)
- Get(SystemDrive)
- Get(SystemIPAddress)
- Get(SystemLanguage)
- Get(SystemNICAddress)
- Get(SystemPlatform)
- Get(SystemVersion)
- Get(TemporaryPath)
- Get(TextRulerVisible)
- Get(TotalRecordCount)
- Get(UserCount)
- Get(UserName)
- Get(UseSystemFormatsState)
- Get(WindowContentHeight)
- Get(WindowContentWidth)
- Get(WindowDesktopHeight)
- Get(WindowDesktopWidth)
- Get(WindowHeight)
- Get(WindowLeft)
- Get(WindowMode)
- Get(WindowName)
- Get(WindowTop)
- Get(WindowVisible)
- Get(WindowWidth)
- Get(WindowZoomLevel)
- Chapter 8 Logical functions
- Chapter 9 Number functions
- Chapter 10 Repeating functions
- Chapter 11 Summary functions
- Chapter 12 Text functions
- Exact
- Filter
- FilterValues
- GetAsCSS
- GetAsDate
- GetAsNumber
- GetAsSVG
- GetAsText
- GetAsTime
- GetAsTimestamp
- GetAsURLEncoded
- GetValue
- Hiragana
- KanaHankaku
- KanaZenkaku
- KanjiNumeral
- Katakana
- Left
- LeftValues
- LeftWords
- Length
- Lower
- Middle
- MiddleValues
- MiddleWords
- NumToJText
- PatternCount
- Position
- Proper
- Quote
- Replace
- Right
- RightValues
- RightWords
- RomanHankaku
- RomanZenkaku
- SerialIncrement
- Substitute
- Trim
- TrimAll
- Upper
- ValueCount
- WordCount
- Chapter 13 Text formatting functions
- Chapter 14 Time functions
- Chapter 15 Timestamp functions
- Chapter 16 Trigonometric functions
- Appendix A Glossary
58 FileMaker Functions Reference
Get(ApplicationVersion), page 69 Text representing the FileMaker Pro application version.
Get(CalculationRepetitionNumber),
page 69
A number representing the repetition of the calculation field that is
currently being calculated.
Get(CurrentDate), page 70 The current date according to the system calendar.
Get(CurrentHostTimestamp), page
71
The host's current date and time (to the nearest second)
according to the system clock.
Get(CurrentTime), page 72 The current time (to the nearest second) according to the system
clock.
Get(CurrentTimestamp), page 72 The current date and time (to the nearest second) according to
the system clock.
Get(CustomMenuSetName), page 73 The name of the active custom menu set.
Get(DesktopPath), page 73 The path to the desktop folder for the current user.
Get(DocumentsPath), page 74 The path to the documents folder for the current user.
Get(ErrorCaptureState), page 74 A Boolean value representing the state of Error capture script
step.
Get(ExtendedPrivileges), page 75 A list of key words for the enabled extended privileges
, separated
by carriage returns
Get(FileMakerPath), page 76 The path to the folder of the currently running copy of FileMaker
Pro.
Get(FileName), page 76 The name of the currently active database file.
Get(FilePath), page 77 The full path indicating the location of the file.
Get(FileSize), page 77 The size (in bytes) of the currently active database file.
Get(FoundCount), page 78 A number that represents the number of records in the current
found set
.
Get(HighContrastColor), page 79 The name of the current high contrast default color scheme if Use
High Contrast is selected in the Windows operating system
Accessibility Options dialog box.
Get(HighContrastState), page 79 A Boolean value representing the state of the Use High Contrast
checkbox on the Accessibility Options dialog box.
Get(HostApplicationVersion), page
80
The version of FileMaker Pro or FileMaker Server running on the
computer that is hosting the current database.
Get(HostIPAddress), page 80 The IP address of the host machine for the current database.
Get(HostName), page 81 The registered name of the computer that is hosting
the database
file.
Get(LastError), page 82 A number representing the error, if any, in the execution of the
most recently executed script step.
Get(LastMessageChoice), page 82 A number corresponding to the button clicked in an alert message
displayed by the Show Custom Dialog script step.
Get(LastODBCError), page 83 A string that shows the error state published by ODBC standards,
based on ISO/IEF standards.
Get(LayoutAccess), page 84 A number corresponding to the layout access privileges
assigned
through the Manage Accounts & Privileges dialog box.
Get(LayoutCount), page 85 The total number of layouts in the database file.
Get(LayoutName), page 85 The name of the layout currently displayed.
This function Returns