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(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
- GetValue
- Hiragana
- KanaHankaku
- KanaZenkaku
- KanjiNumeral
- Katakana
- Left
- LeftValues
- LeftWords
- Length
- Lower
- Middle
- MiddleValues
- MiddleWords
- NumToJText
- PatternCount
- Position
- Proper
- 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
Get(LayoutViewState), page 95 Information about how the database file is being viewed.
Get(MultiUserState), page 95 A number representing the current multi-user state of the
database file.
Get(NetworkProtocol), page 96 The name of the network protocol that FileMaker Pro is using on
this machine.
Get(PageNumber), page 96 A number representing the current page being printed or
previewed.
Get(PortalRowNumber), page 97 The number of the currently selected portal row.
Get(PreferencesPath), page 97 The path to the preferences folder for the current user.
Get(PrinterName), page 98 A string identifying the default printer name.
Get(PrivilegeSetName), page 99 The name of the privilege set
being used by the current user.
Get(RecordAccess), page 99 A number indicating the access privileges of the current record.
Get(RecordID), page 100 The unique ID number of the current record
.
Get(RecordModificationCount), page
101
The total number of times changes to the current record have
been committed.
Get(RecordNumber), page 102 The number of the current record in the current found set.
Get(RecordOpenCount), page 103 The total number of open records in the current found set that
haven’t yet been saved.
Get(RecordOpenState), page 103 A number representing the state of the current record.
Get(RequestCount), page 104 The total number of find requests currently defined for the current
table.
Get(RequestOmitState), page 104 A Boolean value representing the state of the Omit checkbox in
Find mode.
Get(ScreenDepth), page 105 The number of bits needed to represent the color or shade of gray
of a pixel on the main screen.
Get(ScreenHeight), page 105 The number of pixels displayed vertically on the screen in which
the window of the current file is open.
Get(ScreenWidth), page 106 The number of pixels displayed horizontally on the screen in
which the window of the current file is open.
Get(ScriptName), page 106 The name of the script currently running (or paused).
Get(ScriptParameter), page 107 The script parameter passed into the current script.
Get(ScriptResult), page 108 The script result from a performed subscript.
Get(SortState), page 109 A Boolean value representing the current sort state.
Get(StatusAreaState), page 109 A number representing whether the status area
is hidden, visible,
visible and locked, or hidden and locked.
Get(SystemDrive), page 110 The drive letter (Windows) or the volume name (Mac OS) where
the currently running operating system is located.
Get(SystemIPAddress), page 111 The IP addresses of all the machines connected to a NIC
(Network Interface Controller) card.
Get(SystemLanguage), page 111 The language currently set on the current system.
Get(SystemNICAddress), page 112 The hardware addresses of all the Network Interface Controller
cards connected to the machine.
Get(SystemPlatform), page 112 A number indicating the current platform.
This function Returns