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 70
Get(StatusAreaState) A number representing whether the status toolbar is hidden,
visible, visible and locked, or hidden and locked.
Get(SystemDrive) The drive letter (Windows) or the volume name (Mac OS) where
the currently running operating system is located.
Get(SystemIPAddress) The IP addresses of all the machines connected to a NIC
(Network Interface Controller) card.
Get(SystemLanguage) The language currently set on the current system.
Get(SystemNICAddress) The hardware addresses of all the Network Interface Controller
cards connected to the machine.
Get(SystemPlatform) A number indicating the current platform.
Get(SystemVersion) The version of the operating system of the machine on which the
function is executed.
Get(TemporaryPath) The path to the current user’s temporary folder used by
FileMaker
Pro.
Get(TextRulerVisible) A Boolean value representing whether or not the text ruler is
visible.
Get(TotalRecordCount) The total number of records in the current table.
Get(TriggerKeystroke) A string containing the characters that activated an
OnObjectKeystroke or OnLayoutKeystroke script trigger.
Get(TriggerModifierKeys) The state of the keyboard modifier keys as they were when the
script trigger was activated.
Get(UserCount) The number of users who are currently accessing the file.
Get(UserName) The name of the FileMaker Pro user, as specified in the General
tab of the Preferences dialog box.
Get(UseSystemFormatsState) A Boolean value representing the state of the Use System
Formats menu command.
Get(WindowContentHeight) A number representing the height, in pixels, of the content area.
Get(WindowContentWidth) A number representing the width, in pixels, of the content area.
Get(WindowDesktopHeight) A number representing the height, in pixels, of the desktop space.
Get(WindowDesktopWidth) A number representing the width, in pixels, of the desktop space.
Get(WindowHeight) A number representing the height, in pixels, of the current window
of the file in which the calculation is defined.
Get(WindowLeft) 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) A number representing whether FileMaker Pro is in Browse
mode, Find mode, Preview mode, or printing when the function is
evaluated.
Get(WindowName) The name of the current window of the file in which the calculation
is defined.
Get(WindowTop) 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.
This function Returns