Functions Reference
Table Of Contents
- Contents
- About functions
- Functions reference (alphabetical list)
- Aggregate functions
- Date functions
- Design functions
- External functions
- Financial functions
- Get functions
- Get(AccountExtendedPrivileges)
- Get(AccountName)
- Get(AccountPrivilegeSetName)
- Get(ActiveFieldContents)
- Get(ActiveFieldName)
- Get(ActiveFieldTableName)
- Get(ActiveLayoutObjectName)
- Get(ActiveModifierKeys)
- Get(ActivePortalRowNumber)
- Get(ActiveRepetitionNumber)
- Get(ActiveSelectionSize)
- Get(ActiveSelectionStart)
- Get(AllowAbortState)
- Get(AllowToolbarState)
- Get(ApplicationLanguage)
- Get(ApplicationVersion)
- Get(CalculationRepetitionNumber)
- Get(CurrentDate)
- Get(CurrentExtendedPrivileges)
- Get(CurrentHostTimestamp)
- Get(CurrentPrivilegeSetName)
- Get(CurrentTime)
- Get(CurrentTimestamp)
- Get(CustomMenuSetName)
- Get(DesktopPath)
- Get(DocumentsPath)
- Get(DocumentsPathListing)
- Get(ErrorCaptureState)
- 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(PreferencesPath)
- Get(PrinterName)
- Get(QuickFindText)
- 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(TriggerKeystroke)
- Get(TriggerModifierKeys)
- 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)
- Logical functions
- Number functions
- Repeating functions
- Summary functions
- Text functions
- Char
- Code
- 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
- Text formatting functions
- Time functions
- Timestamp functions
- Trigonometric functions
FILEMAKER FUNCTIONS REFERENCE 69
Get(LastODBCError) A string that shows the error state published by ODBC standards,
based on ISO/IEF standards.
Get(LayoutAccess) A number corresponding to the layout access privileges assigned
through the Manage Security dialog box.
Get(LayoutCount) The total number of layouts in the database file.
Get(LayoutName) The name of the layout currently displayed.
Get(LayoutNumber) The number of the layout currently displayed, according to the list
in the Manage Layouts dialog box.
Get(LayoutTableName) The name of the table that the layout is displaying records from.
Get(LayoutViewState) Information about how the database file is being viewed.
Get(MultiUserState) A number representing the current multi-user state of the
database file.
Get(NetworkProtocol) The name of the network protocol that FileMaker Pro is using on
this machine.
Get(PageNumber) A number representing the current page being printed or
previewed.
Get(PreferencesPath) The path to the preferences folder for the current user.
Get(PrinterName) A string identifying the default printer name.
Get(QuickFindText) The text that was entered in the Quick Find box.
Get(RecordAccess) A number indicating the access privileges of the current record.
Get(RecordID) The unique ID number of the current record.
Get(RecordModificationCount) The total number of times changes to the current record have
been committed.
Get(RecordNumber) The number of the current record in the current found set.
Get(RecordOpenCount) The total number of open records in the current found set that
haven’t yet been saved.
Get(RecordOpenState) A number representing the state of the current record.
Get(RequestCount) The total number of find requests currently defined for the current
table.
Get(RequestOmitState) A Boolean value representing the state of the Omit checkbox in
Find mode.
Get(ScreenDepth) The number of bits needed to represent the color or shade of gray
of a pixel on the main screen.
Get(ScreenHeight) The number of pixels displayed vertically on the screen in which
the window of the current file is open.
Get(ScreenWidth) The number of pixels displayed horizontally on the screen in
which the window of the current file is open.
Get(ScriptName) The name of the script currently running (or paused).
Get(ScriptParameter) The script parameter passed into the current script.
Get(ScriptResult) The script result from a performed subscript.
Get(SortState) A number value representing the current sort state.
This function Returns