Functions Reference
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Aggregate functions
- Chapter 3 Date functions
- Chapter 4 Design functions
- Chapter 5 External functions
- Chapter 6 Financial functions
- Chapter 7 Get functions
- Get(AccountName)
- Get(ActiveFieldContents)
- Get(ActiveFieldName)
- Get(ActiveFieldTableName)
- Get(ActiveLayoutObjectName)
- Get(ActiveModifierKeys)
- Get(ActiveRepetitionNumber)
- Get(ActiveSelectionSize)
- Get(ActiveSelectionStart)
- Get(AllowAbortState)
- Get(AllowToolbarState)
- Get(ApplicationLanguage)
- Get(ApplicationVersion)
- Get(CalculationRepetitionNumber)
- Get(CurrentDate)
- Get(CurrentHostTimestamp)
- Get(CurrentTime)
- Get(CurrentTimestamp)
- Get(CustomMenuSetName)
- Get(DesktopPath)
- Get(DocumentsPath)
- Get(ErrorCaptureState)
- Get(ExtendedPrivileges)
- Get(FileMakerPath)
- Get(FileName)
- Get(FilePath)
- Get(FileSize)
- Get(FoundCount)
- Get(HighContrastColor)
- Get(HighContrastState)
- 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(PortalRowNumber)
- Get(PreferencesPath)
- Get(PrinterName)
- Get(PrivilegeSetName)
- 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(TextRulerVisible)
- Get(TotalRecordCount)
- 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)
- Chapter 8 Logical functions
- Chapter 9 Number functions
- Chapter 10 Repeating functions
- Chapter 11 Summary functions
- Chapter 12 Text functions
- 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
- Chapter 13 Text formatting functions
- Chapter 14 Time functions
- Chapter 15 Timestamp functions
- Chapter 16 Trigonometric functions
- Appendix A Glossary
64 FileMaker Functions Reference
Get(ApplicationVersion), page 75 Text representing the FileMaker Pro application version.
Get(CalculationRepetitionNumber),
page 75
A number representing the repetition of the calculation field that is
currently being calculated.
Get(CurrentDate), page 76 The current date according to the system calendar.
Get(CurrentHostTimestamp), page
76
The host's current date and time (to the nearest second)
according to the system clock.
Get(CurrentTime), page 77 The current time (to the nearest second) according to the system
clock.
Get(CurrentTimestamp), page 78 The current date and time (to the nearest second) according to
the system clock.
Get(CustomMenuSetName), page 78 The name of the active custom menu set.
Get(DesktopPath), page 79 The path to the desktop folder for the current user.
Get(DocumentsPath), page 80 The path to the documents folder for the current user.
Get(ErrorCaptureState), page 80 A Boolean value representing the state of Error capture script
step.
Get(ExtendedPrivileges), page 81 A list of key words for the enabled extended privileges
, separated
by carriage returns
Get(FileMakerPath), page 81 The path to the folder of the currently running copy of FileMaker
Pro.
Get(FileName), page 82 The name of the currently active database file.
Get(FilePath), page 82 The full path indicating the location of the file.
Get(FileSize), page 83 The size (in bytes) of the currently active database file.
Get(FoundCount), page 84 A number that represents the number of records in the current
found set
.
Get(HighContrastColor), page 84 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), page 85 A Boolean value representing the state of the Use High Contrast
checkbox on the Accessibility Options dialog box.
Get(HostIPAddress), page 85 The IP address of the host machine for the current database.
Get(HostName), page 86 The registered name of the computer that is hosting the database
file.
Get(LastError), page 87 A number representing the error, if any, in the execution of the
most recently executed script step.
Get(LastMessageChoice), page 93 A number corresponding to the button clicked in an alert message
displayed by the Show Custom Dialog script step.
Get(LastODBCError), page 94 A string that shows the error state published by ODBC
standards,
based on ISO/IEF standards.
Get(LayoutAccess), page 94 A number corresponding to the layout access privileges assigned
through the Define Accounts & Privileges dialog box.
Get(LayoutCount), page 95 The total number of layouts
in the database file.
Get(LayoutName), page 96 The name of the layout currently displayed.
Get(LayoutNumber), page 96 The number of the layout currently displayed, according to the list
in the Set Layout Order dialog box.
This function Returns