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 75
Get(ApplicationVersion) Text representing the FileMaker application version.
Get(CalculationRepetitionNumber) A number representing the repetition of the calculation field that is
currently being calculated.
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 for the enabled extended privileges of the
account that is being used to evaluate the calculation.
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 that is being used to evaluate this
calculation in the database.
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(CustomMenuSetName) The name of the active custom menu set.
Get(DesktopPath) The path to the desktop folder for the current user.
Get(DocumentsPath) The path to the Documents folder for the current user.
Get(DocumentsPathListing) A list of all the files and folders in the Documents folder returned
by the Get(DocumentsPath) function.
Get(ErrorCaptureState) A Boolean value representing the state of Error capture script
step.
Get(FileMakerPath) The path to the folder of the currently running copy of
FileMaker
Pro.
Get(FileName) The name of the currently active database file.
Get(FilePath) The full path indicating the location of the file.
Get(FileSize) The size (in bytes) of the currently active database file.
Get(FoundCount) A number that represents the number of records in the current
found set.
Get(HighContrastColor) The name of the current high contrast default color scheme if Use
High Contrast is selected in the Windows operating system
Accessibility Options dialog box.
Get(HighContrastState) A Boolean value representing the state of the Use High Contrast
checkbox on the Accessibility Options dialog box.
Get(HostApplicationVersion) The version of FileMaker Pro or FileMaker Server running on the
computer that is hosting the current database.
Get(HostIPAddress) The IP address of the host machine for the current database.
Get(HostName) The registered name of the computer that is hosting the database
file.
Get(InstalledFMPlugins) The display name, version number (if available), and enabled
state of installed plug-ins.
This function Returns