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(HostApplicationVersion)
- 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(TemporaryPath)
- 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
156 FileMaker Functions Reference
KanjiNumeral, page
166
Kanji numerals converted from Arabic numerals.
Katakana, page 167 Zenkaku Katakana converted from Hiragana.
Left, page 167 The specified number of characters in the text, counting from the left.
LeftValues, page 168 The specified number of values in the text, counting from the left.
LeftWords, page 168 The specified number of words in the text, counting from the left.
Length, page 169 The number of characters in the specified text, including all spaces, numbers, and
special characters.
Lower, page 169 All letters in the specified text as lowercase.
Middle, page 170 The specified number of characters in the text, starting at a specified character position.
MiddleValues, page
171
The specified number of values in the text, starting with a specified value.
MiddleWords, page
172
The specified number of words in the text, starting with a specified word.
NumToJText, page
172
Roman numbers converted from Japanese text.
PatternCount, page
173
The number of occurrences of a search string in the specified text.
Position, page 174 The specified occurrence of a search string, starting from a specified position.
Proper, page 175 The first letter of each word in the specified text as uppercase, and all other letters
as lowercase.
Quote, page 175 The specified text surrounded by quotation marks (“ ”).
Replace, page 176 A new string of characters consisting of the specified text as modified by the
specified replacement text.
Right, page 176 The specified number of characters in the text, counting from the right.
RightValues, page
177
The specified number of values in the text, counting from the right.
RightWords, page
178
The specified number of words in the text, counting from the right.
RomanHankaku,
page 178
Hankaku (alphanumeric & symbols) converted from Zenkaku (alphanumeric &
symbols).
RomanZenkaku,
page 179
Zenkaku (alphanumeric & symbols) converted from Hankaku (alphanumeric &
symbols).
SerialIncrement,
page 179
The combined text and numbers in a specified value, with the numbers
incremented by the specified amount.
Substitute, page 180 A text string with every occurrence of a specified search string in the text replaced
by a specified replacement string.
Trim, page 181 Text stripped of all leading and trailing spaces.
TrimAll, page 182 Text with full width spaces between non-Roman and Roman characters removed.
Upper, page 183 All letters in the specified text as uppercase.
ValueCount, page
184
A count of the total number of values in the specified text.
WordCount, page 184 A count of the total number of words in the specified text.
This function Returns