Functions Reference
Table Of Contents
- Contents
- Functions reference (alphabetical list)
- About functions
- 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(ApplicationArchitecture)
- Get(ApplicationLanguage)
- Get(ApplicationVersion)
- Get(CalculationRepetitionNumber)
- Get(ConnectionAttributes)
- Get(ConnectionState)
- Get(CurrentDate)
- Get(CurrentExtendedPrivileges)
- Get(CurrentHostTimestamp)
- Get(CurrentPrivilegeSetName)
- Get(CurrentTime)
- Get(CurrentTimestamp)
- Get(CurrentTimeUTCMilliseconds)
- Get(CustomMenuSetName)
- Get(DesktopPath)
- Get(Device)
- Get(DocumentsPath)
- Get(DocumentsPathListing)
- Get(EncryptionState)
- 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(MenubarState)
- Get(ModifiedFields)
- Get(MultiUserState)
- Get(NetworkProtocol)
- Get(NetworkType)
- 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(ScreenScaleFactor)
- Get(ScreenWidth)
- Get(ScriptAnimationState)
- 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(TouchKeyboardState)
- Get(TriggerCurrentPanel)
- Get(TriggerExternalEvent)
- Get(TriggerGestureInfo)
- Get(TriggerKeystroke)
- Get(TriggerModifierKeys)
- Get(TriggerTargetPanel)
- 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(WindowOrientation)
- 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
- Furigana
- 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
- Glossary
Get functions
F
ILEMAKER FUNCTIONS REFERENCE 98
Get(ConnectionState) A number representing the security state of the network
connection for the current file.
Get(CurrentDate) The current date according to the system calendar.
Get(CurrentExtendedPrivileges) A list of keywords, based on the account used to evaluate this
calculation, for the enabled extended privileges.
Get(CurrentHostTimestamp) The host's current date and time (to the nearest second)
according to the system clock.
Get(CurrentPrivilegeSetName) The name of the privilege set being used to evaluate this
calculation in the file.
Get(CurrentTime) The current time (to the nearest second) according to the system
clock.
Get(CurrentTimestamp) The current date and time (to the nearest second) according to
the system clock.
Get(CurrentTimeUTCMilliseconds) The current time in Coordinated Universal Time (UTC) to the
nearest millisecond.
Get(CustomMenuSetName) The name of the active custom menu set.
Get(DesktopPath) The path to the desktop folder for the current user.
Get(Device) A number representing the type of computer or mobile device
running the FileMaker product.
Get(DocumentsPath) The path to the Documents folder for the current user.
Get(DocumentsPathListing) A list of all files and folders in the Documents folder returned by
the Get(DocumentsPath) function.
Get(EncryptionState) A value representing the file’s current encryption state.
Get(ErrorCaptureState) 1 (true) if the Set Error Capture script step is on; otherwise,
returns 0 (false).
Get(FileMakerPath) The path to the folder of the currently running copy of
FileMaker
Pro.
Get(FileName) The name of the currently active file, without the filename
extension.
Get(FilePath) The full path of the location of the currently active file.
Get(FileSize) The size, in bytes, of the currently active file.
Get(FoundCount) The number of records in the current found set.
Get(HighContrastColor) The current high contrast default color scheme name.
Get(HighContrastState) 1 (true) if high contrast is available and active; otherwise, returns
0 (false).
Get(HostApplicationVersion) The version of FileMaker Pro or FileMaker Server running on the
computer hosting the current file.
Get(HostIPAddress) The IP address of the host computer for the current file.
Get(HostName) The registered name of the computer that is hosting the file.
Get(InstalledFMPlugins) The name, version number, and enabled state of installed plug-
ins.
Get(LastError) A number for the error that occured in the execution of the most
recently executed script step.
This function Returns