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(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(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
66 FileMaker Functions Reference
Get(SystemPlatform), page 115 A number indicating the current platform.
Get(SystemVersion), page 116 The version of the operating system of the machine on which the
function is executed.
Get(TextRulerVisible), page 116 A Boolean value representing whether or not the text ruler is
visible.
Get(TotalRecordCount), page 117 The total number of records in the current table.
Get(UserCount), page 117 The number of users who are currently accessing the file.
Get(UserName), page 118 The name of the FileMaker Pro user, as specified in the General
tab of the Preferences dialog box.
Get(UseSystemFormatsState), page
119
A Boolean value representing the state of the Use System
Formats menu command.
Get(WindowContentHeight), page
119
A number representing the height, in pixels, of the content area.
Get(WindowContentWidth), page
120
A number representing the width, in pixels, of the content area.
Get(WindowDesktopHeight), page
120
A number representing the height, in pixels, of the desktop space.
Get(WindowDesktopWidth), page
121
A number representing the width, in pixels, of the desktop space.
Get(WindowHeight), page 122 A number representing the height, in pixels, of the current window
of the file in which the calculation is defined.
Get(WindowLeft), page 122 A number representing the horizontal distance, in pixels, of the
outer edge of the current window relative to the left-most edge of
the screen.
Get(WindowMode), page 123 A number representing whether FileMaker Pro is in Browse
mode, Find mode, Preview mode, or printing when the function is
evaluated.
Get(WindowName), page 123 The name of the current window of the file in which the calculation
is defined.
Get(WindowTop), page 124 A number representing the vertical distance, in pixels, of the outer
edge of the current window relative to the bottom edge of the
menu bar or toolbar
.
Get(WindowVisible), page 125 A Boolean value representing whether or not the current window
is visible.
Get(WindowWidth), page 125 A number representing the width, in pixels, of the current window
of the file in which the calculation is defined.
Get(WindowZoomLevel), page 126 The zoom level of the current window.
This function Returns