Functions Reference
Table Of Contents
- Contents
- About functions
- Functions reference (alphabetical list)
- Aggregate functions
- Container 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(AllowFormattingBarState)
- Get(ApplicationLanguage)
- Get(ApplicationVersion)
- Get(CalculationRepetitionNumber)
- Get(ConnectionState)
- 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(InstalledFMPlugins)
- 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(PersistentID)
- 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(TriggerCurrentTabPanel)
- Get(TriggerKeystroke)
- Get(TriggerModifierKeys)
- Get(TriggerTargetTabPanel)
- Get(UserCount)
- Get(UserName)
- Get(UseSystemFormatsState)
- Get(UUID)
- Get(WindowContentHeight)
- Get(WindowContentWidth)
- Get(WindowDesktopHeight)
- Get(WindowDesktopWidth)
- Get(WindowHeight)
- Get(WindowLeft)
- Get(WindowMode)
- Get(WindowName)
- Get(WindowStyle)
- Get(WindowTop)
- Get(WindowVisible)
- Get(WindowWidth)
- Get(WindowZoomLevel)
- Logical functions
- Mobile 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 77
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.
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(TriggerCurrentTabPanel) The index number and object name of the tab panel to be
switched from when the OnTabSwitch script trigger is activated.
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(TriggerTargetTabPanel) The index number and object name of the tab panel to be
switched to when the OnTabSwitch script trigger is 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(UUID) Text representing a Universally Unique Identifier (UUID).
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.
This function Returns