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(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
- GetValue
- Hiragana
- KanaHankaku
- KanaZenkaku
- KanjiNumeral
- Katakana
- Left
- LeftValues
- LeftWords
- Length
- Lower
- Middle
- MiddleValues
- MiddleWords
- NumToJText
- PatternCount
- Position
- Proper
- 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
Get(CalculationRepetitionNumber),
page 73
A number representing the repetition of the calculation field that is
currently being calculated.
Get(CurrentDate), page 73 The current date according to the system calendar.
Get(CurrentHostTimestamp), page
74
The host's current date and time (to the nearest second)
according to the system clock.
Get(CurrentTime), page 75 The current time (to the nearest second) according to the system
clock.
Get(CurrentTimestamp), page 75 The current date and time (to the nearest second) according to
the system clock.
Get(CustomMenuSetName), page 76 The name of the active custom menu set.
Get(DesktopPath), page 76 The path to the desktop folder for the current user.
Get(DocumentsPath), page 77 The path to the documents folder for the current user.
Get(ErrorCaptureState), page 78 A Boolean value representing the state of Error capture script
step.
Get(ExtendedPrivileges), page 78 A list of key words for the enabled extended privileges, separated
by carriage returns
Get(FileMakerPath), page 79 The path to the folder of the currently running copy of FileMaker
Pro.
Get(FileName), page 79 The name of the currently active database file.
Get(FilePath), page 80 The full path indicating the location of the file.
Get(FileSize), page 81 The size (in bytes) of the currently active database file.
Get(FoundCount), page 81 A number that represents the number of records in the current
found set
.
Get(HighContrastColor), page 82 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 82 A Boolean value representing the state of the Use High Contrast
checkbox on the Accessibility Options dialog box.
Get(HostIPAddress), page 83 The IP address of the host machine for the current database.
Get(HostName), page 83 The registered name of the computer that is hosting the database
file.
Get(LastError), page 84 A number representing the error, if any, in the execution of the
most recently executed script step.
Get(LastMessageChoice), page 90 A number corresponding to the button clicked in an alert message
displayed by the Show Custom Dialog script step.
Get(LastODBCError), page 91 A string that shows the error state published by ODBC standards,
based on ISO/IEF standards.
Get(LayoutAccess), page 92 A number corresponding to the layout access privileges
assigned
through the Define Accounts & Privileges dialog box.
Get(LayoutCount), page 92 The total number of layouts in the database file.
Get(LayoutName), page 93 The name of the layout currently displayed.
Get(LayoutNumber), page 93 The number of the layout currently displayed, according to the list
in the Set Layout Order dialog box.
Get(LayoutTableName), page 94 The name of the table that the layout is displaying records from.
This function Returns