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
Chapter 7
|
Get functions 59
Get(LayoutNumber), page 86 The number of the layout currently displayed, according to the list
in the Set Layout Order dialog box.
Get(LayoutTableName), page 86 The name of the table that the layout is displaying records from.
Get(LayoutViewState), page 87 Information about how the database file is being viewed.
Get(MultiUserState), page 87 A number representing the current multi-user state of the
database file.
Get(NetworkProtocol), page 88 The name of the network protocol that FileMaker Pro is using on
this machine.
Get(PageNumber), page 89 A number representing the current page being printed or
previewed.
Get(PortalRowNumber), page 89 The number of the currently selected portal row.
Get(PreferencesPath), page 90 The path to the preferences folder for the current user.
Get(PrinterName), page 90 A string identifying the default printer name.
Get(PrivilegeSetName), page 91 The name of the privilege set
being used by the current user.
Get(RecordAccess), page 92 A number indicating the access privileges of the current record.
Get(RecordID), page 93 The unique ID number of the current record
.
Get(RecordModificationCount), page
94
The total number of times changes to the current record have
been committed.
Get(RecordNumber), page 94 The number of the current record in the current found set.
Get(RecordOpenCount), page 95 The total number of open records in the current found set that
haven’t yet been saved.
Get(RecordOpenState), page 96 A number representing the state of the current record.
Get(RequestCount), page 96 The total number of find requests currently defined for the current
table.
Get(RequestOmitState), page 97 A Boolean value representing the state of the Omit checkbox in
Find mode.
Get(ScreenDepth), page 97 The number of bits needed to represent the color or shade of gray
of a pixel on the main screen.
Get(ScreenHeight), page 98 The number of pixels displayed vertically on the screen in which
the window of the current file is open.
Get(ScreenWidth), page 99 The number of pixels displayed horizontally on the screen in
which the window of the current file is open.
Get(ScriptName), page 99 The name of the script currently running (or paused).
Get(ScriptParameter), page 100 The script parameter passed into the current script.
Get(ScriptResult), page 101 The script result from a performed subscript.
Get(SortState), page 102 A Boolean value representing the current sort state.
Get(StatusAreaState), page 102 A number representing whether the status area
is hidden, visible,
visible and locked, or hidden and locked.
Get(SystemDrive), page 103 The drive letter (Windows) or the volume name (Mac OS) where
the currently running operating system is located.
Get(SystemIPAddress), page 104 The IP addresses of all the machines connected to a NIC
(Network Interface Controller) card.
Get(SystemLanguage), page 104 The language currently set on the current system.
This function Returns